MS Access (2010 Advanced)

Course Description:

After completing this 1-day Access 2010 Advanced training course, students will know how to:

• Use SQL statements in Access
• Create aliases for fields
• Write SQL statements to create queries
• Attach SQL statements to command buttons
• Create crosstab queries to summarize grouped data
• Create parameter queries to view results based on specified criteria
• Create action queries to add, delete, and modify data in tables and to make new tables
• Create and run macros to automate tasks
• 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
• 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
• 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
• Populate database file properties