A.LabBSBA BIS245A-5

 

B.Lab 5Bof7:Completing Forms

 

C.Lab Overview—Scenario/Summary

 

CO(s):

 

5. Givena physicaldatabasecontainingtables andrelationships,create forms whichdemonstrateeffectiveuser-interfacedesignandallowfor efficiententryand retrieval ofdata.

 

Scenario/Summary

 

The labbegins withcreatingaforminAccess using the formwizard.Afterthe formis created,theusercanusethemes tochangetheappearance ofthe form. The secondpart ofthelab usesformdesigntocreateaform.Finally,the form willbecustomized.

 

Uponcompleting this lab,youshouldbeableto

 

•     create aform using theform;

•     create aform usingformdesign;and

•     create aform using theformwizard.

 

D.Deliverables

 

SubmittheMSAccessdatabase filethatcontains the forms createdinthis lab.

 

 

Step	Deliverable	Points
1	Form1—FormTool—step-by-step	5
2	Form2—FormDesign—step-by-step	100
3	Form3—FormWizard—Employee/CustomersMultitableForm —step-by-step	5
4	Form4—SuppliersandProductsMultitable Form	10
5	Form 5—Orders and Employees Multitable Form Using a Query	10
Â	Total	40

 

 

 

E.Lab Steps

 

Preparation

1.Download theAccess starter file fromthe Week 5 Lab page, and savethefiletoyourlocal drive.

2.UsingCitrixfor MSVisioand/orMSAccess

a.Ifyouare using the Citrix remotelab,follow thelogininstructions locatedinthe Lab area in the Introduction and Resources module.

b.Youwill haveto uploadthe BIS245_W5_Lab_AccessStarterFile.accdbfiletoyour Citrixfolder. Follow the instructions locatedontheLab area inthe Introduction and Resources module.

3.StartMS Access

a.Ifyouare usingCitrix,click on MicrosoftOfficeApplicationsfolder.

b.Ifyouare using Visio onalocalcomputer,selectMicrosoftOffice fromyour programmenu.

 

Lab

Attachments:

• 1551550930-BIS245_W5_Lab_Instructions_v2.2.docx