Intermediate Microsoft Access

Date: December 12, 2012
Time: 9:00 AM to 11:00 PM
Location: Serra 156B
Instructor: Steve Maier

Links:

http://bliss.sandiego.edu/accessintermediate

Power Point Presentations: Database Design Creating a multi-table Database Create a new database without templates Creating table relationships Referential Integrity Query multiple tables Extracting information from the database Using operators and functions in queries Using the expression builder Using Parameters in queries Setting query Parameter data types Further types of Access queries Select queries Summary queries Crosstab queries Action queries Getting data into your database Creating Forms Adding controls to forms Main/subforms Unbound dialog forms

InClass Files:  ARCHIVE.txt  CRPT.txt  IIF.txt  PHONE1.txt  PHONE2.txt  USD.jpg

BOOKBIZ.accdb

BOOKBIZ DB Diagram

NewDB.accdb

PROJECTS.accdb

Projects Database Diagram

Video Business Database Diagram

Video Store Membership Form

Access Quick Reference Card

iTeam: http://www.sandiego.edu/its/idt