Pace University
914-422-4054
212-346-1222
New York City | Westchester

Introduction to Access

Course Format

Two Days (9am- 4pm); offered Monday-Friday; Instructor-led. 

COST:  $475

You Will Learn To

  • Understand Access terminology and database concepts
  • Create, view and edit databases and tables
  • Import and link to data from other sources
  • Query tables for information
  • Modify table data and structures
  • Create and Modify Basic Forms
  • Create basic and grouped reports
  • Create labels
  • Search for and Sort Data
  • Use relational database operations
  • Create a basic form

Who Should Enroll

New Access users or users with limited experience.

Prerequisite: Introduction to the PC or familiarity with the Windows environment.

Course Description

Introduction to Microsoft Access is a two day course designed to help students learn and understand the basic operation of a database program.  It will demonstrate performing day-to-day procedures and explain the advantages of using a relational database program. This course will provide you with fundamental knowledge and techniques needed to design and use tables, queries, forms, and reports. This class provides instructor-led training in Access for students new to the program as well as those who desire a better foundation.

Detailed Course Outline

Access Basics
System Requirements
Conversions
Terms
Starting Access 
Backstage View
Opening a Database
The Access Screen
The Navigation Pane
 
 Creating Databases and Tables
Creating a Database
Creating a Table
Creating a Table in Design View
Adding Data to a Table
Restructuring a Table
 Primary Keys
Relationships
 
Importing Data Tables
Linking to Access Tables
Importing an Excel Spreadsheet
Navigation Keys
Sizing Fields
Linking to an Excel Spreadsheet
Importing from a Text File
 
Searching and Editiing
The Totals Row
Sorting a Table
Searching a Table
 
Queries
Setting up a Query
Selecting Fields
Sorting a Query
Specifying Selection Criteria
Wildcards
Additional Query Operators
Multiple Criteria
 
Forms
 Creating a Form
Using a Form
Layouts
Modifying the Form Design of a Layout
Controls
Adding and Removing Controls in Layout View
Using the Form Wizard
 
Reports
Report Basics
Starting with a Blank Report
Keeping Groups Together
Themes
 
Labels
Mailing Labels
Modifying the Label Design
 
Using Multiple Tables
Relational Database Systems
Linking Multiple Tables
Designing a Relational System
Querying a Relational System
Applying Criteria to Multiple Tables
Calculations in Queries


Copyright © 1984-2012 Pace University.
All Rights Reserved
Created by: pcbt@pace.edu
Pace Center for Business and Technology
914-422-4054
212-346-1222
Pace blog Facebook Twitter