Advanced Guide to Microsoft Access 2010

The Advanced Guide to Microsoft Access 2010 course is designed for students to improve their knowledge of Microsoft Access in preparation for Certification Exam 77-885: MOS: Microsoft Office Access 2010. This course covers the following topics: Create and Manage databases Create Tables, add Fields and specify the Data Type Create Forms with a Wizard, Quick Parts and in Design View Create Forms for data entry as well as list view Use Queries to combine Fields, Group, Sort and Total Create Reports and format the content, Header, Footer and layout Manage and maintain an Access database Create a strategy for archiving data with Action Queries