Access 101: Database Overview

Through both lecture and hands on, this overview introduces you to:

• Basic database terminology
• Components that make up Microsoft Access
• Tables, queries, forms, and reports

Access 102: Creating Tables

In this hour, you'll learn:

• Several ways to create a table in Microsoft Access
• Different types of fields and field properties
• Distinctions between Datasheet View and Design View

Access 103: Data Entry Tips and Tricks

This course has a lot of different data entry tips and tricks to teach you. You'll also learn how to:

• Format a datasheet
• Export that data into Microsoft Excel or Microsoft Word

Access 104: Create Tables for a Contacts Database

During this hour, you'll be creating a Contact Management database. You'll be:

• Walking through the process of creating the necessary tables
• Creating tables that track contact information, phone numbers, and email
• Designing tables that let you to store files related to the contact and keep chronological notes

Access 105: Create Tables for a Customer Database

Spend this hour discovering how to:

• Construct the tables necessary to create a Customer database
• Create tables to track customer information, products, and order details

Access 201: Importing Data Tips and Tricks

This course teaches you how to:

• Import data into Access
• Export data to other programs such as Excel and Word
• Clean up data in an Excel workbook prior to importing it into Access

Access 202: Filters and Sorts

Learn tips and tricks for:

• Applying filters and sorting data
• Using these features in the Datasheet mode, Form View, and Report View

Access 203: Introduction to Queries

This course teaches you the basics for creating queries. You'll learn how to:

• Link tables
• Write custom formulas
• Concatenate data

Access 204: Action Queries

Learn how to use the Action queries:

• Make Table
• Append
• Update
• Delete

Access 205: Advanced Queries

Explore advanced queries using:

• Calculations
• IIF function and IsNull function
• Concatenation to combine text within your queries

Access 206: Table Relationships

This course teaches you about table relationships and referential integrity. You'll learn about:

• Table normalization
• Defining relationships between tables
• Primary Key
• Applying referential integrity
• The pros and cons of using referential integrity

Access 207: SQL Queries Part 1

In this segment, you'll be introduced to Structured Query Language (SQL).  You'll be:

• Examining the structure of SQL queries
• Learning how to view Access Queries, also known as Query By Example (QBE) as SQL queries

Access 208: SQL Queries Part 2

In SQL Queries Part 2, you'll learn how to:

• Recognize and edit SQL queries that are used as Record Sources for forms and reports
• Write SQL for Action Queries

Access 301: Forms Overview

This is an overview of the types of forms you can create using Microsoft Access. You'll be introduced to:

• Forms Ribbon
• Forms Wizard
• Different types of forms you can create

Access 302: Form Layout View Part 1

This course illustrates the basics of working with forms in the Layout View. You'll learn about:

• Forms are automatically created in the Layout view
• Design and Arrange Ribbons
• How to make simple editing and format changes

Access 303: Form Layout View Part 2

In Part 2 of Form Layout View, you'll discover:

• Advanced ways to work with, edit, and modify Layout forms
• How to use the Navigation Form to organize multiple forms within your database

Access 304: Form Design View Part 1

In Form Design View Part 1, you'll learn how to:

• Create a form from scratch using the Design View
• Add fields and labels to your form
• Use the Design, Arrange, and Format Ribbons

Access 305: Form Design View Part 2

This hour continues with Form Design View. You'll find out how you can:

• Add additional objects to a form such as Combo boxes, List boxes, Check boxes, and Option buttons (Radio buttons)
• Use the Controls Wizard to create Combo boxes and Command buttons

Access 306: Form Design View Part 3

During this segment of Form Design View, we'll show you how to:

• Create a main form and sub forms
• Use queries and Text boxes to add formulas to your form
• Add a Tab Control to the form

Access 307: Form Design View Part 4

Wrapping up Form Design View, in this hour you'll learn about advanced features found in the Property Sheet:

• Record Source
• Default View
• Data Entry
• Allow Additions,  Allow Deletions, Allow Edits
• Options for the Detail Section, Text Boxes, Labels, and Buttons

Access 308: Create Forms for a Contacts Database

During this course, you'll create a:

• Form for an individual contact that contains subforms displaying the contact's phone numbers and email addresses
• List of contacts
• Data entry form to add new contacts

Access 309: Create Forms for a Customer Database

During this hour, you'll be designing forms for a Customer database. You'll create:

• A customer form that displays all the orders placed by the customer
• An order form that allows the user to enter a new order for an existing customer

Access 401: Adding Buttons to a Form

This course introduces you to the Controls Wizard. It demonstrates how to use it to add commonly used buttons to a form. You'll learn how to:

• Add navigation buttons
• Include a button to close a form
• Create a Main Menu form that contains buttons to open several different forms
• Display the Main Menu form when you open the database

Access 402: Editing Macros

This hour demonstrates how to edit macros you've created using the Control Wizard. It introduces you to the Macro Editor program within Microsoft Access.

You'll learn how to add folders containing Access database to the Access Trust Center so that when you open a trusted database you will no longer see the prompt asking you if the database is trusted.

Access 403: Use the Controls Wizard to Automate Forms

This course uses the techniques learned in the Access 401 and 402 classes to make a database more user-friendly. You'll use the Controls Wizard to add buttons to automate the use of the database by:

• Improving navigation within forms
• Opening and closing forms
• Printing out form data

Access 501: Report Layout View Part 1

Part 1 of Report Layout View demonstrates report options. You'll see how to access the Report Options on the Create Ribbon and use:

• Report to tabular reports automatically
• Report Design to create reports from scratch
• Blank Report not based on any table or query
• Report Wizard to help you build your report

Access 502: Report Layout View Part 2

In Part 2 of Report Layout View, you'll learn additional formatting commands that allow you to customize the look of your reports created using the Layout View.

Access 503: Report Design View Part 1

This segment of Report Design View shows you how to add fields, groups, and sorts to a report.

Access 504: Report Design View Part 2

This hour of Report Design View shows you how to:

• Create detailed and summary reports
• Add calculated fields in group headers and footers
• Add calculated fields in report headers and footers

Access 505: Report Design View Part 3

This course shows you several of the Report Properties, allowing you additional ways to format reports such as:

• Keeping data together on a page
• Forcing a new page based on a field change
• Using the Build command to add commonly used fields to report headers and footers

Access 506: Report Design View Part 4

In Report Design View Part 4, you'll see how you can create a Main report that contains sub-report(s).

You'll learn how to display subtotals and totals within these reports.