Back To Busn 216 Class Content Home Page
Access Class Content
Video/Class Project 12
Video to watch: M365
Video 12: Introduction to Access Database (
32:47 min)
Start file for Video/Class Project to download:
StuffedAnimalDatabase.accdb
PowerPoint to download: M365Video12_IntroductiontoAccessDatabase.pptx
Video/Class Project 13
Video to watch: M365
Video13: CreateDatabaseImportExcelFilesCreateTablesandFormsBuildRelationships (
49:30 min)
Excel files needed for import prcoess:
M365Video13_SupplierStoreListDataFromExcel.xlsx
M365Video13_CustomerListDataFromExcel.xlsx
Handout to download:
M365Video13_Create
DatabaseImport ExcelCreateTablesandFormsBuild Relationships.pdf
Finished file for Video/Class Project to
download (example of how file looks after video is over):
StuffedAnimalDatabaseFinishedAfterVideo13.accdb
Video/Class Project 14
Video to watch: MS365
Video14: Building/Creating Queries in Access (
40:53 min)
Handout to download:
M365Video14_BuildingQueriesinAccess.pdf
Start file for Video/Class Project to download:
StuffedAnimalDatabaseFinishedAfterVideo13.accdb
Finished file for Video/Class Project to
download (example of how file looks after video is over): StuffedAnimalDatabaseFinishedAfterVideo14.accdb
Video/Class Project 15
Video to watch: M365
Video 15: Use Report Wizard to Create Reports based on Queries and Create
Mailing Labels (
21:22 min)
Handout to download:
M365Video15_UseReportWizardtoCreateReportsBasedonQueriesandCreateMailingLabels.pdf
Start file for Video/Class Project to download:
StuffedAnimalDatabaseFinishedAfterVideo14.accdb
Finished file for Video/Class Project to
download (example of how file looks after video is over):
StuffedAnimalDatabaseFinishedAfterVideo15.accdb
Video/Class Project 16
Video to watch: M365
Video 16: Export Tables Queries and Reports to Excel, PDF And/Or Text Files (
09:51 min)
Start file for Video/Class Project to download:
StuffedAnimalDatabaseFinishedAfterVideo15.accdb