Kansas City
9611-E Metcalf Ave·Overland Park, KS 66212
Solutions for Business Solutions for Individuals Courses + Certifications Learning Methods About Us
 

Access 2010 - Level 1 (First Look)

(Upcoming Dates)

Days of Training (Classroom Learning)


1

 

Overview


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

 

Pre-requisite(s)


There are no prerequisites listed for this course.

 

Lessons



Lesson 1



Getting Started with Access 2010

Identify Elements of the User Interface
Work with the Ribbon
Obtain Help


Lesson 2



Planning a Database

Introduce Database Concepts
Understand the Relational Database Design Process


Lesson 3



Organize Data in Tables

Create a Table
Modify Tables
Create a Table Relationship
Update a Table


Lesson 4



Viewing Data in Tables

Sort Records
Filter Records
View Data from Related Tables


Lesson 5



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 6



Designing Forms

View Data using a Form
Create a Form
Modify a Form


Lesson 7



Generating Reports

View an Access Report
Create a Report
Add a Calculated Field to a Report
Format the Controls in a Report
Apply a Theme to a Report
Prepare a Report for Print