|
Tables,
Normalisation and Relationships
An overview of
database concepts
An introduction to
Access concepts
What is and why
use a RDBMS
Normalisation Rules
Relationships in Theory
Orientation to
Access XP
Starting Access
& Opening a database
An orientation to
the Database window and the menu bar
Navigating within
a table & Finding a record
Review of naming conventions
Database Relationships
Join Types
Linking tables in
Relationships Window
Creating Tables
Viewing a
completed table
Examining the
table design
Create a Table
& Setting the Primary Key
Working with tables
Us the Add Record button
Adding and
deleting fields in design view
Find a record and
edit it
Undoing changes
& Spell checking
Selecting and
deleting records
Adding a new record
Filter by data
sheet & selection
Sorting
Using Select Queries
An introduction to
query concepts
Creating a Quick
Sort query
Running a Select
query and examining a design
Creating a Select query
Running the query
and observing the dynaset
Selecting records
and observing the dynaset
Adding fields to a query
Changing the QBE grid
Selecting records
with a wildcard operator & comparison operators
Using an And/Or condition
Selecting records
with null values
Printing the results
Subform Design
Creating a form
that contains a subform
Using the Form
Wizard to create a form that contains a subform.
Using Command
Buttons and Macros with Forms
Creating a command button
Creating macros to
control form properties
Using macros to
provide user interaction
Automating tasks
with macros
Functions,
Macro Actions and Events
An overview of functions
An overview of
macro actions
An overview of events
|
Calculations
and Joins in Queries
Creating and Using
calculations in queries
Calculating a
total for a group of records
Examining the
design of a multitable query
Joining tables in
a query
Designing tables
to join automatically when queried
Creating and
Using Forms
Opening a form
Add a record in
Form View, confirm it is in able
Use the Wizard to
create a form for a single table
Moving controls
Use the Toolbox features
Sorting records in
a form
Creating and
applying a filter
Saving the filter
as a query
Printing Forms
Creating and
Using Reports
Previewing a
multiple report
An orientation to
report design
Use the Wizard to
create a report for a single table
Print preview with multi-pages
Insert page numbers
Creating a
Database and Copying Objects
Creating a database
Use File, Import
to copy objects
Designing
Parameter and Action Queries
Creating a
parameter queries
Creating action queries
Advanced Query Techniques
Joining tables and
working with join properties
Editing
limitations in dynasets
Crosstabs
Advanced Form Techniques
Building a form
based on joined tables
Using a function
in a form
Adding an option group
Data validation techniques
Displaying
Information as a Chart/Graph
Interaction and
automatic task macros
Using macros to
provide user interaction in forms
Using macros to
automate tasks in forms
Advanced Report Techniques
Enhancing report design
Using functions in reports
Using calculations
in reports
Introduction to
Web Capabilities
Creating Hyperlinks
Forms for Internet Use
Database
Security Options
Replicating
database files
Replicating databases
Using the
Briefcase to synchronise files |
Desktop Courses 
Microsoft
Office Specialist
- Microsoft Access XP - Core