Here is the Microsoft Access 2003 Tutorial written and hosted by the University of Texas. Using this Access tutorial, you will learn how to use and apply database concepts and operations. It demonstrates step-by-step how these are accomplished in Access 2003. This tutorial covers frequently-used Access features, such as the creating tables, developing queries, entering and editing data, sorting and finding records, and importing spreadsheet into Access.
Access Tutorial Objectives:
- Launch Access and identify the parts of the screen
- Define fields and field properties constructing table structures
- Enter and edit records in a table
- Find, sort data
- Design custom queries to display data
- Import data between Excel and Access
Access 2003 Tutorial Contents:
– Definitions
- Access VS. Excel
– Starting Access and Opening a Database
– Database Components
– Creating Tables in Design View
– Adding and Deleting Fields to Tables
– Entering and Editing Data
– Sorting and Finding Records
– Table Relationships
– Creating Queries
– Importing Excel Data to Access
– Additional Resources
– Evaluate this tutorial
– PDF Handout
