Exam 3: Multiple Choice

Lakukan tugas rumah & ujian kamu dengan baik sekarang menggunakan Quizwiz!

When using wildcards in validation rules, which of the following must surround the criteria of your expression?

" "

Which of the following field validation rules requires the user to fill in a field?

"Not Null"

Which of the following is a valid criterion for the Long Text data type?

"hello"

Which of the following is a valid criterion for the Short Text data type?

"hello"

Which of the following wildcard characters does Access use in validation rules to match any single numeric digit?

#

Which of the following wildcard characters matches any single numeric digit?

#

Which symbol must be used to specify criterion for the Date/Time data type?

#

Which of the following represents the correct order of operations?

(), ^, *, /, +, -

Which of the following record validation rules requires the user to enter a value into either Field1 or Field2, but not into both fields?

([Field1] is Null) XOR ([Field2] is Null)

Which of the following wildcard characters matches any number of characters?

*

How does Access store a Yes response for the Yes/No data type?

-1

How many criteria would you need in a query in order to find all the employees who work as insurance agents in the Cameron Park branch of a company who were hired after January 1, 2019?

3

How many parts are there in an input mask?

3

Which of the following is a valid criterion for the AutoNumber data type?

5

Which of the following is a valid criterion for the Currency data type?

5

Which of the following is a valid criterion for the Number data type?

5

Which symbol separates the two parts of a formula in a query field?

:

Which of the following characters separates the parts of an input mask?

;

Which of the following formatting symbols displays characters in lowercase in a short text and long text field?

<

Which of the following field validation rules prevents the user from typing 0 into a field?

<> 0

Which of the following criterion expressions searches for a State field that is equal to Ca?

="Ca"

Which of the following criterion expressions searches for a ShippingDate field that is greater than January 1, 2019?

>#1/1/19#

Which of the following wildcard characters matches any single character in a specific position?

?

Which of the following logical operators requires that a record meet all the individual conditions specified in order to be included in the results?

AND

Which of the following prints a table in a database?

Backstage view

Which of the following comparison operators means "Between these two values"?

Between

Which of the following criterion expressions searches for a YearsWorked field that is between 10 and 20?

Between 10 and 20

Which of the following number data types stores numbers from 0 to 255?

Byte

Which of the following properties contains the text that displays in the column header to identify a field in Datasheet view?

Caption property

Which of the following data integrity rules ensures that a field contains a value if it is required?

Completeness

Which of the following data integrity rules ensures that a value entered into a field is consistent with a value in another field?

Consistency

Which of the following functions counts the number of records that have a value in the field?

Count

Which of the following Ribbon tabs do you use to create a query?

Create

Which of the following keyboard shortcuts opens the Expression Builder dialog box?

Ctrl+F2

In what view do query results display?

Datasheet view

Which of the following is used to enter records into a table?

Datasheet view

Which of the following number data types stores numbers from -1028 to 1028 with a precision of 28 significant digits?

Decimal

Which of the following properties automatically inserts a specified value into a new record in a table?

Default Value property

Which of the following keyboard shortcuts opens the Save As dialog box?

F12

Which of the following opens the Save As dialog box?

F12

Which of the following keys opens or closes the Property Sheet?

F4

Which of the following properties controls the way a field displays in a table?

Format property

Which of the following comparison operators means "contained in this list of values"?

In

When entering an expression, which of the following tools may suggest a list of possible values?

IntelliSense

Which of the following is true about the Simple Query Wizard?

It doesn't enable you to take advantage of all the options available when creating a query

Which of the following functions finds a specific number of characters from the left of the field?

Left

Which of the following comparison operators means "similar to this value"?

Like

Which of the following criterion will search for songs that contain the word "love" somewhere in the middle of the song title?

Like "**love**"

Which of the following criterion expressions searches for PhoneNumber records where the phone number contains 10 characters and starts with a 9?

Like "9?????????"

Which of the following criterion will search for songs with the title of "Love for All Seasons", "Love This Pain", and "Love Will Find a Way"?

