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

3

Home Town Realty

Real Estate Database

ACCESS WORKING CASE: BEGINNING LEVEL

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

Preview You are the sales manager of a real estate office and you need to create a simple database application with two tables and two data input forms. The office needs you to keep track of all property information and the selling agent's employee 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 data-entry form for each table.

Skill Set

Table Design	Form Design
Field properties	Command buttons
Lookup Wizard	Calculated fields
Validation rule	Images and labels
Validation text	Field properties
Input mask

Background Home Town Realty sells real estate in California, mainly in the Orange County area. The office also provides property management services and is currently managing several apartment buildings in the area. Tom Mahoney is the owner of Home Town Realty and employs three real estate agents. He would like you, the sales manager, to design a database application for his office that includes the current property information and each agent's employee information.

CASE ANALYSIS

Output Requirements

Tom Mahoney wants you, the sales manager, to create a database ...