To answer this question, complete the lab using the information below.
You're an administrator at a small community college. You'd like to make a database to keep track of
students, courses, and grades. To begin, you want to create three tables: one with student information; one
with course information; and one for enrollments, where a student is connected to a particular class.
The first step toward creating this database is to make tables for your data. Perform the following tasks:
1. Create a new table. In this table, make the primary key an AutoNumber field called StudentID.
Add a short text field called firstName and another called lastName. Save the table and change its
name to Students.
Create a new table. In this table, create a short text field called courseName. Make the primary key