Introduction to Microsoft Access

Date: Wednesday, April 10, 2013
Time: 10:00 AM to 12:00 PM
Location: Maher 114
Instructor: Steve Maier

Links:

http://iteam.sandiego.edu/accessintro
 
Power Point Presentations:
  • section #1
    • Importing Data from Excel to Access
    • Updating and Editing
    • Sorting and Filtering
    • Customizing the toolbar
    • Form Wizard
    • Saving and Printing
  • section #2
    • Using the QBE grid
    • Updating recordsets
    • Creating tables
    • Index and primary keys
  • section #3
    • Create a new database from templates
    • Setting database options
    • Customize navigation pane
  • section #4
    • Create a new database without templates
    • Creating table relationships
    • Referential Integrity
    • Query multiple tables
  • Database Design
accounts.xlsx
BOOKBIZ.accdb
BOOKBIZ DB Diagram
Projects Database Diagram
Video Business Database Diagram
Video Store Membership Form
Access Quick Reference Card