Access 1-4 Simnet
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
