BA-250 FINAL

Pataasin ang iyong marka sa homework at exams ngayon gamit ang Quizwiz!

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 .&nbsp;&nbsp;She will use the StudentInformation and TuitionPaid tables to create the query .&nbsp.&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


Kaugnay na mga set ng pag-aaral

Familia Protocolos TCP/IP Unidad 11

View Set

431 Book Part 2 Single-Letter Consonants

View Set

Chapter 11 Environmental Science

View Set

PrepU Chapter 15: Management of Patients with Oncologic Disorders

View Set

CHAPTER 3 - OPTION VOLATILITY STRATEGIES

View Set

psych prep u chp 5 therapeutic relationships

View Set