Database Mang

Front 1

Which is NOT a feature of Access reports?

Back 1

easy-to-use data entry screen

Front 2

The wildcard character that stands for any group of characters is the ___________.

Back 2

asterisk (*)

Front 3

A/An __________ is a temporary view of the data that is removed when you close the datasheet.

Back 3

filter

Front 4

Tables, queries, and forms are examples of Access __________.

Back 4

objects

Front 5

__________ integrity refers to a set of Access rules that govern data entry and helps to ensure data accuracy.

Back 5

Referential

Front 6

A query datasheet is sometimes called a __________ of the data.

Back 6

logical view

Front 7

Which Access object contains all of the raw data within the database?

Back 7

table

Front 8

Which data type stores only one of two values?

Back 8

yes/no

Front 9

In large datasheets, you may want to __________ certain fields so that they remain on the screen at all times.

Back 9

freeze

Front 10

Which of the following is NOT a data type?

Back 10

formula

Front 11

Access saves __________ automatically as you move from record to record.

Back 11

data

Front 12

Which two properties are required for every field?

Back 12

Field Name and Data Type

Front 13

A group of related fields, such as all the demographic information for one customer, is called a/an __________.

Back 13

record

Front 14

Which Access object provides an easy-to-use data entry screen?

Back 14

form

Front 15

A specific category of data such as a customer's name, city, state, or phone number is called a/an __________.

Back 15

field

Front 16

__________ View provides the most options for defining fields.

Back 16

table design

Front 17

Which data type is used for sequential integers controlled by Access?

Back 17

AutoNumber

Front 18

A title for a report would most commonly be placed in which report section?

Back 18

Report Header

Front 19

Which type of control is most commonly placed in the Detail section?

Back 19

text box

Front 20

Which form view cannot be used to view data?

Back 20

desing

Front 21

The most common unbound control is the __________.

Back 21

label

Front 22

The most common bound control is the _________

Back 22

text box

Front 23

Every element on a form is called a/an __________

Back 23

control

Front 24

A __________ box is an outline box you create by dragging the pointer in Report Design View.

Back 24

selection

Front 25

Which of the following is NOT a method of selecting more than one control at a time in Report Design View?

Back 25

Right-dragging

Front 26

Which command is used to copy a control from one report section to another?

Back 26

copy

Front 27

The Report Header section prints __________.

Back 27

at the top of the first page

Front 28

For your report to fit on one page in a given orientation, you may need to move all of the controls within a given mark on the horizontal __________.

Back 28

ruler

Front 29

If a report is too wide, you will see a green error indicator in the __________ corner of the report.

Back 29

upper-left

Front 30

Which report view's primary purpose is to quickly review the report without page breaks?

Back 30

report view

Front 31

Which of the following would NOT be considered a graphic image?

Back 31

text

Front 32

__________ refers to the space between the outer edge of the control and the data displayed inside the control.

Back 32

margin

Front 33

Which control is both a list box and a text box control?

Back 33

combo box

Front 34

__________ View lets you make some design changes to a form while you are browsing the data.

Back 34

layout

Front 35

__________ records are those on the many side of a relationship that do not have a match on the one side.

Back 35

orphan

Front 36

Which of the following is NOT a form view?

Back 36

data

Front 37

The Form Wizard prompts you for information it needs to create a form, such as the __________ for the form.

Back 37

all of the above

Front 38

Which of the following is not an aggregate function available to a summary query?

Back 38

subtotal

Front 39

The process of removing and fixing orphan records is commonly called ____________.

Back 39

Scrubbging the database.

Front 40

Which symbol is used to identify the "many" field in a one-to-many relationship in the Relationships window?

Back 40

infinity

Front 41

Which arithmetic operator signifies exponentiation?

Back 41

/\

Front 42

What is the purpose of enforcing referential integrity?

Back 42

To prevent orphan records from being created

Front 43

The query datasheet can best be described as a __________

Back 43

Logical view of the selected data from underlying tables.

Front 44

What property controls both the values that users can enter into a text box and provides a visual guide as users enter data?

Back 44

Input Mask

Front 45

The query datasheet can best be described as a __________.

Back 45

Logical view of the selected data from underlying tables.

Front 46

What is the purpose of enforcing referential integrity?

Back 46

To prevent orphan records from being created

Front 47

Which Short Text field property should you use to specify whether an entry was required for the field?

Back 47

Required

Front 48

The default filename extension for a database created in Access 2013 is __________.

Back 48

.accdb

Front 49

When you update data in a table that is also selected in a query, ___________.

Back 49

The updated data is automatically displayed in the query.

Front 50

Which of the following is not true about field properties?

Back 50

They are the same for each data type.

Front 51

The wildcard character that represents any combination of characters in query criteria is the __________.

Back 51

asterisk (*)

Front 52

A crosstab query is generally constructed with how many fields?

Back 52

3

Front 53

Which of the following problems most clearly indicates that you need to redesign your database?

Back 53

There is duplicated data in several records of a table.

Front 54

Which function should you use to calculate the monthly payment on a loan?

