Access 2016 - Part 2

You've covered many of the basic functions of Microsoft® Office Access® 2016, 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.

In this course, you will learn to create and manage a fundamental Access 2016 database.  

  • You will:
  • Customize a form layout to improve usability and efficiency of data entry.
  • Share data across applications.
  • Use macros to improve user interface design.
  • Use VBA to enhance tasks.
  • 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.
 
Course Outline
1 - IMPLEMENTING ADVANCED FORM DESIGN
  • Add Controls to Forms
  • Enhance Navigation and Organization of Forms
  • Apply Conditional Formatting
2 - SHARING DATA ACROSS APPLICATIONS
  • Import Data into Access
  • Export Access Data
  • Link Tables to External Data Sources
  • Create a Mail Merge
3 - 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
4 - USING VBA
  • Getting Started with VBA
  • Enhance Access Using VBA
5 - USING ADVANCED DATABASE MANAGEMENT
  • Manage a Database
  • Determine Object Dependency
  • Document a Database
6 - DISTRIBUTING AND SECURING A DATABASE
  • Splitting a Database for Multiple User Access
  • Implement Security
  • Convert an Access Database to an ACCDE File
  • Package a Database with a Digital Signature
7 - MANAGING SWITCHBOARDS
  • Create a Database Switchboard
  • Modify a Database Switchboard
  • Set Startup Options

Actual course outline may vary depending on offering center. Contact your sales representative for more information.

Contact Us For Price

Course Length: 2 Days

1. Choose a Date | 2. Click Enroll Now
Need Help Picking the Right Course? Give us a call! 781-388-0026
Awaiting product image

Description

In this course, you will learn to create and manage a fundamental Access 2016 database.

 

  • You will:
  • Customize a form layout to improve usability and efficiency of data entry.
  • Share data across applications.
  • Use macros to improve user interface design.
  • Use VBA to enhance tasks.
  • 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.

 

© Copyright - Network Technology Academy
AWS Solutions Architect Certification – Associate AWS SysOps Administrator Certification – Associate