Like "love *"

Which of the following displays a list of data values from which the user can choose?

Lookup field

Which of the following logical operators requires a record to meet at least one of the individual conditions specified to be included in the results?

OR

Which of the following print options enables you to select different print options before sending the contents of the current object immediately to the printer?

Print

Which of the following print options enables you to check that formatting is appropriate and to make changes to any settings before printing?

Print Preview

Which of the following contains the fields which have been included in the query?

Query Design grid

Which of the following groups of commands includes buttons to insert and delete fields in the design grid?

Query Setup

What name does Access assign to new queries?

Query1

Which of the following print options bypasses the Print dialog box?

Quick Print

Which of the following print options sends the contents of the current object immediately to the printer?

Quick Print

Which of the following functions rounds a value?

Round

After you create a query in Design view, what do you need to do in order to see the results?

Run the query

Which of the following functions finds the total value of a field?

Sum

Which of the following is a true statement about foreign keys?

The foreign key field is always the primary key of another table

Which of the following is added to the design grid of a summary query?

Total row

Which of the following functions converts a value to uppercase?

UCase

Which of the following properties directs Access to display records that don't include duplicated values?

Unique Values

Which of the following symbols are used when defining a parameter query?

[ ]

Which of the following parameters is an example of the most user-friendly?

[Enter the Music Genre]

In the query design grid, what do you delete to delete a field from a query?

a column

Which of the following cannot be changed in Datasheet view of a query?

alignment

What is created when values are entered on the same Criteria row of the query design grid?

an AND condition

When structuring a criteria expression with a parameter that includes one or more wildcards, where can the wildcards be positioned?

any of the above

How many fields can you add to the query design grid?

as many as you like

Which of the following gets its value from a calculation instead of a value that is entered into the field?

calculated field

What is a primary key called that is made up of more than one field?

concatenated key

What is the name for hardcoded values entered into a formula?

constant

Which of the following should you add into a query to search for records that meet a specific value?

criterion

What determines the type of criterion you enter, along with the way you enter the criterion?

data type of the field

Which of the following refers to the process of verifying the accuracy, or integrity, of data?

data validation

What can you do if you create a relationship in error?

delete it

How does Access evaluate a criterion expression that just includes a criteria value?

equal to

In Access, what are field validation rules called?

expressions

What should you use to write criterion into a query?

expressions

In Access, which of the following is used to relate, or connect, tables?

field

Which of the following functions performs a comparison and does one of two alternatives?

iif

In Access, which of the following indicates the many sides of a relationship?

infinity symbol

Which of the following options forces a user to enter data using a specific format?

input mask

Which of the following must you do before adding a field between existing fields?

insert a new row

What is a table called that matches up the records across two tables?

junction table

Which of the following relationships describes many rows of data in Table A associated with many rows of data in Table B?

many-to-many

Which of the following relationships describes one row of data in Table A associated with many rows of data in Table B?

one-to-many

Which of the following relationships describes one row of data in Table A being associated with only one row of data in Table B?

one-to-one

Which of the following requires you to enter the specific criteria value when you run the query?

parameter query

Which of the following contains a unique value for each record?

primary key

Which of the following finds data in your database by enabling you to ask a question?

query

Which of the following ensures that records in associated tables have consistent data?

referential integrity

Which of the following is the most common type of query?

select query

Which of the following is used to locate data in a database?

select query

Which of the following display control options displays the contents of a field and enables the user to type a value into that field?

text box

You will most likely use the Zoom box or Expression Builder to enter a parameter query that contains wildcards due to the length of the expression.

true


Set pelajaran terkait

Clinicals 2 & Phlebotomy Study Guide

View Set

Chapter 8 Exam (health insurance NM state laws)

View Set

Introduction to Mastering Chemistry

View Set

Unit 4 APUSH Practice Multiple Choice Questions

View Set

MKF1120 Week 3 - Marketing Environment

View Set

Funeral Directing: Exam 3: Catholic Funeral Rite: MOODLE "Quiz"

View Set