Back To Busn 216 Class Content Home Page

Access Class Content

Access Chapter 01 & 02:

Handouts (Reading) To Download:
DatabaseAndAccessIntroduction.docx
WoddenCraftSteps.docx

Excel Workbook With Examples from "DatabaseAndAccessIntroduction.docx" handout and video (not neccessarly to download, but if you want):
AccessNotes.xlsx


Start Files (Use For Video Projects) To Download:
ProductSupplierDatabase.zip (download Access file in zipped folder, then unzip it)
DataforWoodenCrafts.zip (download Access file in zipped folder, then unzip it)


Example of Finished Files As Seen In Video:
WoodenCraftsFinished.zip (download Access file in zipped folder, then unzip it)
       

 

Videos To Watch:
Office 2010 Class #41: Introduction to Databases and Access (34 mins)
Office 2010 Class #42: Access Create Database, Import Table, Create Table, Data Validation For Table (38 mins)
Office 2010 Class #43: Access One To Many Relationship Between Tables (7 mins)
Office 2010 Class #44: Access Create Forms (User Interface), Enter Data Tricks (8 mins)
Office 2010 Class #45: Creating Queries In Access (16 Examples) (38 mins)
Office 2010 Class #46: Access Create Report Based On A Query
 
(12 mins)
Office 2010 Class #47: Export Data From Access To Excel, PDF or Text File  (7 mins)