Texts: To answer this question, complete the lab using the information below.
You're an administrator at a small community college. You would 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.