(Solved) : Ex16acch05gradercapas Paterson Credit Union Project Description Work Database Administrato Q29976118 . . . .

EX16_AC_CH05_GRADER_CAP_AS – Paterson CreditUnion

Project Description:

You work as a database administrator at the Paterson CreditUnion. You are modifying a database to add validation, lookupfields, and an input mask. You will also modify queries to takeadvantage of advanced functions and features.

Instructions:

For the purpose of grading the project you are required toperform the following tasks:

Step

Instructions

Points Possible

1

Start Access. Open the file namedexploring_a05_grader_a1_Bank.accdb.

0

2

Use Design view to create a new table. AddAccountType as the first field name, with datatype Short Text and field size 10. EnsureAccountType is set as the primary key. Save the table and name itAccountTypes. Add three records:Platinum, Silver, andGold. Close the table.

4

3

Open