chapter 2

Question 1

Back Up Database

Answer 1

Utility that creates a duplicate copy of the entire database to protect from loss and damage.

Question 2

Compact and Repair Database

Answer 2

Reduces the size of database and fixed any error that may exist in the file.

Question 3

Filter

Answer 3

Allows to specify conditions to display only those records that meet those conditions.

Question 4

Selection Filter

Answer 4

Displays only the records that match a criterion you select. it can be used to find records

Question 5

Filter by Form

Answer 5

A more versatile method of selecting data because it enables to display records based on multiple criteria.

Question 6

Template

Answer 6

A predefined database that includes professional designed tables, forms, reports and other objects.

Question 7

Custom web app

Answer 7

Enables you to create a database that you can build and then use and share with others through the web

Question 8

Data Redundancy

Answer 8

unnecessary storing of duplicate data in two or more tables.

Question 9

Data Type

Answer 9

Determines the type of data that can be entered and operations that can be performed on that data.

Question 10

Auto Number

Answer 10

A number that automatically increments each time a record is added

Question 11

Foreign Key

Answer 11

Same field as the primary key in the adjoining table

Question 12

Caption properties

Answer 12

Creates a label that is more understandable than a field name. what

Question 13

Referential Integrity

Answer 13

Enforces rules in a database that are used to preserve relationships between tables when records are changed.

Question 14

Criteria Row

Answer 14

Used to set the rules that determine which record will be selected.

Question 15

Simple Query Wizard

Answer 15

Guides you through query design with step by step process.