|
Microsoft Office Access Level 3
Overview:
Level 3 will focus on advanced user options including writing advanced queries, macros, effective front-ends with forms, advanced report options and maintaining and Access Database
Duration:
1 day
Prerequisite Comments:
To attend this course, participants should have attended the Level 1 and 2 courses or a comparable course that covers the Level 1 & 2 topics:
Click here for Access Level 1 outline
Click here for Access Level 2 outline
Course Outline:
Module 1: Simplifying Tasks with Macros
Create a Macros
Macros
The Macro Builder Window
Macro Actions
Action Arguments
Attach a Macro
Object Events
Restrict Records using a Condition
Macros Conditions
Where conditions
Validate Data using a Macro
Event Properties for Data Validation
Planning a Macro
Embedded Macros
Automate Data entry using a Macro
Event Properties for Automating Data Entry
Macro Actions for Automating Data Entry
Module 2: Making more effective uses of Forms
Macros and Command buttons
Form structure and properties
Form structure using controls
Tab Control
Sub-forms
Startup Options
Smart Tags
Module 3: Maintaining an Access Database
Link Tables to an External Data Source
External Data Sources
File Links
The Linked Table Manager
Manage a Database
Database Management
Database Backup
The Compact and Repair Database Option
Determine Object Dependencies
Database Documenter
Performance Analyser
Database Options
Module 4: Distributing and Securing Databases
Split a Database
Front-end and back-end databases
The Database splitter
Implement Security
Security Strategies in Access
The Message Bar
The Trust Centre dialog box
Trusted Locations
Set Passwords
Database Access Modes
Types of Passwords
ACCDE File Formats
Digital Signatures
|