Using Microsoft® Office Access® 2007
  1. Structuring a Database
    • Define data needs and types
    • Define and print table relationships
    • Add, set, change, or remove primary keys
    • Split databases

  2. 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

  3. 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

  4. Creating and modifying queries
    • Create queries
    • Modify queries

  5. Presenting and Sharing Data
    • Sort data
    • Filter data
    • Create and modify charts
    • Export data
    • Save database objects as other file types
    • Print database objects

  6. Managing and Maintaining Databases
    • Perform routine database operations
    • Manage Databases

    This training prepares you to take Microsoft certification exam 70-605.

    Syllabus PDF (956 kb)