I Want Answers
By submitting this form, you are giving your express
written consent for PPG to contact you regarding our
services using email, telephone or text - including our
use of automated technology for calls and periodic texts
to any wireless number you provide.
Access Advanced (2016, 2019, 365)
You've covered many of the basic functions of Microsoft Office 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. Knowledge of these features separate database professionals from the casual database users or occasional designers. Today's training added to that which you've gained from the previous two days round out your Access education and provide you with marketable job skills.
Lesson objectives help students become comfortable with the course, and also provide a means to evaluate learning. Upon successful completion of this course, students will be able to: • Customize a form layout to improve usability and efficiency of data entry. • Add user interface features to validate data entry. • Use macros to improve user interface design. • Organize data into appropriate tables to ensure data dependency and minimize redundancy. • Lock down and prepare a database for distribution to multiple users. • Create and modify a database switchboard and set the startup options.
To ensure the successful completion of Access 2016 Advanced, we recommend completion of one of the following courses, or equivalent knowledge: • Access 2016 Introduction
Lesson 1: Implementing Advanced Form Design Topic A: Add Controls to Forms Topic B: Create Subforms Topic C: Organize 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: Analyze 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
Productivity Point Learning Solutions
evolved out of a desire to increase our outreach
both nationally and internationally.
1580 Sawgrass Corporate Parkway
Sunrise, Florida 33323