|
|
|
|
|
|
|
Tuition: $395.00 per student |
Length: 2 days
| |
|
Synopsis: 2 day introductory
course covering databases, tables, the datasheet, sorting and
manipulating tables, import/export, queries, forms, reports
and macros. Using a modern case-based approach, students will
create a small database application during this course. No
prior knowledge of Access is assumed. Available in Access 2003
and 2007. |
|
Formats: Corporate groups
(min. 2 students) at your facility or ours in San Juan
Capistrano, Orange County, California. Single individuals may
arrange a private class billed hourly at private training
rates. |
|
Scheduling: Group and private
training conveniently scheduled by arrangement. |
|
Group
Discounts: Substantial - see FAQ's.
|
|
|
|
|
| Session
1 |
Tables and
Data |
2.0 Hours |
| |
- Relational database foundations and design
- Creating an MS Access database
- Designing tables
- Field and table validation
- Manipulating and sorting the datasheet
- Office Links
- Creating Permanent Links between Tables
|
|
| Session
2 |
Filters, Queries,
Reports & Forms |
3.0 Hours |
| |
- Filters
- Creating simple and multi-table queries
- Using the expression builder
- Calculated fields and concatenation
- Summary queries
- Using the report and form wizards
- Creating a basic switchboard for your application
|
|
| Session
3 |
Reports and Forms
in Depth |
4.0 Hours |
| |
- Creating reports and subreports.
- Formatting your report.
- Adding calculations to your report
- Adding graphics.
- Creating forms and subforms.
- Unbound forms.
- Using the builders and wizards.
|
|
| Session
4 |
Automating
Microsoft Access Tasks |
3.0 Hours |
| |
- Exporting tables to Excel and text files
- Importing and linking files
- Advanced queries.
- Macros
- Using control wizards.
- Finalizing your switchboard
|
|
|
|
References: Please see
the book
list for references you may want to have available.
We are an Amazon.com affiliate and you may purchase your
Microsoft Access books through this
site.
|
|
Materials: Students will
receive a notebook with a printout of all slides used in
their class and a training
certificate.
|
|
Location: Classes are
normally held on-site at your facilities or at our
location in San Juan Capistrano, Orange County. We do,
however, offer other alternatives. Please see FAQ's
if interested. We also travel beyond Southern
California.
|
|
| |
