Do you think you have to open a database in Exclusive mode to remove a database password?
|
1
|
|
You're right.
|
In fact, you do.
|
The answer is Yes.
|
@@QUES 020102 SXY Q,124,422,350,302
In which view do you think you need to have a form open to specify the type of access that users have to it?
|
Choose an option.
|
Datasheet
Form
Design
|
|
3
|
That's right.
|
That's not it. The correct option is now highlighted.
|
The correct option is now highlighted.
@@QUES 020103 SXY Q,123,424,382,350
What do you think setting a form's Allow Edits property as No does?
|
Choose an option.
|
Prevents users from opening the form in Design view
Only allows users to open the form in Design view in read-only mode
Prevents users from opening the form
Prevents users from changing the form's source records in Form or Datasheet view
|
|
4
|
That's right.
|
That's not it. The correct option is now highlighted.
|
The correct option is now highlighted.
@@QUES 020104 MXY Q,258,376,283,310
Which of the following results do you think Access can fix for you?
|
Choose each appropriate item.
|
Recommendation
Suggestion
Idea
|
|
1,2
|
That's right.
|
Partly right. The correct options are now highlighted.
|
You have not made any correct choices. The correct options are now highlighted.
|
The correct options are highlighted.
@@QUES 020105 GD1 T,12,240,262,217
Click the option in the ^UDatabase^u ^UUtilities^u submenu that you think you need to select to compact a database.
|
Click an option.
|
0201051,(159,293,146,20)
|
|
That's it.
|
0201052,(139,293,146,20),0201053,(178,293,146,38)
|
You haven't clicked the correct option. Try again.
|
In fact, it's the ^UCompact Database^u option.
|
The correct option is now indicated.
@@QUES 020301 SXY Q,113,377,328,271
In which view do you think you need to open a table before defining a validation rule for one of its fields?
|
Choose an option.
|
Datasheet
Design
|
|
2
|
That's right.
|
That's not it. The correct option is now highlighted.
|
The correct option is now highlighted.
@@QUES 020302 SXY Q,127,434,327,350
What do you think validation text is?
|
Choose an option.
|
A validation rule for a field that has the Text data type
The text that is displayed when a validation rule is broken
Any text in a validation rule
The name of a validation rule
|
|
2
|
That's right.
|
That's not it. The correct option is now highlighted.
|
The correct option is now highlighted.
@@QUES 020303 SXY Q,19,395,328,303
What do you think you need to do next to create a validation rule for the records in the table?
|
Choose an option.
|
Select the fields in which you want to restrict data entry
Click the ^UProperties^u button
|
|
2
|
That's right.
|
That's not it. The correct option is now highlighted.
|
The correct option is now highlighted.
@@QUES 020304 T/F Q,154,417,292,350
Do you think the following statement is true or false?
Any bound control in a form inherits the validation rule defined for the underlying field.
|
1
|
|
That's right.
|
In fact, the statement is true.
|
The statement is true.
@@QUES 020305 Y/N Q,387,337,235,251
Do you think an input mask is an expression?
|
2
|
|
You're right.
|
In fact, it isn't.
|
The answer is No.
@@QUES 020306 Y/N Q,198,353,200,250
Do you think you can modify an input mask?
|
1
|
|
You're right.
|
In fact, you can.
|
The answer is Yes.
@@QUES 020501 T/F Q,80,387,287,313
Do you think the following statement is true or false?
To create a Lookup list, you must create a new field to contain the list.
|
2
|
|
That's right.
|
Actually, you can modify an existing field.
|
The statement is false.
@@QUES 020502 Y/N Q,318,408,275,299
In this example, if a new customer is added to the Customers table, do you think its company name will be displayed in the Lookup list?
|
1
|
|
You're right.
|
In fact, it will.
|
The answer is Yes.
@@QUES 020503 GD1 T,261,291,303,183
Click the button that you think you now need to use to create a value list.
|
Click a button.
|
0205031,(78,240,18,15)
|
|
That's it.
|
0205032,(64,0,18,29),0205033,(23,9,522,28)
|
You haven't clicked the correct button. Try again.
|
In fact, it's the down-pointing arrow.
|
The correct button is now indicated.
@@QUES 020101t SXY Q,0,0,309,292
In which mode must a database be open before you can assign a password to it?
|
Choose an option.
|
Shared
Read-only
Exclusive
|
3
|
15
|
Correct.
|
Incorrect. The correct option is now highlighted.
|
@@QUES 020102t Y/N Q,0,0,305,270
Can you use the Performance Analyzer to analyze a single database object?
|
1
|
10
|
Correct.
|
Incorrect. The answer is Yes.
@@QUES 020103t SXY Q,0,0,328,350
What does compacting a database do?
|
Choose an option.
|
Deletes all the forms and reports in the database
Deletes all the old or obsolete records in the database
Rearranges the way the database file is stored on disk
Reduces the size of the database file
|
3
|
20
|
Correct.
|
Incorrect. The correct option is now highlighted.
|
@@QUES 020301t Y/N Q,0,0,302,271
Does a field's data type restrict the data that can be entered into the field?
|
1
|
10
|
Correct.
|
Incorrect. The answer is Yes.
|
@@QUES 020302t SXY Q,0,0,324,403
When is validation text displayed?
|
Choose an option.
|
When you click a cell in a field that has been assigned a validation rule
When you open a table that contains fields that have been assigned validation rules
When a validation rule is broken
When you attempt to modify a validation rule
|
3
|
20
|
Correct.
|
Incorrect. The correct option is now highlighted.
|
@@QUES 020303t SXY Q,0,0,392,412
Suppose you want to set a validation rule for all the records in a table so that dates in the Required field are always within 20 days of the corresponding dates in the Order field.
Which of the following is the correct validation rule?
|
Choose an option.
|
[Order]<=[Required] + 20
[Required]<=[Order] + 20
<= [Order] + 20
<= 20
|
2
|
20
|
Correct.
|
Incorrect. The correct option is now highlighted.
|
@@QUES 020304t SXY Q,0,0,262,324
In a form, which type of control inherits validation rules from an underlying table?
|
Choose an option.
|
Bound
Unbound
|
1
|
10
|
Correct.
|
Incorrect. The correct option is now highlighted.
|
@@QUES 020305t XYF Q,0,0,319,350
The _______________ displays characters in a field with blanks that users can fill in.
|
Choose an option to fill the blank.
|
%010validation rule
%010validation field
%010validation text
%010input mask
|
4
|
20
|
Correct.
|
Incorrect. The correct option is now highlighted.
|
The full statement is now shown.
@@QUES 020501t DTF Q,0,0,287,332
______ fields display the values in other fields.
______ fields display a fixed set of values.
|
Choose an option to fill the first blank.
|
Choose an option to fill the second blank.
|
Value
Lookup
|
2
|
Correct.
|
10
|
Incorrect. It's the other way around.
|
0
|
Incorrect.
|
0
|
Incorrect.
|
0
|
The full statements are now shown.
@@QUES 020502t T/F Q,0,0,286,292
The Lookup Wizard can be used to create both Lookup and value fields.
|
1
|
10
|
Correct.
|
Incorrect. The statement is true.
@@QUES 020503t MXY Q,0,0,276,326
Which of the following can you use to provide data for a Lookup field?
|
Choose each appropriate item.
|
Tables
Forms
Reports
Queries
|
1,4
|
24
|
Correct.
|
6 per correct decision
|
Partly right. The correct options are now highlighted.
|
You have not made any correct choices. The correct options are now highlighted.
