Access 2010 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 with using
Access 2010. They’ll get the most out of this course if their goal is to become proficient
in more advanced tasks, such as querying with SQL; using crosstab, parameter, and
action queries; creating and running macros; importing, exporting, and linking database
objects; optimizing databases; and implementing basic database security.

After completing this course, students will know how to:

• Use SQL statements in Access; create aliases for fields; write SQL statements to
  create queries; and attach a 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 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; export and import XML
  documents; save objects as XPS files; link Access objects between databases
  and to Excel workbooks; and create hyperlink fields.
• Save databases in file formats for previous versions of Access; use the
  Performance Analyzer; split, compact, repair, and back up databases; encrypt
  and password-protect database files; configure Access Options; and populate
  database file properties.