Course Content
During the 2 day course you will cover the following topics to prepare you for exam 77-605: Using Microsoft Office Access 2007. During the course, you will have the opportunity to test your knowledge and complete a full practice exam before taking the final exam at the end of day two.
Structuring a Database
•Define data needs and types
•Define and print table relationships
•Add, set, change or remove primary keys
•Split databases
Creating and Formatting Database Elements
•Create databases
•Create tables
•Modify tables
•Create fields and modify field properties
•Create forms
•Create reports
•Modify the design of reports and forms
Entering and Modifying Data
•Enter, edit and delete records
•Navigate among records
•Find and replace data
•Attach documents to and detach from records
•Import data
Creating and Modifying Queries
•Create queries
•Modify queries
Presenting and Sharing Data
•Sort data
•Filter data
•Create and modify charts
•Export data
•Save database objects as other file types
•Print database objects
Managing and Maintaining Databases
•Perform routine database operations
•Manage databases
Please note : these certifications used to be called Microsoft Certified Application Specialist (MCAS). From June 2010 they are now known as Microsoft Office Specialist 2007 (MOS 2007).