Storing the same fact in more than one place

1
Storing the same fact in more than one place

• What is redundancy?

2
.mdb

• What is the default file extension for Access
  database files?

3
In one file

• Where does Access store all of its data (tables,
  reports, etc.) for a database?

4
A set of fields

• What is a record?

5
The field that makes a record unique

• What is a primary key?

6
A set of records

• What is a table?

7
Sorting

• What is physically rearranging the records in a
  database?

8
Displays a subset of records from a table
according to specified criteria

• What is a filter?

9
Provides a friendlier interface through which to
add, edit, and delete records

• What is a Form?

10
Recommended field type for phone numbers and zip
codes

• What is a Text field?

11
64 Characters

• What is the maximum length of a field name?

12
50 Characters

• What is the default field size for text fields?

13
The three types of controls on a form

• What are Bound, Unbound, and Calculated controls?

14
Has a field as its data source

• What is a bound control?

15
Has no data source used to display titles,
labels, lines, graphics

• What is an unbound control?

16
Has a mathematical formula or function as its
data source

• What is a calculated control?

17
Characteristic of an object that determines how
the object looks and behaves

• What is a Property?

18
Appears at bottom of every page in a report

• What is a page footer?

19
Has three arguments a condition, the result when
the condition is true, and the result when the
condition is false

• What is the IIF function?

20
Displays the results of a query(Dynamic Subset)

• What is a Dynaset?

21
The most common type of query

• What is a Select query?

22
The Select Query window(also called the Query
Design window)

• When you create a Select Query, what window
  appears?

23
The Design Grid

• What is the name of the lower pane in the Select
  Query window?

24
No! You may not use dollar signs or commas in
criteria for currency fields

• Are commas and dollar signs allowed in currency
  criteria?

25
An action query

• What type of query enables you to update the
  database by changing multiple records is a single
  operation?

26
update queryappend querydelete querymake-table
query

• What are the four types of action queries?

27
Requires that tables in a database be consistent
with one another

• What is Referential Integrity?

28
Imports or links data from Excel into an Access
database

• What is the Get External Data command?

29
Uses aggregate functions to perform operations on
groups of records

• What is a Totals Query?

30
Sum, count, average, maximum, minimum, first,
and last

• What are some aggregate functions available for a
  totals query?

31
Changes the way a field is displayed, but does
not affect the stored value

• What is the Format property?

32
Rejects any record that does not have a value for
the field

• What is the Required property?

33
Rejects any record in which data does not conform
to specified rules for data entry

• What is Validation Rule property?

34
Facilitates data entry by displaying literal
characters such as hyphens in a Social Security
Number

• What is the Input Mask property?

35
Automatically enters a designated value for the
field in each new record

• What is the Default Value property?