Access Advanced Course

-2147467259-[Microsoft][ODBC Visual FoxPro Driver]Error reading file.

Access Advanced Course

Overview

Your training and experience using Microsoft® Access® has given you basic database management skills such as creating tables, designing forms and reports, and building queries. In this course, you will expand your knowledge of relational database design, write advanced queries, structure existing data, share data across applications, and customize reports. Extending your knowledge of Microsoft Access will result in a robust, functional database for your users.

You can also use this course to prepare for the Microsoft Office Specialist (MOS) Certification exams for Microsoft Access. Learn about MOS Access certification .

* Version Note *

This course is appropriate for those with Access 2019 and newer software as there are very few differences between the versions from the end-user's perspective.

Target Student

This course is designed for students wishing to gain intermediate-level skills or individuals whose job responsibilities include constructing relational databases, performing database maintenance, creating advanced queries and reports, or integrating Access with other programs.

Prerequisites

Access Introduction Course or equivalent knowledge to ensure your success.

COURSE OUTLINE

Lesson 1: Organizing a Database for Efficiency

Topic A: Data Normalization
Topic B: Create a Junction Table
Topic C: Improve Table Structure

Lesson 2: Joining Tables

Topic A: Create Query Joins
Topic B: Relate Data Within a Table
Topic C: Work with Subdatasheets

Lesson 3: Creating Advanced Queries

Topic A: Create Parameter Queries
Topic B: Summarize Data
Topic C: Create Subqueries
Topic D: Create Action Queries
Topic E: Create Unmatched and Duplicate Queries

Lesson 4: Using Advanced Reporting Techniques

Topic A: Include Control Formatting in a Report
Topic B: Add a Calculated Field to a Report
Topic C: Add a Subreport to an Existing Report

Lesson 5: Implementing Advanced Form Design

Topic A: Add Controls to Forms
Topic B: Enhance Navigation and Organization of Forms
Topic C: Apply Conditional Formatting

Lesson 6: Using Data Validation

Topic A: Use Field Validation
Topic B: Use Form and Record Validation

Lesson 7: 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 8: Using Advanced Database Management

Topic A: Manage a Database
Topic B: Determine Object Dependency
Topic C: Document a Database

View outline in Word

WACM19

Attend hands-on, instructor-led Access Advanced training classes at ONLC's nationwide locations. Not near one of our locations? Attend these same live classes from your home/office PC via our Remote Classroom Instruction (RCI) technology.

For additional training options, check out our list of Courses and select the one that's right for you.

GENERAL INFO

Class Format
Class Policies
Student Reviews

Access Advanced Course

Access Advanced Course

Overview

*** Version Note ***

Target Student

Prerequisites

Lesson 1: Organizing a Database for Efficiency

Lesson 2: Joining Tables

Lesson 3: Creating Advanced Queries

Lesson 4: Using Advanced Reporting Techniques

Lesson 5: Implementing Advanced Form Design

Lesson 6: Using Data Validation

Lesson 7: Using Macros to Improve User Interface Design

Lesson 8: Using Advanced Database Management

Business to Business Only

New Hampshire Residents

* Version Note *