Access Ch 5-8 Multiple Choice
Which of the following is NOT used when laying out forms and reports?
Changing the Allow Edits property to No
A ___ is a set of constraints or rules that help control how data is entered into a field
Data Validation
Which of the following is NOT a rule for appending queries?
Data field types do not have to be the same
Which data validation method enables you to execute programming tasks whenever data in a table is changed?
Data macro
___ is similar to a validation rule except the logic is more complex and the actions taken are more powerful when table data is changed
Data macro
An access function that examines a date and returns a portion of the date is
DatePart function
Assuming hire date of 7/31/2016, which of the following would be the correct DatePart Function for the correct day of the week?
DatePart("w",[HireDate])
Assuming a hire date of February 15, 2017, which of the following data part functions would return the number of days since the beginning of the current year?
DatePart("yyyy",[HireDate])
Which data validation property specifies a value that is automatically entered into a field?
Default Value
A ___ helps to reduce editing time when there is a common value in a field
Default value
What do you do if you make a mistake when running a Find Unmatched query?
Delete the query and start over, then reverse the order of the tables
Which view do you use to modify lines or rectangles?
Design View
Which view gives a designer a higher level of control when creating forms and/or reports?
Design View
Where would you go to change tab order in a form?
Design view - Tab order in Tools group
Which sections display on forms and reports by default?
Detail and form/report header and footer
Which query identifies multiple instances of the same information in a table?
Find duplicates
What appears below the Page Footer section in a report or form?
Form Footer or Report Footer
Which of the following appears at the top/bottom of each form or report?
Form or Report Header/Footer
Which of the following appears once at the top/bottom of each page in a form or report?
Form or Report Header/Footer
___ affects the display of the date without affecting the underlying value
Formatting
To test an update query before running the query, what should you do first?
From Design view, click View in the Results group and click Datasheet view
How would you add grouping to a report?
Group & Sort button
The ___ appears after adding a grouping to a form or report
Group Header
The ___ function an expression and displays one value when the expression is true and another when the expression is false.
IIF
Which data validation method forces users to conform to a specific data-entry format for a given field?
Input Mask
Which of the following forces you to enter the phone number in a consistent manner in the database table?
Input mask
Which of the following function checks to see if a field has no value?
IsNull
___ function checks to see if a field does not contain a value
IsNull
Which of the following file types increases the database size byte for byte when attached in access?
JPEG and other photo formats
Where does a Group Footer appear?
Just below the Detail section
A ___ describes the data associated with a text box
Label control
Which of the following displays when you insert a text box?
Label control
Which two views make it easy to edit the design of a form?
Layout view and Design view
When you use the ___ operator, each criterion must be true for the compound criterion to be true
Like
What are two options for adding emphasis to your form or report?
Line or rectangle control
Which type of query automatically creates a new table from data that already exists in a database?
Make Table
What is the default software application associated with a CSV file?
Microsoft Excel
When two functions are not sufficient to evaluate an expression, you may need to use a
Nested Function
___ functions refers to using one formula within another one.
Nesting
How often does a Form/Report Header appear?
Once
The ___ file format was created by Adobe Systems for document exchange independent of software application and operating system environment
The ____ file format does not allow you to edit the exported documents
___ documents cannot be edited after being exported
PDF or XPS
What type of break is used to cause each group to print on a separate page?
Page
How is an attachment field identified in a table?
Paperclip
Before running a delete query, what should you do?
Preview the data sheet to verify that the records are those that you intend to delete
Before running a make table query, what should you do?
Preview the data sheet to verify that the records are those that you intend to insert into the table
What type of file does access create when exporting to word?
RTF
___ is a useful format for basic formatted text documents such as instruction manuals, resumes, letters, and other docs
RTF
Which of the following displays one time at the bottom of a report?
Report footer
Which data validation method forces data entry into a field?
Required
How do you switch on or off sections of a report or form?
Right click a blank area
___ is the correct syntax for the Round function
Round(expression, precision)
___ is the first method for controlling data input in a field of a table
Selecting an appropriate data type
What must you do once a text box has been converted to a combo box?
Set a source for the combo box
The objects you select to export from Access to Word should have which of the following types of layout?
Tabular
After adding grouping, a ___ appears just above the Detail section in Design view, along with the name of the field by which you are grouping
group header
A ___ enables you to quickly link to any file on your computer or to any Web page on the internet
hyperlink
A ___ forces users to conform to a specific data entry format for a given field
input mask
What is the purpose of a ScreenTip?
it displays when you point your mouse over the hyperlink text
A ___ is text not tied to a specific field
label
Which of the following controls can you use to add emphasis to your form or report?
line control and rectangle control
___ allows you to connect to a table without having to import the table data into your database
linking
A field with a number of repeated values may be better suited as what kind of field?
lookup field
The data validation method that causes fields to be limited to predefined list of values is a
lookup list
The ___ creates a menu of finite values by asking you questions and using your answers to create the options list
lookup wizard
Before linking to a spreadsheet, you must first
make sure the data is organized
A ___ query can be use to archive older records that need to be stored outside of the current table
make table
A ____ accepts two or more options in a lookup field.
multiple-value field
Before exporting a table to another database, what must be done first?
A database must be created
Which fields in a table are required fields by definition?
A field with a primary key
Why should you backup your database before running an action query?
Action queries are irreversible
Why should you backup your database before testing an action query?
Action queries change data in your database that cannot be reversed
Which of the following is an alternative to a comber box?
Add a data validation rule
To avoid a mistake when using an update query that includes making calculations on a field, what is one thing you can do to prevent losing the original information?
Add an additional field with the original figures
A ___ performs calculations on an entire column of data and returns a single value
Aggregate function
Sum, Min, Max, and Average are examples or which kind of functions?
Aggregate functions
Where do the row headings display in a cross tab query?
Along the left side of a cross tab query
Where do the column headings display in a cross tab query?
Along the top of a cross tab query
A ___ is a form that enables users to view but not change data
read-only form
A ____ sets the property of a field to force data entry
required
A field that cannot be left blank when you create a new record is a
required field
Which of the following marks the top boundary of a section in a form or report?
section bar
To test an update query before running it, you can
switch to datasheet view
The ___ is the sequential advancing in a form from one field to the next
tab order
___ are common methods of exchanging information between two computer systems
text files
What happens when you export a form with a subform to excel?
the form exports but the subform does not
When running an append query, what happens if a record violates the primary key rule for the destination table?
the record is rejected
What happens to the size of an access database when a table is linked to an excel spreadsheet?
the size of the database remains the same
Which of the following generally refers to decorative elements such as the title or a report?
unbound control
A ___ query is used to update or change data automatically based on criteria that you specify
update
A ___ can be used when records with missing data have been found
update query
A ___ would be used to replace null values with zeros?
update query
A ___ rule limits the type of data a user can enter into a field
validation
What is the main reason for exporting data to excel instead of word?
you are not able to analyze the data as you can in excel
What is one reason to import an Excel worksheet into access instead of linking it?
you have more control over the imported data
___ uses a comma to separate one column from the next, enabling the receiving software to distinguish one set of field values from the next
CSV text files
Which of the following fields is an example of a field that would not require a tab stop?
Calculated field
Calculated controls begin with a
equal sign (=)
What does access do when you link a table to another access database?
creates a new table called a linked table
A ___ query removes from a table based on criteria that you specify
delete
Duplicate values in a table can prevent you from
enforcing referential integrity
What do you do if you only want to export part of a table to excel?
filter the table first
___ allocate a certain number of characters for each field
fixed-length text files
Moving records from one table to another can be accomplished with the combination of what two types of queries?
Append and delete
The process of creating a make table query is very similar to which other typer of query?
Append query
Where is the Group Header located?
At the start of each new group
Which of the following fields enables you to add multiple files of different types of a table?
Attachment
What should be the first step taken before creating an update query?
Back up the database
After becoming familiar with the data in a database, what should be the first step when creating an action query?
Backup the database
What differentiates a hyperlink from text?
Blue underline
When creating a parameter query, the text phrase should be enclosed in which of the following?
Brackets [ ]
How do you hide details in a report?
Click Hide details in the Grouping & Totals group on the Design tab
To move a text box label, what action must you take?
Click the Tabular Layout in the Table group of the Arrange tab while both the label and text box controls are selected.
On a form, what type of control provides a drop-down menu displaying a list of options from which the user can choose a single value?
Combo box
Which type of control does a lookup field become in a form?
Combo box control
What should be done before converting a text box to a combo box?
Create a new table and enter the values for the option list
What is the first step in creating an append query?
Create a select query
What summarizes a data source into a grid of rows and columns?
Crosstab query
Which type of query calculates data using a sum, average, or other function and groups the results by two sets of values?
Crosstab query
Which of the following enables you to create mathematical functions in Access?
Expression builder
When exporting to a PDF, what should you check for when the objects are exported?
The number of pages
If you run a make table query again at a later time, what happens?
The table is replaced with the new up-to-date table
What is the purpose of a find unmatched query?
To compare records in two related tables and display the records found in one table and not the other
Where is the Page Header located?
Top of each page
What is the group footer used for?
Totaling the data at the end of each group
What must be present for a find unmatched query to work?
Two tables share a common field
A ___ is the location of a web site or web page on the internet
URL
Which of the following controls contains to decorative elements, such as the title of the report?
Unbound
Once records with missing data are found, what type of query can you use to add the needed information?
Update
What is the reason for making a form read-only?
Users can lookup information but not modify the data
What data validation method is designed to restrict the data values entered into a field?
Validation Rule
Which data validation method provides an error message when a validation rule has been broken?
Validation Text
When would a calculated field need to be added to a form or report?
When a formula is needed in the form or report
When are subforms created?
When the main form displays records from a related table
What does the type of data displayed in a cross tab query depend on?
Which aggregate function used when the query was created
When you double click on a document with a RTF file extension, which of the following programs does Windows open by default?
Word
What type of files are compressed by access when you attach them?
Word and excel files
The ___ file format is considered an alternative to PDF
XPS
How is a cross tab query different from other queries?
You can only reference one object (table or query) as the data source
Which application allows you to view XPS documents if the XPS viewer has not been installed?
Your browser
What happens when you double click an attachment in a table?
a dialog box opens with options
What happens each time you open an attachment file in access?
access creates a temporary file on your computers hard drive
What happens when you click a hyperlink field value while in Datasheet view?
access launches the program required to display the file or web page
Access is not able to ____ an attachment
analyze the data within
A ___ query can be used for adding records to an existing table
append
What can you do if a comparable table already exists when you import a spreadsheet?
append a copy of the excel records to the table
A ___ appears next to a linked table name in the Navigation Pane
arrow
In access, what is a reference to an external file called?
attachment
Which of the following allows you to manage attached files in forms and reports?
attachment control
A ___ is a control that is connected to a field in a table or query
bound control
A ___ contains an expression that generates a calculated result.
calculated control
How do you insert blank lines above a table after exporting it from access into word?
click immediately before the first value in the first cell of the table and press Enter to add an additional line
An append query is a query that
copies records from one table to another
Which of the following is NOT a correct way to add a calculated control to a form or report?
create a formula in a bound control
