Microsoft® Office Access® 2013
Course Content
Level 1 (1 day)
Orientation to Microsoft Access
Create a Simple Access Database
Get Help in Microsoft Access
Working with Table Data
Modify Table Data
Sort and Filter Records
Create Lookups
Querying a Database
Join Data from Different Tables in a Query
Sort and Filter Data in a Query
Perform Calculations in a Query
Creating Advanced Queries
Create Parameter Queries
Create Action Queries
Create Unmatched and Duplicate Queries
Summarize Data
Generating Reports
Create a Report
Add Controls to a Report
Enhance the Appearance of a Report
Prepare a Report for Print
Customizing the Access Environment
The Access Options Dialog Box
Level 2 (1 day)
Designing a Relational Database
Relational Database Design
Create a Table
Create Table Relationships
Joining Tables
Create Query Joins
Join Tables That Have No Common Fields
Relate Data within a Table
Work with Subdatasheets
Create Subqueries
Organising a Database for Efficiency
Data Normalisation
Create a Junction Table
Improve Table Structure
Sharing Data Across Applications
Import Data into Access
Export Data to Text File Formats
Export Access Data to Excel
Create a Mail Merge
Advanced Reporting
Organise Report Information
Format Reports
Include Control Formatting in a Report
Add a Calculated Field to a Report
Add a Subreport to an Existing Report
Level 3 (1 day)
Implementing Advanced Form Design
Add Controls to Forms
Create Subforms
Organize Information with Tab Pages
Enhance Navigation of Forms
Apply Conditional Formatting
Using Data Validation
Field and Record Validation
Form Validation
Using Macros to Improve User Interface Design
Create a Macro
Restrict Records Using a Condition
Validate Data Using a Macro
Automate Data Entry Using a Macro
Convert a Macro to VBA
Using Advanced Database Management
Link Tables to External Data Sources
Manage a Database
Determine Object Dependency
Document a Database
Analyze the Performance of a Database
Distributing and Securing a Database
Splitting a Database for Multiple User Access
Implement Security
Set Passwords
Convert an Access Database to an ACCDE File
Package a Database with a Digital Signature
Managing Switchboards
Create a Database Switchboard
Modify a Database Switchboard
Set Startup Options