|
First Steps
with Databases
An overview of
database concepts
An introduction to
Access concepts
Opening a database
An orientation to
the Database window Navigating within a table
Review of naming conventions
Finding a record
Using Online Help
Creating Tables
Viewing a
completed table
Examining the
table design
Create a new table
Set the primary key
Table design principles
Working with tables
Add a record to a table
Adding and
deleting fields in data sheet view
Adding and
deleting fields in design view
Find a record and
edit it and undoing changes
Spell checking fields
Selecting and
deleting records
Filter by data sheet
Filter by selection
Sorting
Using Select Queries
An introduction to
query concepts
Creating a Quick
Sort query
Running a Select
query and examining a design
Running the query
and observing the dynaset
Adding fields to a query
Using wild cards,
and Using an And/Or
condition |
Calculations
and Joins in Queries
Using calculations
in queries
Creating and
naming a calculated field
Calculating a
total for a group of records
Joining tables in
a query
Creating and
Using Forms
Opening a form and
navigating within a form
Add a record in
Form View, confirm it is in table
Use the Wizard to
create a form for a single table
Moving controls importing
Sizing and
aligning controls
Saving and viewing
the form
Sorting records in
a form
Creating and
applying a filter
Saving the filter
as a query
Creating and
Using Reports
Previewing a
mulitable report
An orientation to
report design
Use the Wizard to
create a report for a
single table
Use Small Cards to
lookup steps
Print preview with multi-pages
Insert page numberss
Creating a
Database and Copying Objects
Creating a database
Use File, Import
to copy objects
Exiting Access |
Desktop Courses 
MS Access For ECDL Syllabus