AL1 C5 C6 Flashcards
When navigating in a form, press _____ to display the last record.
Ctrl + End
For a split form, the top half of the work area displays the form in _____ view while the bottom half displays the form in _____ view.
Layout; Datasheet
What happens when you click the Date and Time button in the Header/Footer group on the Form Layout Tools Design tab?
The Date and Time dialog box displays.
To display buttons and options for applying formatting to a form, click the
Form Layout Tools Format tab
When Access creates a form from a table, the cells in the first column in the Detail section of the form contain
the label control objects
What are the two components of an Access theme?
a color theme and a font theme
Create a form using the Form button in the _____ group on the _____ tab.
Forms; Create
Use the _____ feature to apply formatting to data that meets a specific criterion.
conditional formatting
Clicking the Ascending button in the Sort & Filter group on the Home tab will sort data in a form as follows:
text in alphabetic order from A to Z, numbers from lowest to highest, and dates from earliest to latest.
What is the keyboard shortcut to display the Field List task pane?
Alt + F8
The default sort order at the third Report Wizard dialog box is
ascending
To create a report with the Report button, begin by
clicking the table or query in the Navigation pane that will be the source of the report data.
When fields are specified for the mailing label at the third Label Wizard dialog box, the fields are
moved to the Prototype label box.
What two list boxes appear in the first Report Wizard dialog box?
Available Fields and Selected Fields
Which of the following is not one of the steps in creating a report using the Report Wizard?
Click the table or query that will be the source of the report in the Navigation pane.
At the second Report Wizard dialog box, the up- and down-pointing arrows are used to
change the priority of the selected field.
Which of the following is not one of the four views available for Access reports?
Datasheet
Find specific data in a report with options
at the Find dialog box.
What is the purpose of grouping data in a report?
to make the report easy to understand
Reports are generally designed
to answer specific questions.
To add an existing field to a form, display the form in _____ view and then click the Add Existing Fields button.
Layout
Forms can be created using several methods but not by using the _____ button.
View
A form is useful for focusing on
a single record at a time.
When Access creates a form from a table, what does the second column of cells contain?
field values in text box control objects
Which of the following correctly states how you can enter text in Layout view?
You can enter data in a label control object but not in a text box control object.
When you open a form in _____ view, the Form Layout Tools Design tab is active.
Layout
When a form is created with a table that has a one-to-many relationship with another table, what does Access do?
It adds a datasheet to the form that is based on
What happens when you click the Date and Time button in the Header/Footer group on the Form Layout Tools Design tab?
The Date and Time dialog box displays.
Clicking the Split Form option at the More Forms button drop-down list creates
two views of the same form.
Which two buttons appear at the bottom of the Group, Sort, and Total pane?
Add a group and Add a sort
When a grouping level is added to a report, Access
automatically sorts that level in ascending order.
Options for inserting and selecting rows, splitting cells, moving data up and down, and controlling margins are available on the Report Layout Tools ribbon with the _____ tab selected.
Arrange
Which of the following is not one of the options in the Text appearance section of the second Label Wizard dialog box?
Text direction
To change the width of a control object in a report by dragging, begin by positioning the mouse pointer _____ of the object.
on a left or right border
The Report, Report Wizard, and Labels buttons are all located on the _____ tab.
Create
The options on the Report Layout Tools Format tab are the same as those on the _____ tab.
Form Layout Tools Format
When creating a report using the Report Wizard, the first piece of information you must supply is
the name of the table or query that contains the data.
If you insert a check mark in the Print Data Only check box in the Page Size group, the _____ will not print on the report.
report title and column headings
To print a specific record in a form, begin by selecting the record and then
displaying the Print dialog box.
If a form is created based on a table that has multiple one-to-many relationships, what will Access do?
It will not display any datasheets based on the related tables.
How do you select all the objects in the Detail section of a form but not in the Form Header section?
Click an object in the Detail section and then click the table move handle.
The Header/Footer group on the Form Layout Tools Design tab contains buttons for inserting each of the following except
a watermark
If you delete a form from your computer’s hard drive, can the form be retrieved? If so, how?
Yes, the form can be retrieved from the Recycle Bin.
Access offers a Form Wizard that provides _____ for creating a form.
steps
To change the width of a control object by dragging, select the object and then _____ the object until the pointer displays as a left-and-right-pointing arrow.
position the mouse pointer on the left or right border of
What happens when you position the mouse pointer over a theme at the Themes button drop-down gallery?
The live preview feature displays the form with the theme formatting applied.
When navigating in a form, pressing the Page Down key will move
forward one record.
When the Report Wizard is used to create a report with fields from more than one table, how is the process different from when the wizard is used to create a report from only one table?
A sixth Report Wizard dialog box presents options.
Use _____ to display an Access report as it will appear when printed.
Print Preview
Which of the following text appearance options cannot be changed at the second Label Wizard dialog box?
superscript
What is the main reason for creating a report in a database?
to control what data appears on the page when printed
Click the _____ button in the Sort & Filter group on the Home tab to sort text in alphabetical order from Z to A.
Descending
What do you specify at the last Label Wizard dialog box?
a name for the label report
Can a report be created from a query? If so, how?
Yes, in the same manner as creating a report from a table.
When a control object in a report is selected, it displays with a(n) _____ border.
orange
When a form is created with a table that has a one-to-many relationship, where does Access place the datasheet for the related table?
at the bottom of the form
Delete a form by clicking the Delete button in the _____ group on the _____ tab.
Records; Home
What will print when you click the Quick Print option?
all the records in a form
By default, the _____ button in the Controls group on the Form Layout Tools Design tab is active.
Select
A form is made up of cells arranged in rows and columns, and each cell can contain one
control object
A _____ is an object used to enter and edit data in a table or query.
form
Each cell in a form can contain _____ control object(s).
one
To view and modify the structure of a form, use the _____ view.
Design
The themes available in Access are _____ the themes available in Word, Excel, and PowerPoint.
the same as
Use the _____ view to enter and manage records in a form.
Form
Which of the following is not one of the layout options available at the second Form Wizard dialog box?
Split
A report created with the Report button is displayed in _____ view.
Layout
At the second Report Wizard dialog box, remove an option as a grouping level by selecting a specific field and then clicking the button with the _____-pointing arrow.
left
In creating a report using the Report Wizard, which of the following steps is performed at the final dialog box?
Type a name for the report.
What are the two options in the Label Type section of the first Label Wizard dialog box?
Sheet feed and Continuous
Use the _____ button to increase or decrease spacing between cells.
Control Padding
To select a row of cells in a form, _____ a cell and then click Select Entire Row at the shortcut menu.
right-click in
When viewing a report in Print Preview, you can change the margins with the Margins button located in the _____ group.
Page Size
What information are you asked to supply at the first Label Wizard dialog box?
the label size, type, and unit of measure
Which of the following is not an option in the Layout section of the fourth Report Wizard dialog box?
Continuous
When moving a column in a report by dragging, the mouse pointer should display with a(n) _____ attached.
four-headed arrow
When a form is created using the Form button, it will open in _____ view.
Layout
When you split a cell, a(n) _____ is created to the right of the control object.
empty cell
The Record navigation bar displays when a form is open in which view(s)?
Form or Layout view
How is a form created with the Multiple Items option from the More Forms button different from a form created with the Form button?
It displays multiple records.
The Report Wizard is on the _____ tab.
Create
To sort data in a report, you should first
click in the field containing the data to be sorted.
To add a new record to a form, click the New (blank) record button, which is
on the Record Navigation bar.
Where are the Ascending and Descending buttons?
in the Sort & Filter group on the Home tab
You can use options in the Font group to do each of the following except
insert a background image.
What happens when you click the Group & Sort button in the Grouping & Totals group on the Report Layout Tools Design tab?
The Group, Sort, and Total pane displays at the bottom of the work area.
At the fourth Report Wizard dialog box, the default settings specify that the report will be printed in
portrait orientation with field widths adjusted so all the fields fit on a page.
Use the _____ button in the Grouping & Totals group to perform calculations, such as finding the sum, average, maximum value, or minimum value of the numbers in a column.
Totals
Use the _____ to insert fields from a table or query to a form.
Field List task pane
When inserting a text box control object in a form, what do you do after clicking the Text Box button?
Click in the location in the form where the object should display.
The Conditional Formatting button is in the _____ group on the _____ tab.
Control Formatting; Form Layout Tools Format
Select all the control objects in a report by pressing Ctrl +
A
Which of the following is not one of the steps in creating a report?
Click the Report Design button.
When you create a split form, the two views are considered _____ because movements or changes made in one view will be reflected in the other view.
synchronous
The control objects in the Detail section of a form in Layout view are contained in cells within
the form table.
With your report in Layout view and no grouping levels added, what happens when you click the Add a sort button in the Group, Sort, and Total pane?
A sorting row is added to the pane and a list of available fields is displayed.
The buttons on the Report Layout Tools Page Setup tab are also available
in Print Preview.
How do you delete a grouping or sorting level in the Group, Sort, and Total pane?
Click the Delete button at the right side of the level row.
Display a report in Print Preview by clicking the Print Preview button
(?)
NOT in the Title bar.
