Microsoft Office 2016 Access Advanced

Course details

The Microsoft Office 2016 Access Advanced course comes highly recommended for individuals seeking to master the intricacies of Microsoft Access and its advanced functionalities.

Microsoft Access, an integral part of the Microsoft Office suite, serves as a database program. It operates as a database management system, utilizing the Access Jet Database Engine to store data in its proprietary format. Moreover, it facilitates the direct import or linking to data from various applications and databases.

Throughout this course, participants will delve into advanced features such as linking to diverse data sources and optimizing the use of forms and queries. Additionally, they will gain insights into the process of dividing a database by separating the frontend and backend components. Furthermore, the curriculum covers the creation and maintenance of macros, along with the utilization of Visual Basic for Applications (VBA).

Microsoft Office 2016 Access Advanced Course Learning Outcomes:

• Efficiently design and enhance forms in Microsoft Access.
• Master advanced data management techniques, including importing, exporting, and linking data.
• Create and implement macros for automating data validation and entry.
• Gain proficiency in database management, including documenting and determining object dependencies.
• Understand the process of splitting a database for multiple user access and implementing security measures.
• Create and customize a database switchboard, along with configuring start-up options.

Microsoft Office 2016 Access Advanced Course Outline:

Module 01:

• Add Controls to Forms (FREE)
• Enhance Navigation and Organization of Forms
• Apply Conditional Formatting

Module 02:

• Import Data into Access
• Export Access Data
• Link Tables to External Data Sources
• Create a Mail Merge

Module 03:

• Create a Macro
• Restrict Records by Using a Condition
• Validate Data by Using a Macro
• Automate Data Entry by Using a Macro

Module 04:

• Manage a Database
• Determine Object Dependency

Module 05:

• Manage a Database
• Determine Object Dependency
• Document a Database

Module 06:

• Splitting a Database for Multiple User Access
• Implement Security
• Convert an Access Database to an ACCDE File
• Package a Database with a Digital Signature

Module 07:

• Create a Database Switchboard
• Modify a Database Switchboard
• Set Start-up Options

  Updated on 05 December, 2023