Question

1

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.
2
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.
3
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.
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 ItemTypelD fields to Required.
5
Establish a validation rule for the InventoryQty field that requires the value to be greater than or equal to zero. Create validation text for the InventoryQty: The value of this field must be 0 or greater. (include the period). Save the table. Switch to Datasheet view. Change the InventoryQty in the first record to -2. The validation text appears. Close the message box, then press Esc to restore the original InventoryQty value. Close the Inventory table.

Answer 1

The question involves using Microsoft Access to save and rename a database, create a table with fields, ensure data integrity by making fields required and setting a validation rule, and testing the validation rule.

The student has been asked to perform several tasks related to managing a database file in Microsoft Access. Steps include renaming and saving a database, creating and populating a new table, setting a primary key, making fields required, establishing a validation rule for a field, and testing that validation rule. These are key skills for managing data integrity and ensuring the proper functioning of a relational database.

The student will first save a database with a new file name that includes their own name. Then, using Design view, the student will create a new table called Item Types with fields ItemTypeID and ItemTypeDescription. After setting the primary key and saving the table, they will add records to this table. Subsequently, the student will modify the Inventory table by setting two fields to 'Required' and establishing a validation rule to ensure InventoryQty is greater than or equal to zero, with appropriate validation text, and then test this validation rule.