Microsoft Access (77-605)

Skills


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.

Microsoft Access Certification


Microsoft certifications demonstrate your computing skills and help advance your career prospects in a competitive job market. Microsoft Certified Application Specialist certifications are primarily for office workers who use Microsoft Office programs as a vital part of their job functions.
  • Microsoft Access 2007 - MCAS