New Horizons Lexington KY Computer Training
New Horizons Computer Learning Center presents

Access - Level 1 On-Site Training

This on-site training class is also available as Public Schedule Seminar.

In this course, students will create and modify new databases and their various objects.

Course Description/Agenda

Duration
Classroom Learning - 2 Day(s)
Online LIVE - 2 Sessions

Overview
In this course, students will create and modify new databases and their various objects.

Who Should Attend
This course is designed for students who wish to learn the basic operations of the Microsoft Access database program to perform their day-to-day responsibilities, and who want to use the application to be more productive in their work. It provides the fundamental knowledge and techniques needed to use more complex Access features such as maintaining databases and using programming techniques that enhance Access applications.

Suggested Next Steps

Access 2010 - Level 2

Outline

Lesson 1: Getting Started with Access 2010

Identify the Elements of the Access 2010 Interface
Identify the Components of a Database
Examine the Relational Database Design Process

Lesson 2: Building The Structure of a Database

New Database
Create a Table
Manage Tables
Establish Table Relationships

Lesson 3: Managing Data in a Table

Modify Table Data
Sort and Filter Records
Work with Subdatasheets

Lesson 4: Querying a Database

Create a Query
Add Criteria to a Query
Add a Calculated Field to a Query
Perform Calculations on a Record Grouping

Lesson 5: Designing Forms

Create a Form
Modify the Design of a Form
View and Add Data Using an Access Form

Lesson 6: Generating Reports

Create a Report
Add a Control to a Report
Format the Controls in a Report
Enhance the Appearance of a Report
Prepare a Report for Print

Lesson 7: Controlling Data Entry

Constrain Data Entry Using Field Properties
Establish Data Entry Formats for Entering Field Values
Create a List of Values for a Field

Lesson 8: Joining Tables

Create Query Joins
Join Tables That Have No Common Fields
Relate Data Within a Table

Lesson 9: Creating Flexible Queries

Set the Select Query Properties
Retrieve Records Based on Input Criteria
Create Action Queries

Lesson 10: Improving Forms

Restrict Data Entry in Forms
Organize Information with Tab Pages
Add a Command Button to a Form
Create a Subform
Display a Summary of Data in a Form
Change the Display of Data Conditionally

Lesson 11: Customizing Reports

Organize Report Information
Format Reports
Control Report Pagination
Add a Calculated Field to a Report
Add a Subreport to an Existing Report
Create a Mailing Label Report

Lesson 12: Sharing Data Across Applications

Import Data into Access
Export Data to Text File Formats
Export Access Data to Excel
Create a Mail Merge

More Seminar Information