Lab #3: Lakeview Construction
Date: Tuesday, March 22, 2005
Due: Tuesday, March 29, 2005The Lakeview Construction database from the previous labs needs to be updated with "Forms Access". Since there are several maintainers of information for Lakeview, each needs an appropriate form in order to enter their data. The Construction Manager needs to enter new jobs; the Equipment Manager needs to add and modify equipment entries; and the Business Manager needs to add new Contractors to the database. Lastly, Rental Clerks need to enter new rental information each time a customer rents any of their construction equipment.
Using the Forms feature of Microsoft Access, design and build new forms for each activity mentioned above. Be sure to test your forms so that the results of submitting the forms has the correct effect on the database. Use the wizards and help files to get acquainted with the forms and reports available in Access.