Microsoft Access Level 2 – Office 2016/Office 365
This training course will take your Microsoft Access skills to the next level and enroll now and receive step-by-step mentoring on mastering Microsoft Access at an intermediate level. You will learn how to work with more advanced Access features including: Lookup Fields, Parameter and Update Queries, Filter and Sort records, Combo Box and how to Keep Groups Together.
2 Days
Microsoft Access
7 PDUs
Personal Development Unit
MS Access Level 2 – Advance
IMPLEMENTING ADVANCED FORM DESIGN
- Add Controls to Forms
- Create Subforms
- Organize Information with Tab Pages
- Enhance Navigation of Forms
- Apply Conditional Formatting
USING DATA VALIDATION
- Field and Record Validation
- Form Validation
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
ADVANCED REPORTING
- Organize Report Information
- Format Reports
- Include Control Formatting in a Report
- Add a Calculated Field to a Report
- Add a Subreport to an Existing Report
DISTRIBUTING AND SECURING A DATABASE
- Splitting a Database for Multiple User Access
- Implement Security
- Set Passwords
- Package a Database with a Digital Signature
MANAGING SWITCHBOARDS
- Create a Database Switchboard
- Modify a Database Switchboard
- Set Startup Options
SHARING DATA ACROSS APPLICATIONS
- Import Data into Access
- Export Data to Text File Formats
- Export Access Data to Excel
- Create a Mail Merge
Workshop Wrap-Up
At the end of the course, students will have an opportunity to ask questions.
