MIS Cases: Solving Small Business Scenarios Using Application Software, 2nd Edition

1

Access—Tables and Forms

1

Up the Hill Bakery

Inventory and Customer Database

ACCESS TEACHING CASE: BEGINNING LEVEL

Submission Instructions Complete Case 1 in Access. Answer the questions at the end of this case and ask your instructor for submission instructions.

Preview You are the restaurant manager of the bakery and you need to create a simple database with two tables using two data entry forms. As the manager you need to keep track of the bakery's inventory and customer contact information. At the end of this case you will be able to create two tables with various field properties and create an easy-to-use input form for each table.

Skill Set

Table Design	Form Design
Field properties	Command buttons
Lookup Wizard	Calculated fields
Validation rule	Page formatting
Validation text
Input mask

Background You are the restaurant manager of a small French bakery in Chula Vista, California. Your customers are local residents and other small restaurants around the city. The bakery delivers fresh bread and pastries to customers; breakfast and lunch are also served within the store. The bakery doesn't bake all their items; some great chefs around the area drop off their specialties as well. As restaurant manager you need to keep track of the bakery's inventory, especially ...