Practice Activities Lesson 1: One-to-Many Try This: Do the following steps 1. Open the Brown Bag Lunch database you have been working on. Or, you may download BBL Int ver2.accdb 2. Create a new Table with the command Create->Tables->Table Design. 3. Add the following Fields and Data Types: TypeID, AutoNumber (Also make this the Primary Key) Type, Text 4. Save the Table as tblType. 5. Go to Datasheet View. 6. Add the following to the Type column: Sandwich, Snacks, Breakfast, Tray, Beverages 7. Open the Form Products and switch to Design View. 8. Delete the Type Box on the Form. 9. Go to Form Design Tools->Design and select a Control: Combo Box. Add the Combo Box to the form where the Label Type used to be. 10. Choose the option to get the Combo Box values from another source. Select tblType as the source. Select all available fields. 11. Select the Field Type to sort Ascending. 12. Do NOT hide the Key column. Instead, resize the TypeID column to width zero. 13. Select a field to store: choose Type. Store the value in field Type. 14. Name the Combo Box: Type and finish the Wizard. 15. Change to Form View. Test the Combo Box. Does it display five types of products? 16. Return to Design View. Select the Type Combo Box and open the Property Sheet. 17. Change the Combo Box name to TypeCombo. Set the column widths to be 0”, 1.25” 18. Save the Form. Close the database.