MS Access 2010/2013/2016: Level 3

Course Description

This course will teach students more specialized and advanced capabilities of Access. The student will use advanced capabilities to work with improperly structured data, perform summary operations on data, create macros to automate tasks, enhance forms and reports, and use Access data in other Office applications. This course targets students who have job responsibilities that include structuring existing data into properly designed tables, analyzing data, automating work in Access, implementing advanced form and report capabilities, and using Access tools.

Prerequisites

To ensure your success, we recommend you first take the following courses or have equivalent knowledge: MS Access Level 1 and 2.

Course Objectives

Upon successful completion of this course, students will be able to:

• Put existing data into correctly designed tables and compact your database.
• Use a variety of techniques to summarize data. Create and revise basic Access macros.
• Create macros that require data entry in certain fields and automatic data entry in others.
• Use advanced features to enhance forms.
• Use advanced features to enhance reports and distribute a report to non-Access users.
• Use Office Links to use Access data in other Office programs.

Course Content

Lesson 1: Structuring Existing Data
Topic 1A: Use the Table Analyzer Wizard for Help
Topic 1B: Decide on Your Own Design
Topic 1C: Create a Junction Table
Topic 1D: Modify the Original Tables and Complete the Design
Topic 1E: Compact and Repair a Database

Lesson 2: Summarizing Data
Topic 2A: Group and Summarize Records in Different Ways
Topic 2B: Summarize with a Crosstab Query
Topic 2C: Pivot Query Results
Topic 2D: Display a Graphical Summary on a Form

Lesson 3: Simplifying Tasks with Macros
Topic 3A: Create a Macro
Topic 3B: Attach a Macro to a Command Button
Topic 3C: Restrict Records

Lesson 4: Adding Interaction and Automation with Macros
Topic 4A: Require Data Entry with a Macro
Topic 4B: Display a Message Box with a Macro
Topic 4C: Automate Data Entry

Lesson 5: Making Forms More Usable
Topic 5A: Change the Display of Data Under Certain Conditions
Topic 5B: Display a Calendar on a Form
Topic 5C: Organize Information with Tab Pages

Lesson 6: Making Reports More Powerful
Topic 6A: Cancel Printing of a Blank Report
Topic 6B: Include a Chart
Topic 6C: Arrange Data in Columns
Topic 6D: Distribute Reports as a Snapshot

Lesson 7: Expanding the Reach of Your Data
Topic 7A: Merge Access Data with a Word Document
Topic 7B: Publish Access Data as a Word Document
Topic 7C: Analyze Access Data in Excel

Appendix A: Access Object Names