Results of a query may be viewed at any time by clicking the ____ button in the Results group on the Ribbon. |
run |
The query type that gives Access an example of the information being requested and retrieves information based precisely on matching the example is which type of query? |
query by example |
The process of adding, modifying and deleting records in a database to keep the records current and accurate is referred to as ____ a database. |
maintaining |
Which record modification mode is used to insert or delete characters in a field value based on the location of the insertion point? |
editing mode |
The ____ command removes the display of one or more fields in Datasheet view. |
remove fields |
Which view must be used to delete an entire record? |
datasheet |
Queries based on more than one table, must have a ____ field. |
common |
When the sort field data for each record in a database is different, the sort field is ____. |
unique |
The AutoFilter sort method works on a(n)____ field(s). |
mulitply |
A criterion, or rule, that determines which records are selected when a query is run is called a(n) ____. |
sort order |
The comparison operator, < >, is used to insert a condition that means ____. |
not equal to |
In the criterion, <=250, the operator will return values for the specified field that are ____. |
less than 250 |
The condition "Seattle" for the field City in a student database is an example of what type of value? |
critera value |
To use an existing query as the basis for a new query, it is necessary to ____ the query before designing the new query. |
include comparison operators |
A combination of database fields, constants, and operators that are used to perform a calculation is called a(n) ____. |
builder |
The Expression Builder dialog box is available from which group on the Query DESIGN tab on the Ribbon? |
query setup |
Which aggregate function supports the Yes/No field data type? |
count |
____ is the default entry for each field in the Total row of the query design grid. |
totals |
Statistical information such as totals and averages is calculated using ____. |
math operators |
Jorge has created a database for the herb garden he is planting this spring. Fields in the database include: Plant Name, When to Plant, Amount of Sun, Annual, and Perennial. He needs to answer the following questions using his database.Which plants need full sun?Which plants are Perennials? When creating a query to determine which plants need full sun, which fields must be included in the query? |
amount of sun and went to plant |
Jorge has created a database for the herb garden he is planting this spring. Fields in the database include: Plant Name, When to Plant, Amount of Sun, Annual, and Perennial. He needs to answer the following questions using his database.Which plants need full sun?Which plants are Perennials? After creating the query, Jorge must set criteria to have the query return only those plants that need full sun. Entries for the Amount of Sun field include: partial sun, little sun, and full sun. How should Jorge enter the criteria for the exact match of full sun? |
<=fullsun |
orge has created a database for the herb garden he is planting this spring. Fields in the database include: Plant Name, When to Plant, Amount of Sun, Annual, and Perennial. He needs to answer the following questions using his database.Which plants need full sun?Which plants are Perennials? To create a datasheet that lists all herbs that are Perennials, Jorge will create a new query. The Perennial field has a data type of Yes/No. Which criterion should Jorge use in the query for the Perennial field? |
‘yes’ |
Data in a form may only be modified in ____ view. ( |
datasheet |
A ____ is a placeholder used in a search when the search should start or end with a specific character or match a particular pattern. |
desing box |
Which of the following may be used as a wildcard character when searching for a value in Access? |
# |
A form created from two tables that have a ____ relationship creates a main form and a subform. |
one to one |
Options for modifying the format of report objects are found on the ____ tab in Layout view when the contextual REPORT LAYOUT TOOLS tab is available. |
modify |
Formatting used in a report that is applied to certain field values depending on the conditions set for the values is ____ formatting. |
criteria |
The appearance of fields in a report that is created using the Report Wizard is determined by ____. |
the order of the fields inthe table being used for the report |
Before applying a conditional format in a report, the ____ box must be selected. |
field value |
To select both a field label and field value to move in a report design, after selecting the field label press the ____ key to select the field value box. ( |
ctl |
Which of the following methods should be used in report Layout view to edit a field caption object that is not fully displayed? |
change caption |
____ is one of the options available from the Page Layout group on the PRINT PREVIEW tab when previewing how a report will print. |
change page orientation |
A ____ is a set of field values for a record that is found in a table related to the primary table on which a report is based. |
primary record |
To print two records from a form, select the ____ option in the Print dialog box. |
range |
Data in a form created from the primary table is contained in the ____. |
subform |
It is often easier to maintain data in a datasheet using a form because all changes for a ____ are the focus at one time. |
Datasheet Layout |
Which of the following characters represents the wildcard character that matches any one of a range of characters in ascending order? |
# |
A wildcard character used as the first and/or the last character in a character string to match any number of characters is the ____ character. |
# |
A form must be displayed in ____________________ view to navigate, view, and edit data. |
Design |
Access
Share This
Unfinished tasks keep piling up?
Let us complete them for you. Quickly and professionally.
Check Price