Study your flashcards anywhere!

Download the official Cram app for free >

  • Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
  • Read
    Toggle On
    Toggle Off
Reading...
Front

How to study your flashcards.

Right/Left arrow keys: Navigate between flashcards.right arrow keyleft arrow key

Up/Down arrow keys: Flip the card between the front and back.down keyup key

H key: Show hint (3rd side).h key

A key: Read text to speech.a key

image

Play button

image

Play button

image

Progress

1/106

Click to flip

106 Cards in this Set

  • Front
  • Back

Which is NOT a feature of Access reports?

easy-to-use data entry screen

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

asterisk (*)

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

filter

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

objects

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

Referential

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

logical view

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

table

Which data type stores only one of two values?

yes/no

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

freeze

Which of the following is NOT a data type?

formula

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

data

Which two properties are required for every field?

Field Name and Data Type

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

record

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

form

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

field

__________ View provides the most options for defining fields.

table design

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

AutoNumber

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

Report Header

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

text box

Which form view cannot be used to view data?

desing

The most common unbound control is the __________.

label

The most common bound control is the _________

text box

Every element on a form is called a/an __________

control

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

selection

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

Right-dragging

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

copy

The Report Header section prints __________.

at the top of the first page

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 __________.

ruler

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

upper-left

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

report view

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

text

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

margin

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

combo box

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

layout

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

orphan

Which of the following is NOT a form view?

data

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

all of the above

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

subtotal

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

Scrubbging the database.

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

infinity

Which arithmetic operator signifies exponentiation?

/\

What is the purpose of enforcing referential integrity?

To prevent orphan records from being created

The query datasheet can best be described as a __________

Logical view of the selected data from underlying tables.

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

Input Mask

The query datasheet can best be described as a __________.

Logical view of the selected data from underlying tables.

What is the purpose of enforcing referential integrity?

To prevent orphan records from being created

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

Required

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

.accdb

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

The updated data is automatically displayed in the query.

Which of the following is not true about field properties?

They are the same for each data type.

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

asterisk (*)

A crosstab query is generally constructed with how many fields?

3

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

There is duplicated data in several records of a table.

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

PMT

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

shift

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?

summary report

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

Options group

Which of the following form sections often contains command buttons?

Form Header

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

Group & Sort button

Which section most often contains calculations for groups of records?

Group Footer

Which control would you use to combine two reports?

Subreport

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

Themes

Which is a popular layout for a subform?

datasheet

Which is a popular layout for a main form?

Columnar

Which control would you use to initiate a print action?

Command button

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

record source

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

line

Which control is most commonly used within an option group?

option button

To align controls on their left edges, first _________________.

Select the controls whose edges you want to align.

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

Format Painter

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

[square brackets]

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

combo box

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

tab control

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

row source

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

They represent two different conditions.

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

PDF

Which type of template creates a traditional Access database?

desktop database

First normal form can be described as __________

a single two-dimensional table with rows and columns

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

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

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

many-to-many

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

picture

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

Calculated fields are removed from tables

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

lastname

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

all of the above

A multifield primary key consists of __________.

two or more fields

Which of the following is not true about database templates?

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

Which is not true about enforcing referential integrity?

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

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

word

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

many-to-many

Which of the following is not true about linking?

Linking copies data from one data file to another.

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

EXTERNAL DATA tab

Which of the following is not true about exporting

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

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

left

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

Parameter query

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.

Domain function

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

inner join

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

>=[Type minimum value here:]

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

Only those with matching values in both tables.

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

update

This type of query makes changes to data.

action query

Which of the following is not an action query?

union query

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

top values

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

inner join

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

update

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

page setup

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

Group Header section