Motivational Speaking, Business Coaching, Corporate Training, Cyber Security, Web Design, Consulting

Access Level 3 Outline

 

Lesson 1 -  Using Subforms/Subreports

Working with Subforms/Subreports

Creating a Subform/Subreport

Editing the Layout of a Subform

Displaying a Subform in Datasheet View

Displaying a Subform/Subreport Total

 

Lesson 2 -  Using Other Form Techniques

Creating a Split Form

Converting an Existing Form to a Split Form

Editing a Split Form

Adding a Command Button

Saving a Form as a Report

 

Lesson 3 -  Working with Indexes

Viewing Indexes

Creating a Single Field Index

Creating a Multiple Field Index

Deleting an Index

Creating a Multiple Field Primary Key

 

Lesson 4 -  Using Access and the Internet

Working with Hyperlinks

Creating a Hyperlink Field

Inserting a Hyperlink Field

Editing a Hyperlink Field

Deleting a Hyperlink Field

 

Lesson 5 -  Using Access Database Security

Encrypting a Database with a Password

Opening and Decrypting a Database

Removing a Database Password

 

Lesson 6 -  Customizing the Navigation Pane

Creating Custom Categories

Creating Custom Groups

Adding Database Objects to a Group

Showing/Hiding the Unassigned Objects Group

Deleting Objects from a Group

 

Lesson 7 -  Exporting Data

Exporting Data to an Excel Workbook

Saving Export Setup

Dragging and Dropping Data into Excel

Creating Word Mail Merge Documents

​

Lesson 8 - Building a Database

Creating and Customizing Tables

Importing Data

Creating and Customizing Forms and Subforms

Creating and Customizing Queries

Creating and Customizing Reports

​