A.Lab BSBA BIS245A-7

 

B.Lab7 of7: DatabaseNavigation

 

C.LabOverview—Scenario/Summary:

 

COs:

 

8.Givena databaseapplicationcontainingforms,queries, and reports,automatetasks and createa menu systemwhich allows forefficientnavigationand operationofthe database’sfunctionality.

 

Scenario:

 

ThepurposeofthislabistoshowthestudenthowtocreatenavigationsystemsforanAccess application.Studentswillcreateamainnavigationformwhichlinkstoadditionalnavigationforms calledenterdataandviewreports.Additionally,studentswillcreateformstoautomateprinting reportsandclosing/exitingthedatabase.Theenterdataformallowsyoutoopencustomerandcity formsautomatically.Theviewreportsformallowstheusertoautomaticallyopenthecustomerlist andcustomersbycityreports.Theprintreportsformwillallowuserstoautomaticallyprintthe reports.Theexitdatabaseformallowsuserstoclosethedatabaseandexittheapplicationentirely.

 

Thenavigationformscanprovidesomemeasureofsecuritytothedatabaseastheymayprevent usersunfamiliarwithAccessfromaccessingdatabaseobjectsdirectly;theymakeusingAccessmore intuitivetouseandcanpreventnewusersfrominadvertentlydamagingyourdatabaseobjects.

 

 

D.Deliverables:

 

Upload themodifiedLab7_Start.accdbfilethatyou saved as YourName_Lab7.accdbtothe

Week7 LabAssignment.

 

Step	Deliverable	Points
Part A	Develop the EnterData,View Reports,PrintReports,and Customer DatabaseNavigationForms.
Part B	CreatetheClose DatabaseFormand add ittotheMain Database Navigation Form.SettheDatabaseOptions.

 

 

 

E.LabSteps:

 

Preparation:

·         Download theAccess starter filefromthe Week 7 Lab page, and save thefileonto“c:\”directory(your local drive).

·         Using CitrixforMSVisio and/or MSAccess

o   Ifyou are using theCitrixremotelab,followthelogin instructionslocatedin the Lab areaunder Introduction and Resources.

o   You will have toupload theLab7_Start.accdbfiletoyour Citrixfolder.Followtheinstructionslocatedin theLabareaunder Introduction and Resources.

o   StartMSAccess.

·         IfyouareusingCitrix,clickonMicrosoftOfficeApplicationsfolder.

·         IfyouareusingAccessonalocalcomputer,selectMicrosoftOfficefromyourprogrammenu.

 

MSAccess Switchboards

 

In the past, users navigated database applications using a menu system based on a hierarchy similar to that illustrated below.

Attachments:

• 1551553962-BIS245_W7_Lab_Instructions17v2.docx