Description

Laboratory Work

Database Management Systems

• the Relational Model
• Relationships
• Structured Query Language (SQL)
• Database Design

Chapter 6

Database Functions in a Spreadsheet

• LOOKUP/COUNTIF
• VLOOKUP
• MATCH
• INDEX

Chapter 7 and 8

Intro to Microsoft Access

• Adding a new field to a table
• Adding and deleting records
• Creating a Form
• Creating a Report
• Creating a Query

Dale & Lewis:

• Chapter 12.3
• Implementation