Microsoft Access for Office 365: Part 3

1 Day | Price: $295

This course teaches advanced Access features such as database management, advanced form design, packaging a database, encrypting a database, preparing a database for multiple-user access, and more. This course is the third part of a three-course series that covers the skills needed to perform basic database design and development in Access. Microsoft Access for Office 365: Part 3 (this course): Focuses on managing the database and supporting complex database designs, including import and export of data; using action queries to manage data; creating complex forms and reports; macros and Visual Basic for Applications (VBA); and tools and strategies to manage, distribute, and secure a database. This course may be a useful component in your preparation for the Microsoft Access Expert (Microsoft 365 Apps and Office 2019): Exam MO-500 certification exam.

Learning Objectives

In this course, you will manage an Access database and add complex database features to improve its usability, efficiency, performance, and security. You will:
  • Share data across applications.
  • Use action, unmatched, and duplicate queries to manage data.
  • Create complex reports and forms.
  • Use macros to improve user interface design.
  • Use VBA to extend database capabilities.
  • Perform database management tasks such as backup, compacting, repairing, performance analysis, checking object dependencies, and documenting.
  • Implement security strategies and distribute a database to multiple users.
Lesson 1: Importing and Exporting Table Data
  • Topic A: Import and Link Data
  • Topic B: Export Data
  • Topic C: Create a Mail Merge
Lesson 2: Using Queries to Manage Data
  • Topic A: Create Action Queries
  • Topic B: Create Unmatched and Duplicate Queries
Lesson 3: Creating Complex Reports and Forms
  • Topic A: Create Subreports
  • Topic B: Create a Navigation Form
  • Topic C: Show Details in Subforms and Popup Forms
Lesson 4: Creating Access Macros
  • Topic A: Create a Standalone Macro to Automate Repetitive Tasks
  • Topic B: Create a Macro to Program a User Interface Component
  • Topic C: Filter Records by Using a Condition
  • Topic D: Create a Data Macro
Lesson 5: Using VBA to Extend Database Capabilities
  • Topic A: Introduction to VBA
  • Topic B: Use VBA with Form Controls
Lesson 6: Managing a Database
  • Topic A: Back Up a Database
  • Topic B: Manage Performance Issues
  • Topic C: Document a Database
Lesson 7: Distributing and Securing a Database
  • Topic A: Split a Database for Multiple-User Access
  • Topic B: Implement Security
  • Topic C: Convert an Access Database to an ACCDE File
  • Topic D: Package a Database with a Digital Signature
StartsRegister