Access 365 - Part 2

Course Description

This course is intended to build on foundational knowledge that was gained in Access 365 - Part 1 to impart an intermediate level of knowledge of Access 365. We will cover how to complete advanced form design tasks, add data validation, explore macros, better manage databases, secure databases and implement switchboards.
1 Day
Contact us for pricing
 

Implementing Advanced Form Design

Add Controls to Forms
Set Form Controls
Create Subforms
Organize Information with Tab Pages
Enhance Navigation with Forms
Format a Form
Apply Conditional Formatting

Using Data Validation

Form and Field Validation
Data Validation Using Controls

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

Split 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

AccessMS AccessMicrosoft AccessOffice 365Access 365