Exp19_access_ch05_cap_varmel_studio_toys | Computer Science homework help

 #Exp19_Access_Ch05_Cap_Varmel_Studio_Toys 
 #Exp19_Access_Ch05_Cap_Varmel_Studio_Toys 
 Start Access. Open the file named Exp19_Access_Ch05_Cap_Varmel_Studio_Toys.accdb. Grader has automatically added your last name to the beginning of the filename. 
 You will save the database file with a new name and create a new table that will be the source for a lookup.
Save the database file as Exp19_Access_Ch05_Cap_Varmel_Studio_Toys_LastFirst.accdb. Use Design view to create a new table. Add ItemTypeID as the first field name, with data type AutoNumber; add ItemTypeDescription as the second field name, with data type Short Text and field size 15. 
 
Ensure ItemTypeID is set as the primary key. Save the table and name it Item Types. Add two records: Action Figure and Poster. Close the table.
884
You will edit the Inventory table design to validate data. You will make two fields required and add a validation rule to a field. You will also make sure you test the validation to make sure the rules work as intended.
Open the Inventory table in Design view. Set the InventoryQty and ItemTypeID fields to Required.

YOU MAY ALSO READ ...  1-1 discussion: getting started discussion: liberal arts in your life | IDS100

Assignment status: Already Solved By Our Experts

(USA, AUS, UK & CA Ph. D. Writers)

CLICK HERE TO GET A PROFESSIONAL WRITER TO WORK ON THIS PAPER AND OTHER SIMILAR PAPERS, GET A NON PLAGIARIZED PAPER FROM OUR EXPERTS

Order from Australian Expert Writers
Best Australian Academic Writers

QUALITY: 100% ORIGINAL PAPER – NO PLAGIARISM – CUSTOM PAPER