Access 2 Intro

Course description

Overview: Students will learn the fundamental techniques for working with Access objects: tables, queries, forms, reports, and databases.

Prerequisites: Students enrolling in this course should understand basic Windows concepts, and be comfortable working in the Windows environment

Benefits: Students will learn how to create and use tables, queries, forms, reports, and databases.

Objectives

Upon successful completion of this course, students will be able to:

Understand database concepts and terminology by observing paper and Access databases.
Use Access objects by introducing tables, forms, queries, and reports.
Design and create tables.
Add records to a table and modify the design of a table.
Find specific records and edit and copy values.
Select specific records and fields from tables using Access queries.
Use queries to perform calculations on data contained in tables.
Create forms for viewing, entering, and editing data.
Present data from your tables by creating reports that summarize and group information the way you need it.
Create a new database and import Access objects to it.

Course content

An introduction to databases
An overview of Access objects
Creating a table
Modifying a table
Managing records in a table
Using Select queries
Using calculations in queries
Creating and using forms
Creating and using reports
Creating a database and copying objects