This operator is used in query construction when several criteria must be met to produce results in the query.
What is the And operator?
100
This toolbar is customizable with several general commands, such as Print Preview, Save, and Open, and is located at the top left of the Access Window.
What is the Quick Access Toolbar?
100
This object is where all information is primarily saved in Access. This type of object is a common element in other Microsoft Office 2007 software.
What is a table?
100
Clicking on a field name in a table or query, and specifying a reclassification of the information according to ascending or descending order, is referred to as ____________.
What is sorting?
100
This keyboard shortcut is used to save changes made to the design of Access objects (use of this shortcut after making changes avoids redundant dialogue boxes from appearing, prior to closing the object).
What is the CTRL + S shortcut?
200
This operator is in the form of a word, and prompts Access to locate information based on criteria from a certain point, to a certain point.
(E.g.: _________ 50 and 325 - looking for the middle values)
What is the Between operator?
200
When in a table, the field description appears in this toolbar, located at the bottom of the Access window.
What is the Status Bar?
200
This object is made when a user asks a question about the data stored in a database.
What is a query?
200
Tables can be constructed in ___________ view or in Design view.
What is Datasheet view?
200
This key launches the Access Help menu.
What is the F1 key?
300
This operator is used to expand query results by placing various criteria in two different rows in the Design Grid.
What is the Or operator?
300
This toolbar spans the top of the Access window, and houses all commands related to creating new Access objects, formatting current objects, and importing data into the database. It is separated into a series of tabs that group commands together by their functions.
What is the Ribbon?
300
This object is used to enter, edit, and view records in a database.
What is a form?
300
This is a step-by-step process that enables a user to construct a form, report, or query. Options to follow these step-by-step guides to construct Access objects are accessible in the Ribbon.
What are Wizards?
300
This key enables the user to switch between navigation mode and editing mode.
What is the F2 key?
400
This operator is specified by entering the " < " symbol. (The instructor often confuses this one with the symbol pointed the other way...)
What is the Less Than operator?
400
This pane at the left of the Access window lists the contents of the database. Double-clicking on an object from this section of the window opens the object for you.
What is the Navigation Pane?
400
This object is a formatted printout (or screen display) of the contents of one or more tables in a database.
What is a report?
400
Text, Number, and Date/Time are all examples of this, which is specified when constructing a table. (This will also restrict the sort of information that can be entered as a field value in the database object.)
What is a Data Type?
400
This key enables fast movement between the Table Design grid and the Field Properties pane below in Table Design view.
What is the F6 key?
500
Examples of these types of functions are SUM, AVERAGE, COUNT, MIN, and MAX.
What are aggregate functions?
500
This button, located at the top left of the Access window, resembles the MS Office logo, and houses general commands such as New, Save, Open, Properties, and close.
What is the Office Button?
500
Access is an example of this type of software, typically abbreviated as DBMS
What is a relational database management system?
500
This checkbox, found in the Design Grid in a query, enables a user to specify what fields to present in a run query.
What is the Show checkbox?
500
This keyboard shortcut, when working with a table in Datasheet View, enables a user to copy the above field value into a new record.