980 likes | 992 Views
Microsoft Access 2002. Project 1. Objectives. Describe databases and database management systems Describe the speech recognition capabilities of Access Start Access Describe the features of the Access Desktop Create a Database Create a table and define the fields in a table.
E N D
Microsoft Access 2002 Project 1
Objectives • Describe databases and database management systems • Describe the speech recognition capabilities of Access • Start Access • Describe the features of the Access Desktop • Create a Database • Create a table and define the fields in a table
Objectives cont… • Open a table • Add records to a table • Close a table • Close a database and quit Access • Open a database • Print the contents of a table • Use a form to view data
Objectives cont… • Create a custom report • Use the Access Help system to answer your questions • Design a database to eliminate redundancy
What is Microsoft Access? • A powerful database management system • Key Features • Data entry and update • Queries (questions) • Forms • Reports • Web Support
Project One – Alisa Vending Services • You will be creating a database for Alisa Vending Services • Database terms: • Database • Records • Fields • Primary key – unique identifier
Starting Access • Go to Start Menu, Programs, Microsoft Access
Starting Access • Now Access is open
Creating a Table • Define structure • Field name • Data type • Description
Creating a Table • Defining the Fields
Creating a Table • Correcting Errors in the Structure • Check entries for correctness • Use BACKSPACE key • Click entry and correct • Select field that will follow and press INSERT key • Select field to delete and press DELETE key • Reset Primary key if necessary using Primary Key button • If too many errors, close table, say no to saving changes and start again
Adding Records to a Table • Create a table • Change to Datasheet view • Add records
Adding Additional Records • Adding Additional Records • Correcting Errors in the Data • Go to Datasheet View and fix errors by retyping or deletion