Description

Laboratory Work

Database Management Systems

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

Databases in a Spreadsheet

Chapter 6

• LOOKUP/COUNTIF
• VLOOKUP
• MATCH
• INDEX

Intro to Microsoft Access

Chapter 7

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

Chapter 8

• Importing data into a database table
• Creating relationships
• Creating a chart
• Recognising features of SQL statements

Dale & Lewis:

• Chapter 12.3

Other Sources:

• Implementing the Theory.