Question: I need help for this final project New Perspectives ACCEN Ridgedale College CREATING AND MODIFYING TABLES AND OTHER DATABASE OBJECTS GETTING STARTED . Open the
I need help for this final project


New Perspectives ACCEN Ridgedale College CREATING AND MODIFYING TABLES AND OTHER DATABASE OBJECTS GETTING STARTED . Open the file NP_AC365_2021_1b_FirstLastName_1.accdb, available for download. Save the file NP_AC365_2021_1b_FirstLastName_1.accdb as NP_AC365_2021_1b_FirstLastName_2.accdb Edit the file name by changing "1" to "2". o If you do not see the .accdb file extension, do not type it. The file extension will be added for you automatically. With the file NP_AC365_2021_1b_FirstLastName_2.accdb open, ensure that your first and last name is displayed as the first record in the _GradingInfoTable table. If the table does not display your name, delete the file and download a new copy.Aa~ PO BodyCopy BT IncorrectFeedb Editing A Dictate Sens A. IT Paragraph Styles Voice Sen PROJECT STEPS 1. You are a graduate teaching assistant for Ridgedale College, a private college in the Midwest. To help the college better manage their course scheduling, you have created an Access database and are working on the tables. Create a new table in Datasheet View with the following options: a. Rename the ID field to DeptID and change the data type to Short Text. b. Change the field size of the DeptID field to 4. C. Add a new field with the name DeptName and the Short Text data type. Save the table and use Departments as the table name. E With the Departments table still open in Datasheet View, add the seven records shown in Table 1. Save and close the Departments table
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
