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

New Horizons Computer Learning Center
New Horizons Lexington KY Computer Training

Delivery Method

On-Site Training On-Site Training

Also Available As

Seminar Seminar

 
Add to favorites Add to favorites
Email Email this page
 

On-Site Training
Information Request Form

Please complete the form for more information and/or a quote for this on-site class.

Name:

Email

Phone:

City and State

Company:

Number of students:
(at least 10 for consideration)

When do you want to hold the
seminar?

How long would you like for the
seminar?

Additional comments to trainer:

We value your privacy!