Microsoft Office
Access Topics
Overview
Microsoft Office Access is used to create simple databases. This includes tables to store data which supports a variety of standard field types such as text, number or date and more. You can create queries for selecting specific sets of data from various tables. Access also provides you with an interface, forms to display and enter data, and reports for printing.
Below is a list of topics divided into 3 steps to allow the student to obtain a solid foundation to building stable Access databases.
Microsoft Office Access – Step 1
An Overview of Access
Understanding Relational Databases, Examine the Access Environment, Open the Database Environment, Examine an Access Table
Managing Data
Examine an Access Form, Add and Delete Records, Sort Records, Display Recordsets, Update Records, Run a Report
Establishing Table Relationships
Identify Relationships, Identify Primary and Foreign Keys in the Relationships Window, Work with Subdatasheets
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
Designing Forms
Examine Form Design Guidelines, Create a form Using Autoform, Create a Form Using the Form Wizard, Modify the Design of a Form
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
Microsoft Office Access – Step 2
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
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
Controlling Data Entry
Restrict Data Entry with Field Properties, Create an Input Mask, Create a Lookup Field
Finding and Joining Data
Find Data with Filters, Create Query Joins, Join Unrelated Tables, Relate Data within a Table
Creating Queries
Set Select Query Properties, Create Parameter Queries, Create Action Queries
Improving Your Forms
Enhance the Appearance of a Form, -Restrict Data Entry in Forms, -Add Command Buttons, Create a Sub form
Customizing Your Reports
Organize Report Information, Set Report Control Properties, Control Report Pagination, Summarize Information, Add a Sub report to an Existing Report, Create Mailing Labels
