Case Problem $1$

Data Files needed for this Case Problem: Career.accdb $($cont$.$ from Module $1),$ Support$\_$AC$\_2\_$Course.txt$,$ and Support$\_$AC$\_2\_$Registration.xlsx

Great Giraffe Jeremiah wants you to further refine the design of the existing tables $($Student and Registration$)$ in the Career database by modifying the field properties. Jeremiah would also like you to populate the Course and Registration tables. Complete the following:

Open the Career database you created in the previous module.

Open the Student table in Design view, and set the field properties shown in Figure $2-46.$

IC $2-54$

Access $|$ Module $2$ Building a Database and Defining Table Relationships

Figure $2-46$

Field properties for the Student table

$\backslash$table$[[$Field Name,Data Type,Description,Field Size,Other$],[$StudentID$,$Short Text,Primary key,$7,$Caption $=$ Student ID$],[$FirstName$,$Short Text,,$20,$Caption $=$ First Name$],[$LastName$,$Short Text,,$25,$Caption $=$ Last Name$]]$