This is an excellent Access
XP Tutorial and Guide that will help you become
more familiar and skilled with creating and using Access tables, forms,
queries, and reports. Access features that are taught by this Access
tutorial include the following: Creating a Database Table, Creating a
Lookup Field, Creating and Modifying a Query, Using Filters, Creating
and Modifying Forms, Creating and Modifying Reports, Backing
up an Access Database, and Performing a Mail Merge. This training
tutorial is hosted by the San
Antonio Independent School District's Technology Literacy
Institute.
Your
Guide To Microsoft Access XP
(55 pages,
1.6mb, pdf
format)
Access Tutorial Contents:
What
is Access XP?
What
should you consider before beginning?
Plan Ahead!
Opening a new database
Opening a database
Tables
Creating a table
What
is a field name?
What
is a data type?
Creating a lookup field
Query
Creating a query
What’s the LNC naming convention?
How to modify a query
Querying a date
Creating a parameter query
Counting using a query
Using filters
Forms
Creating a form
Modifying a form
How
to navigate through your database
Reports
Creating a report
Modifying a report
Backing up a database
Why should you back up your data?
Creating a Mail Merge
What is a Mail Merge
Helpful Information
What types of objects can be created in Access
Some other terms to remember
Data Types in Access
Reasons for making a database
Test for Knowledge
Create databases based on the following topic
Mini Access Quiz
Resources, Links & Citations