Microsoft Office Access 2016: Part 32021-06-28T13:53:17-04:00

Summary

Microsoft Office Access 2016: Part 3

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 multiple-user access, and more. Knowledge of these features separate database professionals from the casual database users or occasional designers.

This course is the third part of a three-course series that covers the skills needed to perform database design and development in Access.
– Microsoft Office Access 2016: Part 1
– Microsoft Office Access 2016: Part 2
– Microsoft Office Access 2016: Part 3 (this course)

You can also use the course to prepare for the Microsoft Office Specialist (MOS) Certification exam for Microsoft Access 2016.

Completion of this course will earn 0.575 CEUs.

  • Dates: Sep 16, 2021
  • Times: 9:00 am - 4:30 pm
  • Location: Louisville
  • Seats: 12
  • Price: $325

Introduction

Course 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.

Target Student:

Students taking this course are database administrators or prospective database administrators who have experience working with Microsoft Access for Office 365 and need to learn advanced skills.

Prerequisites:

To ensure your success in this course, you should have experience working with Access for Office 365, including a working knowledge of database design and creation, form design and creation, report design and creation, and a working knowledge of database querying and the various table relationships. You can obtain this level of skills and knowledge by taking the following Logical Operations courses:

Microsoft® Access® for Office 365™: Part 1
Microsoft® Access® for Office 365™: Part 2

Outline

  • Lesson 1: Implementing Advanced Form Design

    • Topic A: Add Controls to Forms
    • Topic B: Enhance Navigation and Organization of Forms
    • Topic C: Apply Conditional Formatting
  • Lesson 2: Sharing Data Across Applications

    • Topic A: Import Data into Access
    • Topic B: Export Access Data
    • Topic C: Link Tables to External Data Sources
    • Topic D: Create a Mail Merge
  • 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
  • Lesson 4: Using VBA

    • Topic A: Getting Started with VBA
    • Topic B: Enhance Access Using VBA
  • Lesson 5: Using Advanced Database Management

    • Topic A: Manage a Database
    • Topic B: Determine Object Dependency
    • Topic C: Document a Database
  • Lesson 6: Distributing and Securing a Database

    • Topic A: Splitting 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
  • Lesson 7: Managing Switchboards

    • Topic A: Create a Database Switchboard
    • Topic B: Modify a Database Switchboard
    • Topic C: Set Startup Options