Access for Office 365 – Part 2 – Network Technology Academy

Access for Office 365 - Part 2

In this course, you will expand your knowledge of relational database design; promote quality input from users; improve database efficiency and promote data integrity; and implement advanced features in tables, queries, forms, and reports. Extending your knowledge of Access will result in a robust, functional database for your users. This course covers Microsoft Office Specialist Program exam objectives to help you prepare for the Access Expert (Office 365 and Office 2019): Exam MO-500 certification.

Learning Objectives

In this course, you will optimize an Access database.

You will:
Provide input validation features to promote the entry of quality data into a database.
Organize a database for efficiency and performance, and to maintain data integrity.
Improve the usability of Access tables.
Create advanced queries to join and summarize data.
Use advanced formatting and controls to improve form presentation.
Use advanced formatting and calculated fields to improve reports.

Course Outline

1 - IMPROVING TABLE USABILITY

Topic A: Create Lookups Within a Table
Topic B: Work with Subdatasheets

2 - CREATING ADVANCED QUERIES

Topic A: Create Query Joins
Topic B: Create Subqueries
Topic C: Summarize Data

3 - IMPROVING FORM PRESENTATION

Topic A: Apply Conditional Formatting
Topic B: Create Tab Pages with Subforms and Other Controls

4 - CREATING ADVANCED REPORTS

Topic A: Apply Advanced Formatting to a Report
Topic B: Add a Calculated Field to a Report
Topic C: Control Pagination and Print Quality
Topic D: Add a Chart to a Report

5 - IMPORTING AND EXPORTING TABLE DATA

Topic A: Import and Link Data
Topic B: Export Data
Topic C: Create a Mail Merge

6 - USING QUERIES TO MANAGE DATA

Topic A: Create Action Queries
Topic B: Create Unmatched and Duplicate Queries

7 - CREATING COMPLEX REPORTS AND FORMS

Topic A: Create Subreports
Topic B: Create a Navigation Form
Topic C: Show Details in Subforms and Popup Forms

8 - 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

9 - USING VBA TO EXTEND DATABASE CAPABILITIES

Topic A: Introduction to VBA
Topic B: Using VBA with Form Controls

10 - MANAGING A DATABASE

Topic A: Back Up a Database
Topic B: Manage Performance Issues
Topic C: Document a Database

11 - 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

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

Mar 24

Online LIVE, 6:00 am - 2:00 pm
NHCLC G2R

Jun 23

Online LIVE, 8:00 am - 4:00 pm
NHCLC G2R

Need Help Picking the Right Course? Give us a call! 781-388-0026