CMP 963 - Microsoft Access - Level III
Registration Option: Open Enrollment
Total Course Hours: 12
Materials: You must purchase Textbook(s)/ materials and bring them to the first class
Description
Learn how to query with SQL; create crosstab, parameter, and action queries; create macros; import and export; and link database objects. Work with XML documents and use hyperlink fields. Learn database management using resources and protecting databases.
Students pursuing the Microsoft Office Specialist Certification must take MS Access I, II and II. Find out more information about Microsoft Office Specialist (MOS) Certification.
Prerequisites
MS Access—Levels I and II or equivalent experience.
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.