Microsoft Access Bootcamp

Access & Database Course in NYC

  • tag-solid $458 $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

Comprehensive Microsoft Access Training in NYC

Learn the fundamentals of Microsoft Access 2016 quickly in this two-day, 14-hour bootcamp. You'll learn everything you need to create databases, tables, queries, reports, and so much more! This bootcamp includes Microsoft Access Level I and Microsoft Access Level II.

Are you tired of spending hours organizing worksheets and workbooks in Excel? If so, this bootcamp is for you! Microsoft designed Access to manage massive datasets, generate reports, and answer queries much more quickly than Excel. In this Access bootcamp, you'll learn how to share data with other applications like Excel, when you need to build charts or create data visualizations.

Advance Your Career—Earn Certification!

Certification is the best way to prove your skills and expertise! With our Access Specialist Certification Program, you can earn a MOS (Microsoft Office Specialist) certification in MS Access 2016. Call today to discuss our certification bundle, which includes free private tutoring and exam fees.

Free Microsoft Access Bootcamp Retake in NYC

Retake the bootcamp for free within six months.

Prerequisites

None, basic computer skills

Upcoming Class Dates help-solid

Corporate training classroom
Career Centers teacher helping a student

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

Learn the basics of Microsoft Access. This Microsoft Access beginner course includes an overview of the Microsoft Access 2016 user interface and an introduction to creating data tables. By the end of Microsoft Access Level I, you'll know how to work with data in Microsoft Access and create basic forms.

Microsoft Access Level II

Dive deeper into Microsoft Access 2016 with lessons on data validation, table structure improvement, and advanced reporting techniques. In this course, you'll learn more about relational databases by building one of your own, as well as tips and tricks to increase your efficiency.

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