Untitled Document

Microsoft Access for Beginners (2007)

Description

This class will give you a working knowledge of databases, what they are and how to use them. You will learn to view data in a database. You will create a database, add tables manually and from templates. You will learn to define forms for inputs of data. You will learn to import data into your database and export data out of it. You will need a basic understanding of Windows to complete this class. You will need a copy of Office. A 60-day trial version is available.

Objectives

Students will explore the Microsoft Access environment.
Students will create a database in Access.
Students will add records to a database by importing from various sources.
Students will export data from their Access databases to other formats.
Students will create forms for working with their Access data.
Students will create a final project using what they learned in the class.

Book

Choose the correct book for your version:

Microsoft Office Access(TM) 2007 Step by Step

Author: Steve Lambert, M Dow Lambert
Publisher: Microsoft Press
ISBN: 0735623031

Microsoft Office Access(TM) 2003 Step by Step

Author: Online Training Solutions, Inc.
Publisher: Microsoft Press
ISBN: 8120324757

Lesson 1: Exploring Access

Read Chapter 1

Lesson 2: Creating a Database

Read Chapter 2

Lesson 3: Populating a Database

Read Chapter 3

Lesson 4: Sharing and Reusing Information

Read Chapter 4

Lesson 5: Creating Forms

Read Chapter 5