Use the following information and create a Student List database file.

Create a new blank database file and name it as a StudentList and save on the Desktop.

Create a table using design view:

a$)$ Field Name

Data Type

b$)$ Studentld

Auto Number

c$)$ FirstName

Text

d$)$ LastName

Text

e$)$ CourseType

Text

f$)$ CourseFee

g$)$ Word

Currency

h$)$ Excel

Number

i$)$ Access

Number

J$)$ PowerPoint

Number

Number

Set a Primary key for Studentld Field

Name the table as tblStudentList

In Datasheet View, using Quick Start add Status field to your table. Position it so it is the last field in your table. $($All students have completed the course$)$

Enter the following data into the table:

$\backslash$table$[[$Student$,$First,Last,Course,Course,,,,Power$],[$Id$,$Name,Name,Type,fee,Word,Excel,Access,Point$],[1,$Smith,Black,Accounting,$7500,94,92,90,94],[2,$John,Kennedy,Medical,$8500,96,90,88,84],[3,$Karen,Joe,Accounting,$7500,90,94,94,96],[4,$Lenin,Thomas,Medical,$8500,82,84,85,92]]$