Skip to main content

Access Chapter 2

Chapter Demonstrable Skills

After completing the Access Chapter 2 portion of the Access unit, students will be able to:

Demonstrable Skill Learning Activities
& Informal Assessments
Formal Assessments
(excluding Exams)
Design database tables and fields.
  • Access: Database Design Participation Project
  • Access: Fields & Keys Participation Project
  • Homework #4
  • Homework #5
Choose primary and composite keys.
  • Access: Database Design Participation Project
  • Access: Fields & Keys Participation Project
  • Homework #4
  • Homework #5
Determine necessary relationships and foreign keys.
  • Access: Database Design Participation Project
  • Access: Fields & Keys Participation Project
  • Homework #4
  • Homework #6
Create and modify database tables.
  • Access: Access Basics Participation Project
  • Access: Database Creation Participation Project
  • Access: Fields & Keys Participation Project
  • MyLab Lesson C
  • MyLab Lesson D
  • Homework #4
  • Homework #5
  • MyLab Lesson C
  • MyLab Lesson D
Create database relationships and use referential integrity, cascade updates, and cascade deletes.
  • Access: Database Creation Participation Project
  • Access: Fields & Keys Participation Project
  • MyLab Lesson C
  • Homework #4
  • Homework #5
  • Homework #6
  • MyLab Lesson C
Use criteria to restrict text, numeric, date, and yes/no field values.
  • Access: Queries II Participation Project
  • Access: Queries III Participation Project
  • Access: Queries IV Participation Project
  • MyLab Lesson C
  • Homework #4
  • Homework #5
  • Homework #6
  • MyLab Lesson C
Apply sorting to query results.
  • Access: Queries I Participation Project
  • Access: Queries II Participation Project
  • Access: Queries III Participation Project
  • Access: Queries IV Participation Project
  • MyLab Lesson C
  • Homework #4
  • Homework #5
  • Homework #6
  • MyLab Lesson C
Specify outer join relationships in a query.
  • Access: Queries III Participation Project
Control if query fields are shown in the results.
  • Access: Queries III Participation Project
  • Access: Queries IV Participation Project
  • Homework #5
Specify wildcard query criteria.
  • Access: Queries IV Participation Project
Copy existing queries.
  • Access: Queries IV Participation Project

Chapter Notes

Designing tables

Tables provide the framework for all of the activities you perform in a database [1]. The first step is to list all of the tables you need for the database and list all the fields, assigning each field a data type. It is very important that the tables contain all of the necessary fields so that the system can produce the required information.

Relationships

A primary key is unique identifier that will not be repeated in a table [1]. Access does not require that each table have a primary key. However, a good database design usually includes a primary key in each table. When no primary key occurs, you can create a primary key with the AutoNumber-type field which automatically increments each time a record is added.

A foreign key is a field in one table that is also the primary key of another table.

Queries

A query asks a question of the database [1]. The Query Design tool is used to create select queries. A select query is a specific type of query that displays only the records that match criteria entered in the query Design View.

Once you design the query, you may need to add criteria. Criteria can consist of all kinds of delimiters to include or exclude records. 

Tips & Tricks

Relationships

When you are relating two tables, look at the primary key of both tables. See if you can find either primary key in the other table (as a foreign key) [2].  

References

  1. A. Poatsy, K. Mulberry, C. Krebs, L. Hogan, A. Rutledge, and E. Cameron, Exploring Microsoft Office 2013, 1st ed., vol. 1. Upper Saddle River, NJ: Pearson Education, 2013.
  2. R. G. Phipps and B. M. Powell, “Access Chapter 2,” Computer Science 101, May 18, 2016. Available: http://cs101.wvu.edu/materials/units/access/access-chapter-2/.