|
|
Beginning Access Course
Description:
Access-2003-Beg
Access-2007-Beg
Create, edit, and save a simple one-table
database.
|
CREATE & EDIT TABLES:
Use
Design View to create and edit
tables. Add, format, move, and
delete fields.
Adjust width of columns, change
font/font size of text. Add Default
Values, Lookup fields, and Input
Masks to speed up data entry. Add
Validation Rules to protect the
integrity of your data. Import Excel
data into a table.
 |
| |
CREATE & EDIT FORMS:
Create forms based on existing tables. Enter
and edit data and forms. Change
background color of form,
move and resize fields.
|
 |
| |
DATA ENTRY:
Enter, edit, and delete data in
forms and tables.
SORT AND FILTER DATA:
Use
Find & Replace to edit data in
table, use Quick Sort to sort
data alphabetically (A-to-Z or
Z-to-A), use Filter by
Selection to locate specific
data in tables.
|
| |
CREATE QUERIES:
Create a number of different
queries.
Sort
and filter data using different
criteria such as name, amount, and
date. Use multiple criteria to
narrow a search, use wildcards,
filter data
by a range of dates or amounts, etc. |
| |
 |
| |
REPORTS:
Use
Report Wizard to create professional
looking reports based on existing tables and
queries. Edit reports in Design
View.
|
 |
Intermediate/Advanced Access Course
Description:
Access-2003-Int
Access-2007-Int
RELATIONSHIPS:
Build a complex multi-table database. Create,
edit, and delete relationships (links or
connections between different tables.) Create
and edit one-to-one, one-to-many, and
many-to-many relationships.
ADVANCED QUERIES:
Query multiple tables. Create Parameter Queries
that do the work of many different queries.
Perform multiple sorts using more than one
criteria.
MACROS:
Create simple macros that automate basic actions
such as running or printing queries and reports,
etc. Add these macros to buttons on forms.
FORMS:
Create forms with sub-forms. Add buttons to
forms to run macros. Add drop-down look-up
fields to forms.
EXPRESSIONS:
Use expressions to perform calculations in
queries, forms, and reports. Add, subtract,
multiply, and divide numeric data. See
Subtotal, Tax, and Total fields shown above.
SWITCHBOARD (MAIN MENU):
Create a Switchboard (or main menu) with buttons
to organize your tables, macros, queries and
forms into one central place.
Access-2003-Beg
Access-2007-Beg
Access-2003-Int
Access-2007-Int
(858) 578-9476
Info@PC-Classes.com
 |
