MS Access - Level III, CMP963
Summer 2014 Course Description: (Click here forFall 2014 Description) Build on the skills acquired in MS Access II. Learn how to query with SQL; create crosstab, parameters, and action queries, create macros, import, export, and link database objects. Work with XML documents and use hyperlink fields. Learn database management by optimizing resources and protecting databases. This course follows curriculum for the Microsoft Office Specialist exam for Access 2010 (exam 77-885). For comprehensive certification training, you should complete MS Access Level I, II, and III.
Prerequisites: Prerequisite: MS Access--Level I & II 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).
Classroom Hours: 10
Table Of Contents:
Unit 1: Querying with SQL
Topic A: SQL and Access
Topic B: Writing SQL statements
Topic C: Attaching SQL queries to controls
Unit 2: Advanced queries
Topic A: Creating crosstab queries
Topic B: Creating parameter queries
Topic C: Using action queries
Unit 3: Macros
Topic A: Creating, running, and modifying macros
Topic B: Attaching macros to the events of database objects
Unit 4: Advanced macros
Topic A: Creating macros to provide user interaction
Topic B: Creating macros that require user input
Topic C: Creating AutoKeys and AutoExec macros
Topic D: Creating macros for data transfer
Unit 5: Importing, exporting, and linking objects
Topic A: Importing objects
Topic B: Exporting objects
Topic C: Working with XML documents
Topic D: Linking Access objects
Topic E: Using hyperlink fields
Unit 6: Database management
Topic A: Optimizing resources
Topic B: Protecting databases
Topic C: Setting options and properties
MS- ACCESS –LEVEL III
FALL 2014 Description: 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.