Access 2010 Level 1: Introduction to Microsoft Access
CLASS DATE(s):
Request a Class

COURSE LENGTH: 1 Day

COURSE COST: $425.00

COURSE TIMES: 9:00am - 5:00pm

Printable version of this course
print

COURSE OVERVIEW

Access 2010 Introduction is a hands-on, instructor-led course designed for individuals who will be creating and maintaining Access 2010 databases. The course introduces fundamental database terminology and concepts and helps prepare students to create databases for their use. During the class, students will design and build a simple multi-table relational database creating tables, fields, and table relationships. The course also introduces other database objects including creating select queries, forms, and reports.

The course is the first in the series of Access 2010 courses and helps build the foundation for the more advanced courses including Access 2010 Intermediate and Access 2010 Advanced.

AUDIENCE AND PREREQUISITES

Students enrolled in this course should be comfortable working in the Windows environment and adept at performing common tasks such as opening and closing programs and files, navigating between running programs, as well as using the mouse and keyboard. Working knowledge of other Microsoft Office applications, such as Excel, is helpful.

  

*Course cost listed does not include the cost of courseware $ 24.65. For more information, please contact: learn@vtec.org

COURSE TOPICS:


Lesson 1: Getting Started with Access Databases
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
Create a New Database
Create a Table Using the Design View
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 Edit 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