MS Access Training Part 2

Course Objectives

In Part 2 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; You will also use advanced formatting and controls to improve form presentation. Lastly you will learn advanced formatting and calculated fields to improve reports.

Agenda

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 Sub forms 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 Sub reports
  • Topic B: Create a Navigation Form
  • Topic C: Show Details in Sub forms 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: Restrict Records by Using a Condition
  • Topic D: Create a Data Macro


9 - USING VBA TO EXTEND DATABASE CAPABILITIES

  • Topic A: Getting Started with 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

Course Prerequisites

While there are no prerequisites for this course database familarity and design is recommended.


Course Delivery

This is a 2-day course delivered as a Virtual Instructor Led class.

Price
$ 590.00

Stock number:

ACC2

Price:

$590.00