A query is a database object that
retrieves specific data from one or more database tables or queries.
Before populating a table, which is the correct sequence of steps?
Create and name the database, save the database, create and name the table.
Good database design does NOT include
accessible coding so that users can alter the structure of the database.
Headers and footers for Microsoft Access tables and queries
are controlled by default settings and cannot be edited.
One purpose of a report is to
display the fields and records from a table in an easy-to-read format.
The advantage of using a template when starting a new database is that
database objects are already created.
The process of creating a query involves
choosing the table(s) and selecting the fields you want to include in the query result.
When data in a table becomes redundant,
it is usually an indication that you need a new table to contain information about the topic.
When importing data from an Excel workbook, you may NOT
append a copy of the records to an open, active table.
If you accidentally place two copies of the same table list in the Relationships window, which is the correct method for removing the extra table?
Right-click the table, and select Hide Table.
If you want the records in a table to be sorted by last name and then by first name within each last name, you would need to
sort Lastname as the outermost field in ascending order.
In a query, to sort Z to A by Department (outermost), then A to Z by Lastname (innermost),
Department would be to the left of Lastname in the query design grid.
Regarding the sorting of query results, which of the following is FALSE?
Only the sort order specified in Datasheet view is saved with the query design.
Sorting a table in descending order by a Last Name field would NOT
sort ONLY the Last Name field, thus mixing up the records.
To create a crosstab query based on two tables, you must
create a select query on which to base the crosstab query.
To find a contribution amount of $300 or greater, the entry in the Amount field's criteria should be
To locate records in which a field is left blank, what should be used as the criteria for that field?
When Baseball is placed on the Criteria row of the Sport field and Football is placed on the OR row for the same field, the only way to specify scholarship amounts greater than $400 for both sports is to
enter >400 on both the Criteria and OR rows in the field for the scholarship amount.
When establishing a relationship, common fields do NOT necessarily need to have
the same field name.
When looking for a date during the week beginning 8/2/2015 and ending 8/8/2015, which of the following would be the correct criteria?
Between 8/2/2015 and 8/8/2015
When searching for "Red" or "Rad" or "Rid" or "Rod", but NOT "Rodney" or "Reed" or "Ron", which of the following criteria should be used?
Which is the primary advantage of creating a new query based on an existing query?
It saves time if your new query uses the same fields as the existing query.
Which of the following expressions would correctly add a calculated field named Discount that is 20 percent of the Price field?
Which of the following is NOT a true statement regarding a select query?
A complex select query should be created using the Query Wizard.
Which of the following is NOT true regarding security alerts?
They can be resolved permanently by most college users in the Trust Center.
Compared to the Form tool, the Form Wizard
allows more flexibility in the layout and design of the form.
Form Layout view differs from Design view in that
only Form Layout view allows modifications while viewing data.
In Layout view, if the width of controls is insufficient to display all of the data, the field has been
In Layout view, the ________ is a small symbol displayed in the upper left corner used to move the entire group of controls.
The advantage of resizing controls in Layout view rather than in Design view is
by seeing the content of the fields in Layout view, you can visually determine that the space allotted is adequate.
To print just one record from a form, which of the following would you choose in the Print dialog box?
the Selected Record(s) option
Using the"keep whole group together on one page" command ensures
labels, data, and totals will all be on one page as long as the data doesn't exceed one page.
When a filter is active, which of the following is NOT true?
A small funnel appears to the right of the database name in the title bar.
Which of the following displays only records that contain the value in the selected field?
Filter by Selection