Dawn Bjork Buzbee
The Software Pro®
Microsoft Certified Trainer (MCT)
Certified Microsoft Office 2010 Specialist (MOS 2010) Master Instructor
Certified Microsoft Office 2007 Specialist (MOS 2007) Master Instructor
Microsoft Certified Application Specialist (MCAS) Instructor
Certified Microsoft Office Expert
Certified Women's Business Enterprise (WBE)
WOSB (Women-Owned Small Business) Certified
>>Back to Articles Home
In addition to the dramatically different user interface and new file
formats shared with other Microsoft Office 2007 programs, Microsoft Office Access 2007 provides a powerful set of tools that help you to
quickly start tracking, reporting, and sharing information:
- Access 2007 includes professionally designed Database
Templates for building complete tracking applications that
contain pre-defined tables, forms, reports, queries, macros, and
- By using the Report View, you can browse an accurate rendering
of your report without having to print or display it in Print
- Use the new Layout View to more quickly make design changes
while you view data in a form or report. With the Layout View and
the new Group, Sort, and Total pane, you can add a group level and
request a total which will show you the changes live, in your
- The Navigation Pane replaces the Database window from earlier
versions of Access. This pane lists and provides easy access and
organization to all of the objects in the currently open database.
Use the Navigation Pane to organize your objects by object type,
date created, date modified, or even by custom groups that you
- New Data Types and controls include multi-valued fields for
complex data, attachment fields for files, enhanced memo fields, and
date/time fields that automatically employ a calendar for picking
- Datasheet improvements include a Total row, in which you can
display a sum, count, and other calculations directly in the
datasheet. Access 2007 automatically determines the best data type
for each field so that you are up and running in no time. You can
now even paste data from Microsoft Office Excel 2007 tables into a
new datasheet—Access 2007 creates all of the fields and recognizes
the data types automatically.
- You can now display your database objects in Tabbed Documents
instead of overlapping windows. This tabbed document interface is
optional so you can choose the best environment for Access 2007.
© Dawn Bjork Buzbee, MCT, The Software Pro®
Dawn Bjork Buzbee
is The Software Pro®
and a Microsoft Certified Trainer (MCT) as well as a certified Microsoft Office
Specialist (MOS) Master Instructor, certified Microsoft Applications Specialist
(MCAS) Instructor, and a certified Microsoft Office expert. Dawn shares smart
and easy ways to effectively use software through her work as a software
speaker, trainer, consultant, and author of 8 books.
This article and
more can be reprinted at no charge in your publications and website with
copyright and attribution.
more about how easy it is to share these valuable tips, tricks, and techniques.
More Microsoft Office 2007 Articles
More Smart & Easy Software Tips, Tricks &
Techniques for You
<<Back to Articles
Make the Most of Access 2007 with...
Moving to Microsoft Office 2007
Tips, Tactics and
Timesavers to Become More Productive with Microsoft Office 2007
Value priced for as little as $15!
Click Here to Grab Your Copy Now!
Press [Alt] + F to open the
new Microsoft Office Button and to access file management
commands and more.