Database in Microsoft Access: A Simple Lesson

A database program is used to keep track of large amounts of data, such as credit card information, grades for students, drivers licences, etc.

Microsoft Access is one of many database programs.

Project I: Classmates

Create a database of students in your class. Use the following fields:

Populate the database with the actual data from your classmates.

Add a field: Favorite Sport, Birth Date, Eye Color and then add the data.

Reports

Create the following reports:

Height and Shoe Size: First Name, Last Name, Height, Shoe Size, sorted by Last Name

Favorite Sport: First name, Last Name, Favorite Sport and group by Favorite Sport, and sort by Last Name

Height: First Name, Last Name, Height, Shoe Size, and sort by Height (decending), Shoe Size (decending), and Last Name

Query: Use a query to display only some of the people, and some of the columns. Use sort and filter. Save. Create a report.