Chap 4
Chap 8
Chap 10
Pivot Table
Access
100

What is an app that overlays information and digital content on top of physical objects or locations?

Augment Reality

100

What allows an operating system to temporarily store data on a storage medium until it can be “swapped” into RAM?

virtual memory

100

What contains data about each file in the database and each field in those files?

data dictionary

100

What does a pivot table do with your data?

summarizes

100

What is a tool that lets you retrieve and filter data from one or more tables based on predetermined standards?

Query

200

What are apps distributed online for a monthly subscription or an annual fee?

SaaS

200

What is a special folder that catalogues specific files and folders in a central location?

library

200

What part of a split database that contains the user interface and other objects?

Front-end

200

Where is the default location for Pivot Tables?

New worksheet

200

What is an objects through which you or other users can add, edit, or display the data stored in your Access desktop database?

Form

300

What is a scam in which a perpetrator sends an official-looking email message that attempts to obtain your personal and/or financial information?

Phishing

300

What define who can access certain resources and when they can access those resources?

permission

300

What is the process of presenting data graphically as charts, maps, or other pictorial formats?

data visualization

300

What is a pivot table visualization tool?

pivot chart

300

What offer a way to view, format, and summarize the information in your Microsoft Access database?

Reports

400

What extracts data from a database based on specified criteria, or conditions, for one or more fields?

Query

400

What is Linux-based operating system designed to work primarily with web apps?

Chrome OS

400

What is process of comparing data with a set of rules or values to determine if the data meets certain criteria?

validation

400

What is the section where you drag your data to categorize it in rows?

the Rows area

400

What is a collection of related data stored in rows and columns in Access called?

Table

500

What is security measures that define who can use a program or app, and what actions they can do within the program or app?

Access Control

500

What enables a computer or device to run another operating system in addition to the one installed?

VM

500

What is the database object that is created based on a field or combination of fields?

index

500

This action updates a Pivot Table to reflect changes in the underlying data.

refresh

500

What is the extension of Access database file?

.accdb