Cis Final

Front 1

The three basic steps to creating a database, in order, are: ____.

Back 1

1. B. identify the individual fields, group fields in a table, enter field values for each record selected

Front 2

A primary key ____.

Back 2

1. C. must contain a unique value for each record within the table selected

Front 3

A field that is defined in a table and that is also defined as a primary key in a different table is a(n) ____.

Back 3

1. D. foreign key selected

Front 4

You can make a(n) ____ copy of a database file to protect your database against loss or damage.

Back 4

1. B. backup selected

Front 5

When you delete records, the space that had been occupied on the disk by the deleted records does not become available until you ____ the database.

Back 5

1. C. compact selected

Front 6

: A table can be logically connected to another table by defining a ____.

Back 6

1. A. common field selected

Front 7

The characteristics of a field, such as name, size, and type, are called the field ____.

Back 7

record

Front 8

A field defined as a yes/no field type will be displayed as a ____.

Back 8

1. C. check box selected

Front 9

Records can be copied and pasted into one table from another table if the tables have ____.

Back 9

the same structure

Front 10

A ____ relationship exists between two tables when one record in the first table matches zero, one, or many records in the second table.

Back 10

1. D. one-to-many selected

Front 11

: Referential ____ is a feature built in to Access to prevent data inconsistency in related tables

Back 11

1. B. integrity selected

Front 12

The order in which fields are displayed in a query depends on ____.

Back 12

1. A. the order of the fields in the design grid selected

Front 13

After applying a filter, you can click the ____ button to toggle between filtered and nonfiltered displays.

Back 13

. Remove Filter selected

Front 14

You can tell Access which records are to be selected by specifying a(n) ____.

Back 14

1. D. condition selected

Front 15

Multiple conditions can be defined to control which records are selected through the use of ____.

Back 15

1. A. logical operators selected

Front 16

MC: Statistical information, such as totals and averages, can be calculated in a query by using a(n) ____.

Back 16

1. C. aggregate function selected

Front 17

The ____ operator is a comparison operator that allows you to check whether or not a particular field value is part of a list of values.

Back 17

logical

Front 18

: ____ levels are useful for reports with multiple levels.

Back 18

1. A. Grouping selected

Front 19

: Before you begin a Find operation on a form, you must first ____.

Back 19

1. C. select a field selected

Front 20

When a picture or other graphic image is placed in the Report Header section, it will appear ____.

Back 20

1. A. once at the beginning of the report selected