Microsoft Office Access
Course Description
An efficient means of managing data is by using databases. Information can be stored, linked, and managed using a database application such a Microsoft Office Access. In this training session, you will examine database concepts, and create and modify databases and their various objects using Microsoft Office Access.
You will learn
If you do well in this unit, you should be able to:
- Identify the terminology and functions common to most database management systems.
- Identify the qualities of valuable information.
- Identify the elements of good database design.
- Create and use tables.
- Create and use queries.
- Create simple reports and forms.
- Use the Access online Help feature.
- Discuss ethical issues connected to the use of databases.
Course Outline
CHAPTER 27: Introducing Access
- 27-1 Concept of Database
- 27-2 Tables, Queries, Forms, and Other Objects
- 27-3 Creating a Database File
- 27-4 Designing a Database
CHAPTER 28: Building Your Database Tables
- 28-1 Creating a Database Table
- 28-2 Opening and Viewing Tables
- 28-3 Entering and Altering Table Fields
- 28-4 Field Properties for Making Sure That Data Entries Are Accurate
- 28-5 Indexing for Faster Sorts, Searches, and Queries
- 28-6 Establishing Relationships Among Database Tables
CHAPTER 29: Entering the Data
- 29-1 The Two Ways to Enter Data
- 29-2 Entering the Data in Datasheet View
- 29-3 Entering the Data in a Form
- 29-4 Finding a Missing Record
- 29-5 Finding and Replacing Data
CHAPTER 30: Sorting, Querying, and Filtering for Data
- 30-1 Sorting Records in a Database Table
- 30-2 Filtering to Find Information
- 30-3 Querying: The Basics
- 30-4 Six Kinds of Queries
CHAPTER 31: Presenting Data in a Report
- 31-1 Creating a Report
- 31-2 Opening and Viewing Reports
- 31-3 Tweaking a Report