Microsoft Access Comprehensive

Description

This class will give students a working knowledge of databases, what they are and how to use them. Students will learn to view data in a database and change the view by sorting and filtering the data. Students will create a database and learn to define forms for inputs and reports for summarizing the data. Students will learn to create queries to view a subset of data in the database. Students will create charts to display data and a switchboard to manage their database application. Students will create relational databases and learn to create forms, queries and reports that use relational databases. Students will learn to build macros in Access and to use the macros to expand the capabilities of the switchboard. Students will be introduced to the basics of creating VBA applications in Access. Students 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 use filters and queries to find the information they want in their Access databases.
• Students will set options on their database to keep information accurate.
• Students will create reports for their Access databases.
• Students will create a switchboard and custom groups for their Access database.
• Students will create a final project using what they learned in the class.

Book

Lesson 1: Exploring Access

Read Chapter 1

Lesson 2: Creating a Database

Read Chapter 2.  You may also find it helpful to review content from lesson 1.  The quiz is meant to test you on information covered in this lesson as well as reinforce some of the key points you learned in lesson 1.

Lesson 3: Populating a Database

Read Chapter 3

Lesson 4: Sharing and Reusing Information

2007:  Read Chapter 4

2003:  Read Chapter 3

Lesson 5: Creating Forms

2007:  Read Chapter 5

2003:  Read Chapter 4

Lesson 6: Filters and Queries

2007:  Read Chapter 6

2003:  Read Chapter 5

Lesson 7: Keeping Information Accurate

2007:  Read Chapter 7

2003:  Read Chapter 6

Lesson 8: Working with Reports

2007:  Read Chapter 8

2003:  Read Chapter 7

Lesson 9: Making the Database Easy to Use and Secure

2007:  Read Chapters 9 and 10

2003:  Read Chapters 8 through 10

Lesson 10: Putting it all together

Review chapters 1 through 10.

All content of this document is copyrighted by IDEA Solutions and the author. All rights reserved. Content may not be used without permission.