MS Access - Level III, CMP963
This course builds on the skills and concepts taught in Access 2013 Level II. Learn how to query with SQL; create crosstab, parameter, and action queries; create macros; import, export, and link database objects; interact with XML documents; create hyperlink fields; optimize, split, and back up databases; password-protect and encrypt databases; and set Access options and properties. This course follows the curriculum for the Microsoft Office Specialist core-level for Access 2013 (exam 77-424). For comprehensive certification training, students should complete MS Access Levels I, II, III. Prerequisites: MS Access Level II or equivalent experience, Working with Windows or File Management Skills or equivalent experience.
Textbook: Please bring your textbook to the first class session. See MC Bookstores for more information on your textbook; bring to first class along with a USB Flash Drive/memory stick (at least 512 MB).
Course Objectives: 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 summaries 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 make new tables.
- Create and run macros to automate tasks; and attach macros to 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 format 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.