Access Basics - Lecture Notes - CIS 211 - Management Information Systems

We will walk through several of the examples provided in the Tech Plug-ins provided with your textbook. To view the Tech plug-ins, please visit the Blackboard page for the course and follow the directions listed in the green box on the announcements page.

Resources

For today's follow-along lab, you will need to use a Windows computer that has Microsoft Access 2007 installed.

Topics Covered

The item appearing in bold is accompanied by a video in the next section on this Web page.

• General Database Design Practices
• Tables
• Fields (columns), data types, and primary keys
• Records (rows)
• Relationships and Referential Integrity
• Importing spreadsheet data into a database table

Video

Illustrating how to import data from Excel into Access: