(Solved) : Begin Assignment Open Universityaccdb Database File Open Department Table Design View Ensu Q38072694 . . . .

To begin this assignment, open the University.accdb databasefile.

Open the Department table. In design view, ensure that thedeptCode field has a length of 4 and > is the display format.Ensure that the length of the deptPhone field is 10 and uses PhoneNumber input mask. Save the table and switch to datasheet view. Usethe following table as a guide and enter data into the Departmenttable.

deptCodedeptNamedeptLocndeptPhonechairNamePHILPhilosophy3C11286-3322Judy ChenBIOLBiology2L88286-9843James Dunn

Create a Course table with attributes for department code,course number, title, short description, and credit hours. Thecredit hours field should be numeric with no decimal places, andthe other fields are Text fields. Set the deptCode field