Back 54

PMT

Front 55

Which key do you press when creating a line to make it perfectly horizontal?

Back 55

shift

Front 56

Which of the following reports would be the most logical choice for a Vice President who is interested in high level, aggregated totals and not individual details?

Back 56

summary report

Front 57

Which control works best to display three choices--1, 2, or 3--for a Rating field?

Back 57

Options group

Front 58

Which of the following form sections often contains command buttons?

Back 58

Form Header

Front 59

In Report Design View, if you want to view the grouping and sorting fields, click the ________.

Back 59

Group & Sort button

Front 60

Which section most often contains calculations for groups of records?

Back 60

Group Footer

Front 61

Which control would you use to combine two reports?

Back 61

Subreport

Front 62

Which feature allows you to apply the same formatting characteristics to all the controls in a report at once?

Back 62

Themes

Front 63

Which is a popular layout for a subform?

Back 63

datasheet

Front 64

Which is a popular layout for a main form?

Back 64

Columnar

Front 65

Which control would you use to initiate a print action?

Back 65

Command button

Front 66

You create a parameter report based on a parameter query by setting the report's ______ property.

Back 66

record source

Front 67

Which control would you use to visually separate groups of records on a report?

Back 67

line

Front 68

Which control is most commonly used within an option group?

Back 68

option button

Front 69

To align controls on their left edges, first _________________.

Back 69

Select the controls whose edges you want to align.

Front 70

What feature allows you to apply the formatting characteristics of one control to another?

Back 70

Format Painter

Front 71

You enter parameter criteria in Query Design View inside of _________.

Back 71

[square brackets]

Front 72

Which control would you use to display a drop-down list of 50 states?

Back 72

combo box

Front 73

The _______ creates a 3-D aspect to a form.

Back 73

tab control

Front 74

The combo box gets its values from the list entered in the _______ property.

Back 74

row source

Front 75

Which of the following phrases best describes the need for both null values and zero-length strings?

Back 75

They represent two different conditions.

Front 76

Which of the following file formats allows you to send information that cannot be modified?

Back 76

PDF

Front 77

Which type of template creates a traditional Access database?

Back 77

desktop database

Front 78

First normal form can be described as __________

Back 78

a single two-dimensional table with rows and columns

Front 79

Which of the following activities occurs during the creation of second normal form?

Back 79

Redundant data is removed from one table, and relationships are created.

Front 80

Two tables have a __________ relationship when they are both related to the same intermediate table with one-to-many relationships.

Back 80

many-to-many

Front 81

Which report property is used to add a watermark to a report?

Back 81

picture

Front 82

Which of the following activities occurs during the creation of third normal form?

Back 82

Calculated fields are removed from tables

Front 83

Which of the following fields would most likely be used for an index?

Back 83

lastname

Front 84

A numeric field allows you to calculate a/an __________ statistic in the Totals cell.

Back 84

all of the above

Front 85

A multifield primary key consists of __________.

Back 85

two or more fields

Front 86

Which of the following is not true about database templates?

Back 86

They analyze the data on your computer and suggest database applications.

Front 87

Which is not true about enforcing referential integrity?

Back 87

It is required for all one-to-many relationships.

Front 88

Which of the following is not a file format that Access can import?

Back 88

word

Front 89

A __________ relationship cannot be created directly between two tables in Access.

Back 89

many-to-many

Front 90

Which of the following is not true about linking?

Back 90

Linking copies data from one data file to another.

Front 91

To import data from Excel to Access, you would begin by clicking the __________.

Back 91

EXTERNAL DATA tab

Front 92

Which of the following is not true about exporting

Back 92

Exporting retains a link between the orginal and target data files.

Front 93

Which join type selects all records from the "one" (parent) table?

Back 93

left

Front 94

This type of query displays a dialog box prompting you for criteria.

Back 94

Parameter query

Front 95

This is used in an expression to calculate a value based on a field that is not included in the Record Source property for a form or report.

Back 95

Domain function

Front 96

This type of join means that the query displays only records where joined fields from both tables are equal.

Back 96

inner join

Front 97

Which of the following is a valid parameter criterion entry in the query design grid?

Back 97

>=[Type minimum value here:]

Front 98

When querying tables in a one-to-many relationship with referential integrity enforced, which records appear (by default) on the resulting datasheet?

Back 98

Only those with matching values in both tables.

Front 99

Which of the following is not a type of Select query?

Back 99

update

Front 100

This type of query makes changes to data.

Back 100

action query

Front 101

Which of the following is not an action query?

Back 101

union query

Front 102

This type of query displays only a number or percentage of records from a sorted query,

Back 102

top values

Front 103

This type of join means that the query displays only records where joined fields from both tables are equal.

Back 103

inner join

Front 104

Which of the following is not a type of Select query?

Back 104

update

Front 105

Which dialog box allows you to specify the number of columns you want to view in a report?

Back 105

page setup

Front 106

To set a page break before a Group Header section on a report, you would modify the properties of the __________.

Back 106

Group Header section