Microsoft Access Bootcamp

Access & Database Course in NYC

  • tag-solid $458
  • clock-solid 14 Hours
  • display-solid PC provided help-solid
  • users-solid Small in-person class
  • repeat-line Free retake help-solid
  • map-marker-solid 185 Madison Avenue, NYC
All Microsoft Access Courses Microsoft Access Bootcamp

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.

Upcoming Class Dates help-solid

Looking for corporate training?

We offer custom onsite training and discounted class vouchers.

envelope-solid nyc@careercenters.com phone-handset-solid 212 • 684 • 5151 file-group-solid Download Syllabus

The Microsoft Access Bootcamp Includes

Microsoft Access Level I

Covers the basic skills, including: identifying the components of the Microsoft Access 2016 environment, identifying the components of a database, organizing data in tables, viewing data in tables, querying a database, designing forms and generating reports.

Microsoft Access Level II

Concentrates on some more advanced skills, including: streamlining data entry and maintaining data integrity, joining tables to retrieve data from unrelated tables, creating flexible queries to display specified records, allowing for user-determined query criteria, modifying data using queries, improving forms, customizing reports to organize the displayed information, producing specific print layouts and sharing data between Access and other applications.

Full Course Syllabus

file-group-solid 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