Microsoft Access 365 Part 2 - eBSI Export Academy
Microsoft Access 365 Part 2 - eBSI Export Academy
Microsoft Access 365 Part 2 - eBSI Export Academy

 

Book a Consultation

Microsoft Access 365 Part 2

Vendor
eBSI Export Academy
Regular price
$44.00
Sale price
$44.00
Tax included. Shipping calculated at checkout.

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