Instructions

For this assignment, you will practice using a basic and easy-to-use desktop DBMS called Microsoft Access.

Assume that you need to create an entity that holds information about students at NCU. What type of attributes should you capture about a student? Your student table should have a primary key. What field will you use for your primary key?

Using Microsoft Access, perform the following tasks:

Create a database with a student table as described above with at least ten columns

Create a form to help put information into your table.

Create a report that shows all fields of your table and displays the total number of enrolled students at the bottom.

Practice adding new students into your database through the form. Insert at least 12 students with different realistic information.

Run your report before and after adding new students to test functionality.

Save the database with all objects and save with filename students.accdb.

In a Word document, submit the following:

A screenshot of the table in design mode with all fields showing

A screenshot of your form with sample data

A screenshot of the reports output before and after adding records to the database