Access 1-4 Simnet

¡Supera tus tareas y exámenes ahora con Quizwiz!

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

"hello"

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

*

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

3

How many parts are there in an input mask?

3

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

5

What separates the two parts of a formula in a query field?

:

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

="Ca"

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

AND

To delete a record from a table, what must you do first?

Click in the Record Selector cell of the record.

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 functions are helpful in limiting the number of records that display in your datasheet?

Filter

When a new table is created in Datasheet view, what name is assigned to the field Access automatically includes?

ID

Which of the following number data types stores numbers from -32,768 to 32,767?

Integer

Which of the following input mask characters requires a user to enter a letter?

L

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 that contain the word "love" somewhere in the middle of the song title?

NOT Like "* love"

Which of the following is used to store data records?

NOT Query

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

NOT Quick Print

Which of the following is a true statement?

NOT You can undo deletions made to the layout of a datasheet.

Which of the following might be necessary in order to override the constraints imposed by enforcing referential integrity?

NOT control changes

Which of the following is not located on the Access Ribbon?

Organize tab

Which of the following views lets you see how the report will look in print and also allows you to make modifications to the print settings?

Print Preview view

Which of the following is a special text format applied to a Long Text data type that allows you to store formatted text?

Rich Text

Which of the following functions rounds a value?

Round

To select multiple controls at once, what must you press and hold down while selecting controls?

Shift

Which of the following options in the Totals category of the Group, Sort, and Total pane determines which section displays the totals?

Show in header or footer section

Which of the following is the default name that Access assigns to new blank tables?

Table1

Which of the following is true about blank reports?

They don't contain any controls.

Which of the following record validation rules prevents the user from entering the same value into both Field1 and Field2?

[Field1] <> [Field2]

When you make a change to the row height in Access, which of the following changes to the new height?

all of the rows

Which of the following indicates that a control has been selected?

an orange border

In a report, which of the following controls gets its value from an expression?

calculated control

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

calculated field

Which of the following is used to display or accept data for a field with a Yes/No data type?

check boxes

If you have several users of your database, what much each user do before you perform a backup procedure?

close

Which of the following should you do to the database file when you are finished working on it?

close

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

criterion

Which of the following must be assigned to each field in a database?

datatype

What does Access do when data is entered that violates a validation rule?

displays a message box

A macro is used to display or accept data for a field with a Yes/No data type.

false

Access allows you to sort on multiple fields only if each field is sorted in ascending order.

false

Access tables can be printed in a portrait orientation, but not in a landscape orientation.

false

Descending order is the lowest to highest for a number field or A to Z for a text field.

false

It is important to save a database file before closing it.

false

It is possible to create validation rules in Design view, but not in Datasheet view.

false

The AND logical operator requires a record to meet at least one of the individual conditions specified in order to be included in the results.

false

To organize controls vertically on a form, use a tabular layout.

false

When adding fields to a form, press Ctrl+F8 to show or hide the Field List.

false

When defining multiple conditional formatting rules, the order in which the rules are listed is not important.

false

When you use a wildcard, the criterion of your expression must be enclosed in parentheses.

false

In a table, which of the following must be identified as the primary key?

field

What must be added into a table before relationships between two tables can be established?

foreign key

Which of the following is useful when you want to organize and summarize you data?

grouping

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 forces a user to enter data using a specific format?

input mask

What symbol displays when Date and Currency values are too wide to fit in the column?

pound signs (#####)

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

referential integrity

After you create a query, what must you do in order to see the results?

run the query

What must you do if you make any changes to the relationships between tables?

save them

For number fields, what is the default sort order?

smallest to largest

Which of the following control layouts organizes data vertically?

stacked layout

Which of the following report layouts displays fields in a row and column format?

tabular

A bound form contains a link to the data source.

true

A template provides you with a complete, ready-to-use database application.

true

Access is a relational database management system.

true

An input mask only displays when a user clicks into that field.

true

At times no records will display when you run a query.

true

Functions are pre-built procedures that perform a specific task.

true

If you open a table with a previously saved sort, clicking Remove Sort on the Home tab removes the sort.

true

It is possible to change a limited number of field properties in Datasheet view.

true

Making changes to the data shown in Datasheet view of a query changes the actual table data.

true

Some form controls are unbound, which means that they are not linked to a data source.

true

The Command Button Wizard creates a button and attaches all of the necessary functionality to the button.

true

The Format property indicates the way a field displays in a table; it doesn't change what is actually stored.

true

The Update Status Bar Text option is most appropriate if you have created many different objects in your database and later make a change to the Description property of the field.

true

When a new blank form is created, there are no controls initially placed on the form.

true

When using validation rules it is important that the rules are tested.

true

You can create a query in Design view or with the Query Wizard.

true


Conjuntos de estudio relacionados

Chapter 18: Nursing Management of the Newborn 1-4

View Set

Entrepreneurship Unit 1: What Is Entrepreneurship?

View Set

intro Digital forensics Final study

View Set

Introduction to Coordinate Systems

View Set

SEP - Foundationalist theories of epistemic justification

View Set