Class Information

A database is a tool for collecting and organizing information. Databases can store information about people, products, orders, or anything else. Many databases start as a list in a word-processing program or spreadsheet.

A computerized database is a container of objects. One database can contain more than one table. Unless it has been specifically designed to use data or code from another source, an Access database stores its tables in a single file, along with other objects, such as forms, reports, macros, and modules. 

Using Access, you can:

• Add new data to a database, such as a new item in an inventory
• Edit existing data in the database, such as changing the current location of an item
• Delete information, perhaps if an item is sold or discarded
• Organize and view the data in different ways
• Share the data with others via reports, e-mail messages, an intranet, or the Internet

Directions:

In this activity you will open the Class Information Database.doc Download Class Information Database.doc

file and follow the directions to create a database structure, create a form, enter student records, run queries, and create a report to manage student records.

NOTE: Make sure you name/save your form as "Student's Form," save each of your queries with an appropriate name, name/save the report "Student's Reports." 

Class Information Database.doc Download Class Information Database.doc

Once you have completed your database with appropriate queries and reports, save your file in the appropriate place on the network.  You will then upload this information using the Submit Assignment button in the upper right hand corner of this window.  Be sure to proofread your work before you submit it.