OFFICE OF TECHNOLOGY SERVICES

Training & Documentation

Self Help Documents: Microsoft Access

OTS is pleased to offer the following PDF publications and Flash movie tutorialsas self-help technology resources for the Towson University community. (For other non-profit use please refer to our copyright information.) To open a publication or play a movie tutorial, click on its title. If your browser does not properly display the publication, you may need to install a free copy of Adobe Reader. If your browser does not properly display the movie, you may need to install a free copy of Adobe Flash Player. To search this page for a specific word or phrase, press Ctrl-F.
	Access 2003: Basic Workshop Learn how to create a complete new basic database following this step-by-step guide.
	Access 2003: Understanding Databases This is a short reference to the basic functions of Access software and understanding the parts of a database.
	Access 2003: Creating a New Database Learn how to create a new database using the built in templates. Also, start a blank database and learn how to use table wizards to help build your database.
	Access 2003: Data Entry and Forms Learn how to build forms in Access to enter your data into tables without having to go into the Design View.
	Access 2003: Importing Data Learn how to import data from Excel, other text files or another Access data
	Access 2003: Sorting and Filtering Tables Learn how to sort and filter the data within your Access tables.
	Access 2003: Queries Learn how to run queries and use criteria to help you pull data from your database.
	Access 2003: Reports Learn how to make professional looking reports using the Access Reports wizard and modify the results with basic and advanced techniques.
	Access 2003: Inserting Graphics Learn how to insert a graphic or an object to your tables and forms.
	Access 2003: Advanced Tables Design View Learn advanced table features using Design View in Access 2003.
	Access 2003: Tables Take a tutorial on the basics of Access tables.
	Access 2003: Advanced Forms: Sub-Forms Learn how to use sub-forms in Access 2003.
	Access 2003: Advanced Queries: Design View Learn how to use Design View to run advanced queries in Access 2003.
	Access 2003: Advanced Reports: Calculations Learn how to make calculations in reports in Access 2003.
	Access 97: Converting to Access 2003 This document offers some tips on converting Access 97 databases to Access 2003.
	Access: Getting Data from PeopleSoft Learn how to connect to PeopleSoft Data through an ODBC to make tables that you can manipulate in Access.
	Access 2003: Relationships Take a tutorial on what relationships are and how to set them up in Access.
	Access 2003: Understanding Relationship This document offers some tips on understanding and creating relationships in Access 2003.
	Access 2003: Creating Labels Learn how to create labels by using the information in your Access database This document offers some tips on understanding and creating relationships in Access 2003.
	Access 2003: Creating Switchboards Learn how to create a switchboard so that when editors open the database they go right to the form screen.
	Access 2003: Understanding Tables Tables are a key feature in Access, this document will help you better understand them.
	Access 2003: Forms Take a tutorial on creating forms in Access.
	Access 2003: Creating a Lookup List Learn how to create a Lookup List to populate field data and to ensure consistency.