ACCESS ESSENTIALS 2016

Course Overview

The Access Essentials course is conducted over 2 days and is designed for people with no prior knowledge of Microsoft Access or relational databases. This course introduces relational database concepts and architecture which is the cornerstone of any database design. Once the table schema has been constructed and enforced students will be able to enter new data via forms, analyse the data using queries and present the data for presentation or printing using reports. With a solid grounding in the fundamentals of database design, students are able to implement their newly acquired skills from the training when developing Access databases in the future. With time and practice, the sky’s the limit.

Who Should Attend

This course is targeted at students with no prior knowledge of Microsoft Access or relational databases. As a result of this course students will gain a solid understanding of relational database concepts and terminology and with time and practice be able to build a database, manipulate table data, create basic queries, forms and reports.

Course Prerequisites

Basic keyboard and computer skills and a general understanding of Microsoft Excel would be helpful.

Raising the Bar

1300 937 782

www.rtb.com.au

Exploring Access

Why use Access?
Starting Access
Navigate Access
Tabs and Ribbons
The Backstage
The Quick Access Toolbar Exiting Access

Database Objects

Tables
Enter Data into Tables
Forms
Queries
Reports
Overview of Macros and Modules

Create A New Database and Tables

Planning a Database
Create a Database
Create a Table
Select a Data Type
Designate a Primary Key
Save the Table
Enter Data into a Table Selecting and Deleting Records

Working in Tables

Find Data
Replace Data
Filter By Selection
Filter Excluding Selection
Using Text Filters
Freeze Fields
Sorting Data
Printing

Relationships

Relational vs Flat File Databases
The Relationships Window
Create a One-to-Many Relationship
Create a One-to-One Relationship
Create a Many-to-Many Relationship
Fix the Many-to-Many Relationship
Referential Integrity
Cascade Update and Cascade Delete SubDataSheets

Simple Queries

Query Design
Add Tables to the Query
Add Fields to the Query
Save the Query
View the Query in DataSheet View
Sort the Query
Rearrange the Order of the Fields
Filter Criteria and Delimiters
Datatype Mismatch Errors
Using Mathematical Operators Multiple Criteria “Between” Criteria Wildcards
Parameter Prompts
The Simple Query Wizard

Table Field Properties

Change Field Size for Text Fields
Set the Format for Text Fields
Apply an Input Mask
Enter a Caption
Set Default Values
Validation Rules and Validation Text
Required and Allow Zero Length
The Others
Activating the Lookup Wizard
Type the Values into the Lookup Wizard
Modify the List
Use Values from a Table in the Lookup
Wizard
Allow Multiple Values Allow Value List Edits
Change Field Size for Number Fields
Overflow Errors
Singles and Doubles
Set the Format for Number Fields Change the Format for Date/Time Fields

Data Entry Forms

Create a Form Based on a Table
Use the Form Wizard
Change to Design View
Select Controls on a Form
Change the Control Layout
Move Controls
Snap to Grid
Move One Half of a Paired Control
Resize Controls
Align and Distribute Controls
Parts of a Form
Add a New Label
Format the Label
Add a New Text Box
Change Control Properties Add a New Combo Box
Add a New Image Control
Add a Field from the Field List
Add a Tab Control
Add More Pages to the Page Control
Modify the Tab Order
Remove Calendar Controls
Remove Broken References

Switchboard Forms

What is a Switchboard?
Create a Blank Form
Change the Form Properties
Add a Command Button
Test the Form
Set the Display Form
Turn off the Navigation Pane Change Ribbon and Shortcut Menu Options

Query-by-Form

Create the Query
Create the Form with a Combo Box
Add Other Controls
Change the Control Properties
Link the Query to the Combo Box with the
Expression Builder
Link the Query to the Text Box Date Control with the Expression Builder What Does It Mean?

Other Query Wizards

The Crosstab Query Wizard
The Find Duplicates Query Wizard The Find Unmatched Query Wizard

Reports

The Report Wizard
Add Grouping in the Report Wizard
Manually Grouping in the Report
Modify and Move Controls on the Report
Resize Sections
Calculate the Date Printed
The Print Blank Pages Error