BA-250 FINAL
The _______ is located to the right of the navigation buttons and is used to locate a specific record in a form A.) Record Number B.) Search Box C.) Find Box D.) Locate Box
B.) Search Box
Changing the order of fields in a database table is an example of changing a table's ______. A.) Purpose B.) Structure C.) Data D.) Value
B.) Structure
To resize an image without changing its proportions, simply drag _______ of the image. A.) The left side B.) The Top C.) Any Corner D.) The bottom
C.) Any corner
To begin importing data from an Excel spreadsheet, click on the _____ tab on the ribbon. A.) Create B.) Database Tools C.) External Data D.) Home
C.) External Data
Data in a form created from the primary table is contained in ________. A.) Subform B.) Subdatasheet C.) Main datasheet D.) Main Form
D.) Main Form
A criterion may be negated by using the ____ logical operator. A.) And B.) Or C.) Like D.) Not
D.) Not
A single characteristic or attribute of a person, place, object, event, or idea is a(n) table
Field
Which of the following examples shows an input mask for a telephone number with the first three digits optional and dashed separating the parts of the telephone number? A.) 999/-000/-0000 B.) 999-000-9999 C.) 999/000/000 D.) 000/-999/-9999
a.) 999/-000/-0000
Clicking on the close option from the backstage view in Access 2013 performs which of the following tasks? A.) Closes the current database B.) Closes the current database and exits Access 2013 c.) Closes only the current database object D.) Copies the current database and exits Access 2013
A.) Closes the current database
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. A.) Format B.) Modify C.) Design D.) Page Setup
A.) Format
________ is the default entry for each field in the total row of the query design grid. A.) Group By B.) SUM C.) Totals D.) Maximum
A.) Group By
The _____ command removes the display of one or more fields in Datasheet view A.) Hide Field B.) Unhide Fields C.) Remove Fields D.) Display Fields
A.) Hide Fields
A calculated field is formatted using the ______ for the field. A.) Property Sheet B.) Criteria C.) Expression Builder D.) Operator
A.) Property Sheet
Which data type allows field values to contain letters, digits, and other characters? A.) Short Text B.) AutoNumber C.) Currency D.) Date/Time
A.) Short Text
Changes made to a field in a query data sheet updates the same field in the table on which the query is based A.) True B.) False
A.) True
Layout view shows both the form and its data while allowing the form to be modified. A.) True B.) False
A.) True
Logical operators must be used in order to combine two or more conditions in a query A.) True B.) False
A.) True
Which of the following is an example of a parameter query prompt criterion? A.) [Type the State:] B.) Prompt: "Type the state:" C.) *Type the state:* D.) {Type the state:}
A.) [Type the State:]
A criterion, or rule, that determines which records are selected when a query is run is called a(n) _________. A.) Sort Order B.) Condition C.) Operator D.) Match
B.) Condition
Which query wizard allows the user to choose the field that will be calculated for each row and column intersection? A.) Find Duplicates Query Wizard B.) Crosstab Query Wizard C.) Simple Query Wizard D.) Find Unmatched Query Wizard
B.) Crosstab Query Wizard
Click the { < } button moves all fields from the Available Fields box to the selected fields box using the Report Wizard. A.) True B.) False
B.) False
Field names in a table may only be changed in Design view. A.) True B.) False
B.) False
The Registrar at Ravenswood College would like to create a query which displays all student who have not yet registered for fall semester classes . She will use the StudentInformation and TuitionPaid tables to create the query . .&nsbp; Which type of query will most likely create the desired results? A.) Crosstab B.) Find Unmatched Query C.) Simple Query D.) Find Duplicates Query
B.) Find Unmatched Query
A relationship between Access tables that is a relationship between one record in the first table and zero, one, or many records in the second table, and at least one record in the second table matches at most one record in the first table, is defined as a(n) _________ relationship. A.) One-to-One b.) One-to-Many C.) One-to-most D.) Many-to-one
B.) One-to-many
Data may be sorted in a table datasheet, a form and a _________. A.) Report B.) Query Datasheet C.) Record D.) Related Table
B.) Query Datasheet
Which view must be used to delete an entire record? A.) Design B.) Query C.) Navigation D.) Datasheet
D.) Datasheet
Which type of query would show results indicating two different student ID numbers have been assigned to the same student? A.) Simple Query B.) Find Unmatched Query C.) Find Duplicates Query D.) Crosstab Query
C.) Find Duplicates Query
Which comparison operator defines a condition with a list of two or more values for a field and includes records when the field matches one value from the list in the query results? A.) LIKE B.) BETWEEN C.) IN D.) OR
C.) IN
The common field between two tables in the relationship window is indicated by a(n) ____. A.) Key Icon B.) Field Name C.) Join Line D.) Infinity Symbol
C.) Join Line
It is a good idea ________ the database before using compact and repair to keep the database safe from A.) Use a second computer to save B.) Run a virus check on C.) Make a backup copy D.) Proofread
C.) Make a backup copy of
Which Access database object asks a question about the data stored in a database and displays specific fields and records that answer the question? A.) Form B.) Table C.) Query D.) Report
C.) Query
Which access database object is best to use for the basis of a report when specific criteria must be applied to the report? A.) Table B.) Form C.) Query D.) Subdatasheet
C.) Query
The expression builder dialog box is available from which group on the Query DESIGN tab on the Ribbon? A.) Query Type B.) SHOW/HIDE C.) Query setup D.) Results
C.) Query Setup
Which button is used to open and close the Navigation Pane? A.) navigation bar B.) Record c.) Shutter Bar Open/ Close D.) Table View
C.) SHUTTER BAR OPEN/CLOSE
Which Access 2013 view contains commands used to manage Access files and options? A.)Datasheet View B.)Design View C.)Backstage View D.)Form View
C.)Backstage View
Which term identifies a field that appears in two separate tables and may be used to connect records in the separate tables? A.) Primary Key Field B.) Field Value C.) Foreign Key Field D.) Common Field
D.) Common Field
By choosing the Definition Only option in the Import Objects dialog box, the ___ of a table is imported, but not the _____. A.) Data, structure B.) Data type, structure C.) Structure, data D.) Structure, data type
D.) Structure, Data Type
Which two keys on the keyboard allow an Access user to move the insertion point to the next field to the right in datasheet view when entering data? A.) Tab, Insert B.) Enter, PgDn C.) Insert, PgUp D.) Tab, Enter
D.) Tab, Enter
The appearance of fields in a report that is created using the Report Wizard is determined by _____> A.) The order of the fields in the table being used for the report. B.) The data type of each field in the table C.) The size of each field in the table D.) The order the fields are selected in the Report Wizard
D.) The order the fields are selected in the ReportWizard
A table's contents are show in rows and columns when using the ___ view.
Datasheet
__________ view allows the database designer to enter both the field names and define the field properties.
Design
______ Values are never allowed by ACCESS in the primary key field
Duplicate
Arithmetic operations are performed on selected records in a database using Statistical functions.
False
When using the copy/past method to copy records from one table to another table, the two tables must have the same fields, design, and order, know as the table
Structure
Design changes cannot be made to a form in form view.
True
The Data Type Gallery, which allows the entry of groups of fields using the Quick Start selection, is only available in datasheet view (T/F)
True
The field name displayed in database objects, including forms and reports, is determined by the caption property (T/F)
tRUE
