Microsoft Office Access 365 is the newest version of Microsoft’s popular database program. This is the second part of a two-level course, and it explores advanced Access features. Whether you’re using Access for the first time, or have been using it for years, this course will help you make the most of Access 365’s features and tools.
In this lesson you will learn how to:
- Split a database for multiple user access
- Manage Switchboards
- Advanced Database Management
- Data Validation
- Using Macros to Improve user Interface Design
Course Topics:
Lesson 1: Distributing and Securing a Database
TOPIC A: Split a Database for Multiple User Access
- Splitting a Database
- The Database Splitter
- Merging a Database
- Activity 5-1: Splitting a Database
TOPIC B: Implement Security
- Security Strategies in Access
- The Message Bar
- The Trust Center Dialog Box
- Trusted Locations
- Activity 5-2: Adding a Trusted Location
TOPIC C: Set Passwords
- Password Protection Guidelines
- Activity 5-3: Setting a Database Password
TOPIC D: Convert an Access Database to an ACCDE File
- The ACCDE File Format
- Activity 5-4: Converting a Database to ACCDE Format
TOPIC E: Package a Database with a Digital Signature
- Digital Signatures
- Digital Certificates
- The Package and Sign Feature
- Activity 5-5: Packaging a Database With a Digital Signature
- Summary
- Review Questions
- Review Question Answers
- Lesson Lab 5-1
- Lesson Lab 5-2
- Course Completion
Lesson 2: Managing Switchboards
TOPIC A: Create a Database Switchboard
- Switchboards
- Switchboard Manager
- Activity 6-1: Creating a Simple Switchboard
TOPIC B: Modify a Database Switchboard
- Switchboard Modification
- Activity 6-2: Modifying a Database Switchboard
TOPIC C: Set Startup Options
- Database Startup Options
- Activity 6-3: Setting Startup Options
- Summary
- Review Questions
- Review Question Answers
- Lesson Lab 6-1
- Course Completion
Lesson 3: Using Advanced Database Management
TOPIC A: Link Tables to External Data Sources
- External Data Sources
- The Linked Table Manager
- Activity 4-1: Link Tables to External Data Sources
TOPIC B: Manage a Database
- Exclusive Mode
- Database Access Modes
- Database Backup
- The Compact and Repair Database Option
- Activity 4-2: Managing a Database
TOPIC C: Determine Object Dependency
- Object Dependency
- Object Dependencies Task Pane
- Activity 4-3: Viewing Object Dependency
TOPIC D: Document a Database
- The Database Documenter
- Activity 4-4: Documenting a Database
TOPIC E: Analyze the Performance of a Database
- Performance Analyzer
- Activity 4-5: Analyzing the performance of a database
- Summary
Lesson 4: Using Data Validation
TOPIC A: Form and Field Validation
- Field Properties
- Input Masks
- The Input Mask Wizard
- Input Mask Characters
- Lookup Lists
- Expression Builder
- Record Validation
- Activity 2-1: Validating Data With a Field Property
TOPIC B: Data Validation Using Controls
- Control Wizards
- The Combo Box Control
- The List Box Control
- The Option Group Control
- Activity 2-2: Using Combo Box Controls in a Form
- Summary
- Review Questions
- Review Question Answers
- Lesson Lab 2-1
- Course Completion
Lesson 5: Using Macros to Improve user Interface Design
TOPIC A: Create a Macro
- Macros
- The Macro Builder Window
- Macro Actions
- Types of Macro Actions
- Action Arguments
- Object Events
- Activity 3-1: Creating a Macro
TOPIC B: Restrict Records Using a Condition
- Macro Conditions
- The Where Condition
- Activity 3-2: Using the Where Condition to Restrict Data
TOPIC C: Validate Data Using a Macro
- Event Properties for Data Validation
- Macro Action for Data Validation
- Embedded Macros
- Activity 3-3: Validating Data Using a Macro
TOPIC D: Automate Data Entry Using a Macro
- Event Properties for Automating Data Entry
- Macro Actions for Automating Data Entry
- Activity 3-4: Automating Data Entry Using a Macro
TOPIC E: Convert a Macro to VBA
- Macros and VBA
- Activity 3-5: Converting a Macro to VBA
- Summary
- Review Questions
- Review Question Answers
- Lesson Lab 3-1
- Lesson Lab 3-2
- Course Completion