| Learn
Databases |
ATN
Training |
| Access is one of the best desktop level databases around. It combines powerful
and flexible features with a logical approach to database design. It is
also easy to "upsize" Access databases into MS SQL Server if they become
too large for Access to handle.
Access is for anyone who needs to
keep track of large amounts of data and to be able to ask questions about
the data they have stored. Its advantages over spreadsheets, e.g. Excel,
lie in its ability to store data which would become cumbersome in a spreadsheet,
in the flexibility of its queries, and in the opportunity it offers to
build a user interface which allows people to use the database without
having to learn the program. Access is ideal for projects such as keeping
student records for a department or for collecting and entering data from
a survey and then producing reports on the results.
|
Computer
Based Training |
| CBT offers the following Access workshops:
Beginning Access 2000,
Intermediate Access 2000,
Advanced Access 2000, Beginning Access 97,
Intermediate Access 97, Advanced Access 97,
and Access 97 for Power Users. |
| Documentation |
| ATN has documentation for Access 7.0 for Windows '95 as well as for Access 2000/97 |
| Hands-On Computer Workshops |
| ATN
offers two series of hands-on workshops for Access: Access XP/2000 for Users
and Access XP/2000 for Developers. Both require the same initial prerequisite,
Database Concepts. After completing the User Series,
you will have a good, general understanding of what goes on in an Access
Database and the knowledge of how to perform limited modification of existing
elements of a database and how to create simple objects using wizards. After
completing the Developer Series, you will have a thorough understanding
of the basic elements of an Access database and some experience creating
and modifying the various objects that go into an Access database.
Access XP/2000
for Users:
This series is designed for those who
need to know how to work with a previously designed Access database. You
should plan to first take Access XP/2000 User: Tables
and Queries and then attend Access
XP/2000 User: Forms and Reports
Access XP/2000
for Developers:
This series is designed for those
who require the in-depth knowledge necessary for creating and enhancing
databases. You should plan to take the workshops in order.
|
This workshop is a prerequisite for all of
the workshops in the Access Users and Access Developers series. The workshop does
not involve hands-on use of computers but rather teaches participants general
definitions and database concepts through example.
You will learn:
-
Definitions for several commonly used
terms
-
How to design a database
-
How Access databases are structured
-
The concepts behind forming a relationship
between two or more tables in Access
-
How Forms simplify the process of data
entry and display
-
The different sort and report functions
available for the organization of data
| Access
2000/97 User: Tables and Queries |
Prerequisite: Database
Concepts or equivalent experience
This workshop is designed for users
who plan to work with a previously designed database or a database that
somebody else is designing. It focuses on tables, which hold data,
and queries, which allow you to organize and extract your data.
You will learn how to:
-
Navigate in Access
-
Switch between Datasheet View and Design
View
-
Create new tables with and without the
Table Wizard
-
Change the table properties in Design
View
-
Add and save records in Datasheet View
-
Design queries with and without the
Query Wizard
-
Establish a sort order
| Access
2000/97 User: Forms and Reports |
Prerequisite: Access
2000/97 User: Tables and Queries or equivalent experience
This workshop is designed for users
who plan to work with a previously designed database or a database that
somebody else is designing. The workshop will emphasize forms,
which collect and organize information, and reports, which provide a way
to retrieve selected information that you have stored and present that
information.
You will learn how to:
-
Link Forms and Reports to underlying
Tables or Queries through Controls
-
Create and refine Forms with Form Wizards
-
Add Controls to a Form or Report
-
Select, move, and size Controls
-
Create reports with Report Wizards
| Access
XP/2000 User: Tables and Queries |
Prerequisite: Database
Concepts or equivalent experience
This workshop is designed for users who
plan to work with a previously designed database or a database that somebody
else is designing. It focuses on tables, which hold data, and queries,
which allow you to organize and extract your data.
You will learn how to:
- Navigate in Access
- Switch between Datasheet View and Design
View
- Create new tables with and without the
Table Wizard
- Change the table properties in Design
View
- Add and save records in Datasheet View
- Design queries with and without the
Query Wizard
- Establish a sort order
| Access
XP/2000 User: Forms and Reports |
Prerequisite: Access
XP/2000 User: Tables and Queries or equivalent experience
This workshop is designed for users who
plan to work with a previously designed database or a database that somebody
else is designing. The workshop will emphasize forms, which collect and organize
information, and reports, which provide a way to retrieve selected information
that you have stored and present that information.
You will learn how to:
- Link Forms and Reports to underlying
Tables or Queries through Controls
- Create and refine Forms with Form Wizards
- Add Controls to a Form or Report
- Select, move, and size Controls
- Create reports with Report Wizards
| Access
XP/2000 Developer: Tables |
Prerequisite: Database
Concepts or equivalent experience
In this course, you will learn how
to:
-
Construct tables
-
Set and change data types
-
Establish field properties
-
Uniquely define records
-
Establish relationships between tables
| Access
XP/2000 Developer: Queries 1 |
Prerequisite: Access
XP/2000 Developer: Tables or equivalent experience
In this course, you will learn how
to:
-
Build a simple select query
-
Work with the Boolean Operators (And,
Or, and Not)
-
Specify Criteria
-
Sort data stored in tables
-
Design parameter queries
-
Create calculated fields
| Access
XP/2000 Developer: Queries 2 |
Prerequisite: Access
XP/2000 Developer: Queries 1 or equivalent experience
In this course, you will learn how
to:
-
Construct action queries (Make Table,
Delete, Update, and Append)
-
Work with the Totals button
-
Group data based on specified criteria
-
Build a crosstab query
-
Use the Query Wizards
| Access
XP/2000 Developer: Controls |
Prerequisite: Access
XP/2000 Developer: Queries 2 or equivalent experience
In this course, you will learn how
to:
-
Distinguish bound, unbound, and calculated
controls
-
Use each control in the toolbox
-
Select, move, and resize controls
-
Find and change control properties
-
Control section attributes (color, width,
height)
| Access
XP/2000 Developer: Forms |
Prerequisite: Access
XP/2000 Developer: Controls or equivalent experience
In this course, you will learn how
to:
-
Build a simple form
-
Use the Form Wizards
-
Link a subform to a main form
-
Create a calculated control
-
Set form and control properties
-
Incorporate simple macros to build more
sophisticated controls
| Access
XP/2000 Developer: Reports |
Prerequisite: Access
XP/2000 Developer: Forms or equivalent experience
In this course, you will learn how
to:
-
Build a simple report
-
Use the label wizard
-
Use the sorting and grouping functions
-
Calculate totals, subtotals, and percentages
of the whole
-
Work with separate report sections efficiently
-
Customize control formats
| Access
2000/97 Developer: Macros |
Prerequisite: Access
Developer: Forms and Access Developer: Reports or equivalent
experience
In this course, you will learn how
to:
-
Construct simple macros
-
Attach macros to form/control events
-
Build If/Then conditions into macros
-
Automate common Access tasks
-
Consider the limitations of macros vs.
modules