Access 2007 Advanced

Target student

The target student for this course should be comfortable using a personal computer and
Microsoft Windows XP or later. Students should also have some experience using
Access 2007. They’ll get the most out of this course if their goal is to become proficient
using more advanced Access features and functions, such as querying with SQL, using
crosstab, parameter, and action queries, creating and running macros, importing,
exporting and linking database objects, optimizing a database, and basic database
security.

After completing this course, students will know how to:

• Use SQL statements and examine them in Access, create aliases for fields, write
  SQL statements to create queries, and attach an SQL statement to a command
  button.
• Create crosstab queries to summarize grouped data, create parameter queries to
  view results based on specified criteria, and create action queries to add, delete,
  and modify data in tables and to make new tables.
• Create and run macros to automate tasks and attach macros to the events of
  database objects.
• Create data validation and data-entry macros, create macros that run parameter
  queries, create the AutoKeys and AutoExec macros, and create macros to import
  and export database objects.
• Import Access objects from another Access database, from Excel, and from a
  CSV file. Export objects from one database to another. Create and use Save
  Import specifications and Saved Export specifications. Export and import XML
  documents and save objects as an XPS file. Link objects from one database to
  another and update the links, and link to Excel workbooks. Export and import
  tables and queries to the Windows SharePoint Services site.
• Save to previous versions. Split, compact, repair, and back up a database.
  Encrypt and password-protect database files. Configure Access Options and
  populate database file properties.
• Create, populate, and modify a hyperlink field. Collect data via e-mail by using
  Outlook 2007.