Skip to main content

Access Chapter 6

Chapter Demonstrable Skills

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

Demonstrable Skill Learning Activities
& Informal Assessments
Formal Assessments
(excluding Exams)
Use update queries to modify the values of records.
  • MyLab Lesson E
  • MyLab Lesson E
Use delete queries to remove unneeded records.
  • MyLab Lesson E
  • MyLab Lesson E
Create queries to find duplicate records.
  • MyLab Lesson E
  • MyLab Lesson E
Create queries to find unmatched records.
  • MyLab Lesson E
  • MyLab Lesson E
Create cross-tab queries to compare data by multiple columns.
  • MyLab Lesson E
  • MyLab Lesson E
Backup existing databases.
  • MyLab Lesson C
  • MyLab Lesson C

Chapter Notes

Updating data with an Update Query

An update query changes the data values in one or more fields for all records that meet specific criteria [1]. Before updating data in a table, we must locate the records that need to be modified. To do that, we create a select query. We can then convert the select query to an update query by using the option in Query Type group of the ribbon.

Deleting records with a Delete Query

A delete query selects records from a table and then removes them from the table [1]. Be careful when running delete queries as they generally cannot be undone without restoring from a backup file.

Finding duplicate records with a query

Sometimes tables have duplicate data. Having duplicate data can sometimes display wrong results. We can identify duplicate data with Find Duplicates Query created using the Query Wizard [1].

Find unmatched records with a query

A Find Unmatched Query compares records in two related tables and displays the records found in one table but not the other. We can create this query using the Query Wizard [1].

References

  1. A. Poatsy, K. Mulberry, C. Krebs, L. Hogan, A. Rutledge, and E. Cameron, Exploring Microsoft Office 2013, 1st ed., vol. 2. Upper Saddle River, NJ: Pearson Education, 2013.