Cpsc 215 Access

Front 1

A pattern match uses ____ characters.

Back 1

Wildcard

Front 2

A _____ selects records with a value for the selected field that matches the pattern of the simple condition value

Back 2

Pattern match

Front 3

Double-click the ____ of a field list in Design view to highlight all the fields

Back 3

Title Bar

Front 4

You create the selection criterion for a non matching value using the ____ logical operator

Back 4

not

Front 5

The _____ symbol is a concatenation operator that joins text expressions

Back 5

& (ampersand)

Front 6

The aggregate function _____ returns the number of non null field values in a selection of records

Back 6

count

Front 7

The aggregate function ____ returns the variance of the field values in a selection of records

Back 7

Var

Front 8

A ______ query is a select query that locates duplicate records in a table or query

Back 8

find duplicate

Front 9

If you want to display all students who have the same phone number, you would use a _____ query

Back 9

find duplicates

Front 10

SQL stands for ______ and is a standard language used in querying, updating, and managing relational databases

Back 10

Structured Query Language

Front 11

For the ______ property, you enter either an integer or a percentage to determine how many records display

Back 11

Top Values

Front 12

A _____ field lets the user select a value form a list of possible values

Back 12

look up

Front 13

An ______ is a predefined format used to enter and display data in a field

Back 13

input mask

Front 14

The capability to update field properties in objects automatically when you modify a table field property is called _______

Back 14

property propagation

Front 15

An _____ exists between two objects when a change to the properties of data in one object affects the properties of data in the other object

Back 15

object dependency

Front 16

A table _____ rule compares one field value in a table record to another field value in the same record to verify their relative accuracy

Back 16

validation

Front 17

To make sure that a user enters a value in one table field that is chronologically either, for example, than the value in another field in the same record, you can set Validation Rule and Validation Text properties for the ____ instead of for an individual field

Back 17

table

Front 18

To open the Find and Replace dialog box, click the Find button on the _____ tab

Back 18

home

Front 19

The values specified for a search operation can be exact values or they can include a _____ character

Back 19

wildcard

Front 20

To create a form based on two tables, you must first define a ____ between the two tables

Back 20

relationship

Front 21

When you create a form containing data from two tables that have a one-to-many relationship, Access uses the defined relationship between the two tables to automatically join the tables through the _____ that exists in both tables

Back 21

common field

Front 22

Forms for tables that have a one-to-many relationship will have a ______ form and a subform

Back 22

main

Front 23

When creating a form based on two tables, you create a subform for data from the _____ table

Back 23

related

Front 24

The Access feature that can guide you through the creation of a report by asking questions is called the _______

Back 24

Report Wizard

Front 25

The set of field values for the fields in a report that belong to a related table are called _____ records

Back 25

detailed

Front 26

In a form with a main form and a subform, there will be two sets of ____ buttons for use in selecting records from each of the tables

Back 26

Navigation

Front 27

When in Print Preview, you can use the _____ to toggle between a full page display and a close-up display

Back 27

The pointer full page display

Front 28

To print a single page of a report, first click the ____ button in the Print group on the Print Preview tab

Back 28

print

Front 29

The ____ button lets you search for specific data in a form and display only the qualifying records

Back 29

find

Front 30

A _____ is a predefined set of formats that enhance a form's appearance and usability

Back 30

theme

Front 31

To move multiple controls on a report, hold down the ___ key to select them all so you can move them as a unit

Back 31

shift

Front 32

The ____ symbol appears in the upper-left corner of a form to indicate the form is in editing mode

Back 32

pencil

Front 33

_______ in a report or form is special formatting applied to certain field values depending on one or more conditions----similar to criteria you establish for queries

Back 33

Conditional formatting

Front 34

Use the ____ wildcard symbol to match any single numeric character

Back 34

# (pound sign)

Front 35

You can use the ____ property to enter an optional description for a field to explain its purpose or usage

Back 35

description

Front 36

A ____ is not required for a field, but it is a useful way to explain its purpose or usage

Back 36

Description property

Front 37

You create a database by first identifying all the _____ needed to produce the required information

Back 37

fields

Front 38

A field or collection of fields that uniquely identifies a record within a table is the ____

Back 38

primary key

Front 39

If no one field can be used to make each record unique, you can use a _____ as the primary key

Back 39

Composite Key

Front 40

A foreign key is a field in one table that is also defined as a ____ in a different table

Back 40

primary key

Front 41

The characteristics of a field that determine how it is stored and displayed are called the field ____

Back 41

properties

Front 42

The name that you use to save a table must be ____ within the database

Back 42

unique

Front 43

When you select or enter a value for a property, you ____ the property

Back 43

set

Front 44

If you have a Customer ID field with values like 1234AC, you should use the ____ data type

Back 44

text

Front 45

The ____ format is used for currency fields with no dollar signs

Back 45

standard

Front 46

When a primary key has been specified, Access forces you to enter a value for the primary key field in every record din the table. This is known as _____

Back 46

entity integrity

Front 47

Once you click the ____ button to open the Show Table dialog box, you can choose a table to add to the Relationships window, as shown in the accompanying figure

Back 47

Show table

Front 48

You can quickly insert the value from the same field in the previous record using the ____ keyboard shortcut

Back 48

ctrl +

Front 49

When you want to import data from an Excel worksheet into an Access table, any ____ property values set for the fields in the table are not considered in the import process

Back 49

Caption

Front 50

You use the ____ tab if you want to import data from an Excel worksheet

Back 50

External data

Front 51

The ____ allows you to add a group of related fields to a table at the same time, rather than adding each field to the table individually

Back 51

Data type gallery

Front 52

