Microsoft® Access® provides powerful tools for managing data. Organizations have to maintain and manage large amounts of information. Most of them use the relational databases. Information can be stored, linked, and managed using a single relational database application and its associated tools. In this course you will be introduced to the concept of the relational database by using the Microsoft® Office Access relational database application and its information management tools.

Objective

To provide the real-world knowledge and skills you need to:
• Create and Use Forms, Reports, Charts, and Pivot Tables
• Create Data Access Pages
• Customize Forms and Reports
• Perform Database Administration, Networking, and Security Functions
• Link, Import, and Export Tables
• Create Macros
• Use Customizing Tools For Switchboards, Dialog Boxes, Toolbars, and Menus

Audience

This course is designed for students who wants to learn Access program to perform their day-to-day functions, and to understand the advantages of using a relational database program.

Minimum Prerequisites

You should be familiar with using personal computers and be comfortable with mouse and keyboard. Basic typing skills is essential as well. Some knowledge of database would be helpful.

What will you learn?

Module 1: An Overview of Access

Understand Relational Databases
Examine the Access Environment
Open the Database Environment
Examine an Access Table

Module 2: Managing Data

Examine an Access Form
Add and Delete Records
Sort Records
Display Recordsets
Update Records
Run a Report

Module 3: Establishing Table Relationships

Identify Table Relationships
Identify Primary and Foreign Keys in the Relationships Window
Work with Subdatasheets

Module 4: Querying the Database

Create a Select Query
Add Criteria to a Query
Add a Calculated Field to a Query
Perform a Calculation on a Record Grouping

Module 5: Designing Forms

Examine Form Design Guidelines
Create a Form Using AutoForm
Create a Form Using the Form Wizard
Modify the Design of a Form Module

Module 6: Producing Reports

Create an AutoReport
Create a Report by Using the Wizard
Examine a Report in Design View
Add a Calculated Field to a Report
Modify the Format Properties of a Control
AutoFormat a Report
Adjust the Width of a Report

Module 7: Planning a Database

Design a Relational Database
Identify Database Purpose
Review Existing Data
Determine Fields
Group Fields into Tables
Normalize the Data
Designate Primary and Foreign Keys

Module 8: Building the Structure of a Database

Create a New Database
Create a Table Using a Wizard
Create Tables in Design View
Create Relationships between Tables

Module 9: Controlling Data Entry

Restrict Data Entry with Field Properties
Create an Input Mask
Create a Lookup Field

Module 10: Finding and Joining Data

Find Data with Filters
Create Query Joins
Join Unrelated Tables
Relate Data Within a Table

Module 11: Creating Flexible Queries

Set Select Query Properties
Create Parameter Queries
Create Action Queries

Module 12: Improving Your Forms

Enhance the Appearance of a Form
Restrict Data Entry in Forms
Add Command Buttons
Create a Subform

Module 13: Customizing Your Reports

Organize Report Information
Set Report Control Properties
Control Report Pagination
Summarize Information
Add a Subreport to an Existing Report
Create Mailing Labels

Module 14: Expanding the Reach of Your Data

Publish Access Data as a Word Document
Analyze Access Data in Excel
Export Data to a Text File
Merge Access Data with a Word Document

Module 15: Structuring Existing Data

Import Data
Analyze Tables
Create a Junction Table
Improve Table Structure

Module 16: Writing Advanced Queries

Create Unmatched and Duplicates Queries
Group and Summarize Records Using the Criteria Field
Summarize Data with a Crosstab Query
Create a PivotTable and a PivotChart
Display a Graphical Summary on a Form

Module 17: Simplifying Tasks with Macros

Create a Macro
Attach a Macro to a Command Button
Restrict Records Using a Where Condition

Module 18: Adding Interaction and Automation with Macros

Require Data Entry with a Macro
Display a Message Box with a Macro
Automate Data Entry


Module 19: Making Forms More Effective

Change the Display of Data Conditionally
Display a Calendar on a Form
Organize Information with Tab Pages

Module 20: Making Reports More Effective

Cancel Printing of a Blank Report
Include a Chart in a Report
Arrange Data in Columns
Create a Report Snapshot

Module 21: Maintaining an Access Database

Link Tables to External Data Sources
Back Up a Database
Compact and Repair a Database
Protect a Database with a Password
Determine Object Dependency
Document a Database
Analyze the Performance of a Database