BIS 245 Week 7 iLab
The purpose of this Lab is to show the student how to create navigation systems for an Access application. Students will create a main navigation form which links to additional navigation forms called Enter Data and View Reports. Additionally, students will create forms to automate printing reports and Closing or Exiting the Database. The Enter Data form allows you to open Customer and City forms automatically. The View Reports form allows the user to automatically open the Customer List and Customers by City reports. The Print Reports form will allow users to automatically print the reports. The Exit Database form allows users to close the database and exit the application entirely.
The navigation forms can provide some measure of security to the database as they may prevent users unfamiliar with Access from entering database objects directly; they make using Access more intuitive to use, and can prevent new users from inadvertently damaging your database objects.
Submit the modified Lab7_Start.accdb file that you saved as YourName_Lab7.accdb to the Week 7 Lab for grading.
Part A:Â Develop the Enter Data, View Reports, Print Reports, and Customer Database Navigation forms.
Part B:Â Create the Close Database form and add it to the Main Database Navigation form. Set the Database Options.
Microsoft Office: Word 2013, Visio 2013, and Access 2013
Options for accessing the software.
- Use a personal copy on your PC. You can request a copy of Microsoft Office 2013 via the Student Software Store icon on the Course Resources Page. Microsoft Office is located on the Students tab and all other Microsoft products, such as Visio and Access, are located on the DreamSparks tab.
- If you are a MAC user, click to read theÂ MAC User Information.
- ClickÂ DeVry virtual labÂ (Links to an external site.)Â environment to access all Microsoft Office software. For additional information about the virtual lab and how to save files, click the Lab icon on the Course Resources page.
STEP 1: Complete the Week 7 Lab
Download and complete theÂ Week 7 Lab InstructionsÂ (Links to an external site.).
Download the following file to complete your Lab assignment