When you change a field's property in Design view, you can ____ or update the corresponding property on forms and reports that include the field you have modified

Back 52

propagate

Front 53

In the ____ you include the fields and record selection criteria for the information you want to see

Back 53

design grid

Front 54

The default query name is____

Back 54

query 1

Front 55

When you create a query, you tell Access what ___ should be used to select the data

Back 55

criteria

Front 56

It is a good idea to build specialized and complicated queries by using the ______

Back 56

Query Wizard

Front 57

To include a field in a query, you can click and ____ the field from the field list to the design grid

Back 57

drag

Front 58

The results of a query can be seen at any time by pressing the _____ button

Back 58

View or run

Front 59

You can tell if a field will appear in the query data sheet if there is a check mark in the fields ____ check box in the design grid

Back 59

show

Front 60

When the sort field is ___, records with the same sort field value are grouped together, but they are not in a specific order within the group

Back 60

Nonunique

Front 61

If multiple records can have the same value in the field specified as the sort field, the sort field is ____-

Back 61

nonunqiue

Front 62

When you specify a sort using two or more nonadjacent sort fields, you must specify the sort fields in ____ view

Back 62

design

Front 63

A query operator that asks Access to match the values of a database field to the selection criteria is known as a _______

Back 63

comparison opertator

Front 64

A condition usually consists of an operator, often a comparison operator, and a _____

Back 64

value

Front 65

To define a condition for a field, you place the condition in the field's _____ box in the design grid

Back 65

Criteria

Front 66

The condition that requires a value in a specified field to be identical to the specified condition is called an _____

Back 66

exact match

Front 67

A _____ is a predefined set of formats including colors, fonts and other effects that enhance an object's appearance and usability

Back 67

theme

Front 68

Specifying multiple conditions in query requires the use of ____ to combine two or more conditions

Back 68

logic operators

Front 69

In complex expressions, you can enclose calculations in _____ to indicate which ones should be performed first

Back 69

parenthesis

Front 70

A ____ field displays the results of an expression

Back 70

calculated

Front 71

A set of data such as first name, last name, address, etc. for a specific person is a _____

Back 71

record

Front 72

The content of a field is the _____

Back 72

field value

Front 73

A group of related tables is called a ____ database

Back 73

relational

Front 74

Data in one or more tables can be related to each other by means of a _____ field

Back 74

common

Front 75

In a given table, a field is defined as a ____ when its values uniquely identify each record in the table

Back 75

primary key

Front 76

A relational DBMS provides protection of ____ through security, control and recovery facilities

Back 76

databases

Front 77

Access has a built-in _____ language that allows you to ask questions and obtain answers about your data

Back 77

query

Front 78

You can search for a ____ and download it from Office.com

Back 78

template

Front 79

Give fields descriptive ____ so that you can easily identify them when you view or edit records

Back 79

names

Front 80

The _____ determines what field values you can enter for the field

Back 80

data type

Front 81

A table's ____ includes the field names and characteristics of the fields themselves, plus any layout changes to the datasheet

Back 81

design

Front 82

To close an open database without exiting the Access program, click the File tab to display Backstage view, and then click ______

Back 82

close database

Front 83

To view field or records that are not visible on you display, you can use the vertical or horizontal _____

Back 83

scroll bars

Front 84

When you create a ____ you tell Access which fields you need and what criteria Access should use to select the records that will answer you quetsion

Back 84

query

Front 85

You use a ____ to enter, edit, and view records in a database

Back 85

form

Front 86

Each object in the Navigation Pane has a unique ____ to indicate the type of object

Back 86

icon

Front 87

A form's ____ property specifies the table or query that provides the fields for the form.

Back 87

Record Source

Front 88

To create a _____ form, you can modify and existing form or design and create a form from scratch.

Back 88

Custom

Front 89

A ____ is a control that provides the features of a text box and a list.

Back 89

Combo Box

Front 90

In addition to printing the Relationships window, you can use the ______ to create detailed documentation of all, or selected, objects in a database.

Back 90

Documenter

Front 91

The ____ tool creates a form in a data sheet format that contains all the fields in the source table or query.

Back 91

Datasheet

Front 92

The ____ took creates a customizable form that displays multiple records from a source table or query in a data sheet format.

Back 92

Multiple Items

Front 93

The ____ tool creates a customizable form that displays the data in a form in both Form view and Datasheet view at the same time.

Back 93

Split Form

Front 94

A _____ is a set of controls grouped together in a form or report, so that you can manipulate the set as a single control.

Back 94

Control Layout

Front 95

The _____ property for a control automatically resizes the control and places the control in the same relative position on the screen as the screen size and resolution change.

Back 95

Anchor

Front 96

A ____ is a separate form contained within another form.

Back 96

Subform

Front 97

A ____ form is a form that has a table or query as its record source.

Back 97

Bound

Front 98

If you want a label to display different text on the form, you need to change the label's _____ property value.

Back 98

Caption

Front 99

_____ handles let you resize a control.

Back 99

Sizing

Front 100

The handle in a control's upper-left corner is its _____, which you use to move the control.

Back 100

Move Handle

Front 101

A ____ Wizard asks a series of questions and then uses your answers to create a control in a form or report.

Back 101

Control

Front 102

You can remove a section by setting its height to ______.

Back 102

Zero

Front 103

The _____ property determines if Access displays a control or section.

Back 103

Visible

Front 104

To calculate the total of an expression, you use the ____ function.

Back 104

Sum

Front 105

The _____ property specifies whether users can use the Tab key to move to a control on a form.

Back 105

Tab Stop

Front 106

The ______ button allows you to change the background color of a control, section, or object.

Back 106

Background Color