Access XP Tutorial and Guide

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