Introduction to Access

Introduction to Microsoft Access

Mobile

Microsoft Office remains the gold standard for business communications around the world. The Pace Center for Business and Technology offers beginner to advanced training in the most popular programs of Microsoft Office: Word, Excel, PowerPoint and Access.

Course Details
icon iPhone

 

Date: September 8 & 10, 2014

Days: 1

Fee: $475.00

Location: 1 Martine Avenue, White Plains, NY

Course Number: 90186

icon

Course Description

This is a course for people new to databases, and for self-taught users wanting to enhance their knowledge. This course will provide you with fundamental knowledge and techniques needed to design and use tables, queries, forms, and reports. You will learn a solid basis for building databases in Access 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.

Click for Detailed Course Description

icon

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
icon

Who Should Enroll

Access users who are familiar with the basic concepts and design of tables, queries, forms, and reports and want This is a course for people new to databases, and for self-taught users wanting to enhance their knowledge.

Prerequisite: Able to use the keyboard and mouse functions.

icon

Course Format

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

icon

Questions?

Please contact us at (888) 561-7223 or continuinged@pace.edu

Outline for Introduction to Microsoft Access

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 KeysSizing 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


 

Other Courses That May Interest You

icon

Access

  icon

Excel

icon

Microsoft Project

  icon

Outlook

icon

PowerPoint

 

Word