Microsoft Office 2010 Expert, Office 2007 Expert, software speaker, software training, consulting, software tips & tricks, Office 2007 trainer, Microsoft Word, Microsoft Excel, Microsoft PowerPoint, Microsoft Access, Microsoft Outlook, tips, Microsoft Office 2007 trainingSoftware Tips & Tricks, Expert Speaker, Microsoft Office 2010 Training, Microsoft Certified Trainer, Microsoft Office Consultant, Books, Videos, Web Training  
 Home Products Programs Meet Dawn Free E-zine Media Room Contact 
Access 2007  

Technology Trainer
Software & Tech Speaker
Software Consultant
Tips & Tricks
The Pro Shop
Free Software Articles
How-To Lessons
Tips Newsletter
Bonus Resources

 
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)
WBENC Certified

WOSB (Women-Owned Small Business) Certified

(303) 699-6868
Dawn@TheSoftwarePro.com

>>Back to Articles Home

Access 2007: Top 7 New Features

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:

  1. Access 2007 includes professionally designed Database Templates for building complete tracking applications that contain pre-defined tables, forms, reports, queries, macros, and relationships.
     
  2. By using the Report View, you can browse an accurate rendering of your report without having to print or display it in Print Preview.
     
  3. 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 report.
     
  4. 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 create.
     
  5. 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 dates.
     
  6. 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.
     
  7. 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.
>>Learn 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
 


microsoft office 2007, new features, office interface, word 2007, moving to office 2007, excel 2007, microsoft office powerpoint 2007, outlook 2007, microsoft office access 2007, tips, tricks, techniques, switch, upgrade, update, ms office 2007 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!

Go To Top of Page
 



Home for Dawn Bjork Buzbee, The Software Pro
Contact Dawn Bjork Buzbee, The Software Pro
Access 2007 Tip
Press [Alt] + F to open the new Microsoft Office Button and to access file management commands and more.
 

 
www.TheSoftwarePro.com
HomeContact Us | Training | Speaking | Consulting | Services | Tips & Tricks | Products | How-To Lessons | Free Articles | Newsletter | Resources | Site Map

© Copyright 2015 The Software Pro® & Dawn Bjork Buzbee - All Rights Reserved
(303) 699-6868
§ Dawn@TheSoftwarePro.com § www.TheSoftwarePro.com
Geek Speak Becomes People Friendly

Microsoft Certified Trainer (MCT)
§ Certified Microsoft Office 2013 Specialist (MOS 2013) Master
Certified Microsoft Office 2010 Specialist (MOS 2010) Master Instructor
§ Microsoft Certified Application Specialist (MCAS) Instructor
Certified Microsoft Office Specialist (MOS) Master Instructor
§ Certified Microsoft Office Expert
Certified Women's Business Enterprise (WBE) WBENC Certified
§ WOSB (Women-Owned Small Business) Certified
The Software Pro
® is a registered trademark
Terms & Conditions       Privacy Policy