You’ve covered many of the basic functions of Microsoft Access and now you’re ready to learn advanced Access features such as: database management, advanced form design, packaging a database, encrypting a database, preparing a database for multi-user access and more.
Target Audience:
Your training in and use of Microsoft Access has provided you with a solid foundation in the basic and intermediate skills. You have worked with the various Access objects, such as tables, queries, forms and reports.
Prerequisites
- Understand the steps required to properly design a database
- Create a database
- Create tables and table relationships
- Control data entry with field properties
- Create queries and understand query joins
- Create reports and subreports
- Add and format controls on forms and reports
- Import and export data
Delegates will learn how to
At the end of this course you will be able to:
- Create and customise advanced forms
- Work with data validation
- Create and revise Access macros
- Use tools to manage database efficiency
- Distribute and secure databases
- Work with switchboards and startup options
Outline
Lesson 1: Implementing Advanced Form Design
- Topic A: Add Controls to Forms
- Topic B: Create Subforms
- Topic C: Organise Information with Tab Pages
- Topic D: Enhance Navigation of Forms
- Topic E: Apply Conditional Formatting
Lesson 2: Using Data Validation
- Topic A: Field and Record Validation
- Topic B: Form Validation
Lesson 3: Using Macros to Improve User Interface Design
- Topic A: Create a Macro
- Topic B: Restrict Records Using a Condition
- Topic C: Validate Data Using a Macro
- Topic D: Automate Data Entry Using a Macro
- Topic E: Convert a Macro to VBA
Lesson 4: Using Advanced Database Management
- Topic A: Link Tables to External Data Sources
- Topic B: Manage a Database
- Topic C: Determine Object Dependency
- Topic D: Document a Database
- Topic E: Analyse the Performance of a Database
Lesson 5: Distributing and Securing a Database
- Topic A: Splitting a Database for Multiple User Access
- Topic B: Implement Security
- Topic C: Set Passwords
- Topic D: Convert an Access Database to an ACCDE File
- Topic E: Package a Database with a Digital Signature
Lesson 6: Managing Switchboards
- Topic A: Create a Database Switchboard
- Topic B: Modify a Database Switchboard
- Topic C: Set Startup Options