Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
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? |
|
|
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 |