Using Microsoft Access

Tools 4 U is a tool rental company that reaches out to people with little or no experience. The firm has a staff of technicians to help customers select the right tools, show them how to use the tools, and provide 24/7 support. Background The company is working on an online system to manage its growing business. The company asked you to help design the user interface.

Tasks

1)Design a data entry screen for entering new members.

2)Design an online tool rental screen. You can use your imagination, but be sure to apply the principles discussed in this chapter.

3)Suggest at least three data validation rules that might help reduce input errors for the system.

4)Design a screen for managers, with weekly and monthly data on rentals, new customers, late charges, and anything else you think a store manager might want to review. Be sure to include numeric activity and dollar totals.