Microsoft Access Bootcamp

Beginner Microsoft Access Courses in NYC

If you want to master intermediate and advanced functions of Microsoft Access quickly, this bootcamp is the perfect place to start.

In this two-day, 14-hour course, you’ll go from learning the Access interface to using advanced reporting techniques. For professionals that are new to Access or need a refresher, the Microsoft Access bootcamp provides quick and efficient training.

Microsoft Access Bootcamp

$458 14 Hours 185 Madison Avenue, NYC In-person classroom training

Register for a Package

Customize your own schedule or expand the start dates below to see the full schedule.

Custom Schedule
Register

Microsoft Access Level I

Fri, Jan 18, 10am–5pm

Microsoft Access Level II

Tue, Feb 26, 10am–5pm

Microsoft Access Level I

Mon, Feb 25, 10am–5pm

Microsoft Access Level II

Tue, Feb 26, 10am–5pm

Corporate training available

Call 212-658-1918 or email us

The Microsoft Access Bootcamp includes

Microsoft Access Level I

The course begins by reviewing the core features and functions of the Access database, so if you’ve never used Access, it’s the perfect place to start! By the end of the course, you’ll know how to work with tables, query data, create forms, and generate reports. You’ll have skills to use Microsoft Access for everyday tasks.

Microsoft Access Level II

In Microsoft Access Level II, you’ll learn how to write advanced queries and organize your database for maximum efficiency. If you’ve taken Microsoft Access Essentials or already understand the basics, this is the perfect course for you. At the end of this intermediate Microsoft Access class, you’ll be able to join tables, implement data validation techniques, and use advanced reporting functions.
  • icon for small classesSmall classes
  • icon for small classesComputer provided
  • icon for small classesBook included
  • icon for small classesFree retake

Full Course Syllabus

Download PDF Outline

Day One

Lesson 1: Exploring Access Environment

  • Overview of database concepts
  • Exploring the User Interface
  • Opening an Existing Database
  • Customizing the Access Environment

Lesson 2: Designing a Database

  • Define Database Purpose
  • Review Existing Data
  • Determine Fields
  • Group Fields into Tables
  • Normalize Data

Lesson 3: Creating a Relational Database in Access

  • Creating a New Database
  • Creating a Table
  • Manage Tables
  • Create a Table Relationship
  • Saving the Table Structure
  • Save a Database as a Previous Version

Lesson 4: Managing Data in a Table

  • Modify Table Data
  • Sort Records
  • Work with Subdatasheets

Lesson 5: Querying a Database

  • Filter Records
  • Exploring Query Types
  • Creating and Running a Query
  • Updating Data Using a Query
  • Summarizing Data in a Query

Lesson 6: Designing Forms

  • Creating a Form Using the Forms Wizard
  • Changing a Form’s AutoFormat
  • Finding Data Using a Form
  • Maintaining Table Data Using a Form
  • Filtering Data in a Form

Lesson 7: Working With Reports

  • The Report Window
  • Exploring Report Types
  • Creating a Report Using the Report Wizard
  • Grouping Data within a Report
  • Summarizing Data in a Report
  • Formatting Report Detail and Printing Reports

Day Two

Lesson 1: Controlling Data Entry

  • Restrict Data Entry Using Field Properties
  • Establish a Pattern for Entering Field Values
  • Create a List of Values for a Field

Lesson 2: Joining Tables

  • Create Query Joins
  • Join Unrelated Tables
  • Relate Data Within Table

Lesson 3: Creating Flexible Queries

  • Set Select Query Properties
  • Create Parameter and Action Queries

Lesson 4: Improving Forms

  • Create a Form Layout
  • Restrict Data Entry in Forms
  • Add a Command Button to a Form
  • Create a Subform

Lesson 5: Customizing Reports

  • Organize Report Information
  • Formatting and Setting Report Control Properties
  • Summarize Report Information
  • Create a Mailing Label Report

Lesson 6: Sharing Data Across Applications

  • Import Data into Access
  • Export Data
  • Analyze Access Data in Excel
  • Export Data to a Text File
  • Merge Access Data with a Word Document