Introduction to the Environment and to Databases

Access 2007 is a relational database application.  A relational database is a place where we store information that relates from one aspect of the database to the other.  A checkbook is an example of a relational database.

This lesson we will consider the following:

• An Overview of Access 2007
• A Review of the Environment (Quick Access, Ribbons, and so forth)

Introduction to Tables and Queries

In this lesson we will consider the following:

• The Importance of Tables as the Foundation of our Database
• Finding Information You Need with a Query

Introduction to Forms and Reports

Forms are a way we can see the information in the tables without looking at the tables themselves.  With a form you can add records, edit records, delete records and so forth.  Forms are optional because you can use a table.

In this lesson we will consider the following:

• An Introduction to Forms.
• An Introduction to Reports

Create Tables in Table View

On the Create ribbon you can create a Table and work with that table in Table View.  In this lesson we will consider the following:

• How to Create Your First Table
• Working with Fields and Field Templates

Create Tables in Design View

nother way to create tables from the Create ribbon is by selecting the Table Design option and working in the Design View.

In this lesson we will consider the following:

• Creating a Table in Design View
• Working with Field Names, Data Types and Descriptions
• Overview of LNC Naming Convention

Modify Tables

Make all of your changes in Design View.  In this lesson we will consider the following:

• Add/Delete/Modify Fields
• Modify Field Properties

Table Relationships

In this lesson we will consider the following:

• Primary Keys
• Create/Delete Joins
• Enforce Referential Integrity

Using Table Records / Sort and Filter Table Data

In this lesson we will consider the following:

• Enter/Delete/Modify Records
• Sort
• Filter

Create Queries with the Wizard and in Design View

Queries are created using the Create ribbon.  In this lesson we will consider the following:

• How to Create a Query with the Wizard
• How to Create a Query with the Design View

Queries: Add/Delete/Rearrange and Sort

In this lesson we will consider the following:

• Using the Query Design Window
• Modify a Query By Adding and Removing Fields
• Modify a Query By Rearranging the Order of Fields
• Changing the Sort Order of Query Results

Queries: Criteria Row and OR Row

In this lesson we will consider the following:

• Modifying Queries with Criteria Rows and Filters
• Using the OR Row

Queries: Show Row and Totals Row

In this lesson we will consider the following:

• From Design View: Setting Up Show Rows
• From Design View: Setting Up Totals Row

Queries: Calculated Fields

In this lesson we will consider the following:

• Creating a Calculated Field in a Query

Queries: Parameter Queries

In this lesson we will consider the following:

• Create a Parameter Query

Create Forms with the Wizard

In this lesson we will consider the following:

• Create Forms on the Create Tab
• Using the Form Wizard from the Forms Group

Create Forms in Design View

In this lesson we will consider the following:

• Create Forms Using the Design Form Option

Modify Forms

In this lesson we will consider the following:

• Add/Delete/Rearrange Fields

Use Forms

In this lesson we will consider the following:

• View/Edit/Add/ and Delete Records

Create Reports with the Wizard

In this lesson we will consider the following:

• Building a Report Based On a Query
• Using the Report Wizard

Create Reports in Design View

In this lesson we will consider the following:

• Using the Report Design Option

Modify Reports

In this lesson we will consider the following:

• Add/Delete/Edit Fields
• Move Fields
• Grouping and Sorting

Reduce Whitespace, Align Fields and Add Totals

In this lesson we will consider the following:

• Reducing Whitespace
• Aligning Fields
• Adding Totals

Keep Groups Together, Format Report and Add Title

In this lesson we will consider the following:

• Keeping Groups Together
• Format Reporting
• Add Title

Calculated Fields

In this lesson we will consider the following:

• Calculated Fields

Use Reports: View in Print Preview

In this lesson we will consider the following:

• Using Reports In Print Preview