Computer Based Training: …, Windows 95 & NT Basics/a1454501.iso/mo97a03/AA01Q.TXT

Text File | 1997-05-06 | 9.0 KB | 454 lines

@@QUES 010101 T/F Q,156,370,286,314
Do you think the following statement is true or false?

If you are not familiar with SQL you cannot create queries in Access 97.
|
2
|

|
That's right.
|
Actually, you can.
|
The statement is false.
|
@@QUES 010102 MXY Q,144,380,306,350
Which of the following do you think are types of action query in Access?
|
Choose each appropriate item.
|
Delete queries
Update queries
Append queries
Make-table queries
Remove-table queries
|

|
1,2,3,4
|
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 010201 SXY Q,12,381,257,350
What do you think each column in the design grid represents?
|
Choose an option.
|
A table you work with in the query
A recordset you design with the query
An individual query in the database
A field you work with in the query
|

|
4
|
That's right.
|
That's not it. The correct option is now highlighted.
|
The correct option is now highlighted.

@@QUES 010202 GD1 T,112,232,300,180
Click the button you think will return you to the Design view of your query.
|
Click a button.
|
0102021,(22,6,38,29)
|

|
That's it.
|
0102022,(22,44,589,31)
|
You haven't clicked the correct button. Try again.
|
In fact, it's the View button (showing the Design view icon).
|
The correct button is now indicated.

@@QUES 010203 GD1 T,382,449,247,212
Click the button you think will move the highlighted field from the Available Fields list to the Selected Fields list.
|
Click a button.
|
0102031,(191,270,34,24)
|

|
That's it.
|
0102032,(215,270,36,90)
|
You haven't clicked the correct button. Try again.
|
In fact, it's the > button.
|
The correct button is now indicated.

@@QUES 010204 SXY Q,350,335,253,260
Which type of relationship do you think is represented here?
|
Choose an option.
|
one-to-one
one-to-many
many-to-one
|

|
2
|
That's right.
|
That's not it. The correct option is now highlighted.
|
The correct option is now highlighted.

@@QUES 010205 Y/N Q,60,414,353,276
Do you think you can see the SQL statements that Access has stored with your query?
|
1
|

|
You're right.
|
In fact, the answer is Yes.
|
The answer is Yes.
|
@@QUES 010206 T/F Q,66,407,350,350
Do you think the following statement is true or false?

When you click OK, both the query and its resulting recordset are saved.
|
2
|

|
That's right.
|
Actually, only the query is saved. The statement is false.
|
The statement is false.
|
@@QUES 010401 GD1 T,22,273,285,199
Click the button you think will allow you to make changes to the construction of the selected query.
|
Click a button.
|
0104011,(112,549,83,26)
|

|
That's it.
|
0104012,(81,549,83,31),0104013,(138,549,79,35)
|
You haven't clicked the correct button. Try again.
|
In fact, it's the Design button.
|
The correct button is now indicated.

@@QUES 010402 Y/N Q,209,383,224,282
Do you think you can apply filter criteria to a field in a query without including the field in the recordset?
|
1
|

|
You're right.
|
In fact, you can.
|
The answer is Yes.
|
@@QUES 010403 GD1 T,306,276,308,177
Click the button that you think would add the selected field to the expression.
|
Click a button.
|
0104031,(131,391,64,29)
|

|
That's it.
|
0104032,(131,123,268,31),0104033,(61,455,60,99)
|
You haven't clicked the correct button. Try again.
|
In fact, it's the Paste button.
|
The correct button is now indicated.

@@QUES 010404 GD1 T,17,241,236,199
Click the button you think would place a multiplication operator in the expression.
|
Click a button.
|
0104041,(132,164,16,29)
|

|
That's it.
|
0104042,(130,123,41,32),0104043,(130,179,276,30)
|
You haven't clicked the correct button. Try again.
|
In fact, it's the * button.
|
The correct button is now indicated.

@@QUES 010405 T/F Q,318,462,313,313
Do you think the following statement is true or false?

Access does not allow you to change the name of a calculated field in a recordset.
|
2
|

|
That's right.
|
Actually, the statement is false.
|
The statement is false.
|
@@QUES 010101t SXY Q,0,0,277,334
What does SQL stand for?
|
Choose an option.
|
Simple Query Language
Simple Question Language
Structured Query Language
Structured Question Layout
|
3
|
20
|
Correct.
|
Incorrect. The correct option is now highlighted.

@@QUES 010102t MXY Q,0,0,510,329
Identify the correct statement(s) about the SQL used by Access.
|
Choose each appropriate item.
|
Access uses the standard version of SQL adopted by the ANSI and the ISO
The SQL used by Access complies with the ODBC standard
Access cannot communicate with other database applications because its SQL is unique
|
2
|
21
|
Correct.
|
7 per correct decision
|
Partly right. The only correct option is now highlighted.
|
You have not made any correct choices. The only correct option is now highlighted.

@@QUES 010103t T/F Q,0,0,268,289
Queries in Access are stored as SQL commands only if you set an option requesting SQL versions.
|
2
|
10
|
Correct.
|
Incorrect. All queries created in Access are stored as SQL commands. The statement is false.

@@QUES 010104t Y/N Q,0,0,277,273
When you save a query in Access, is the recordset resulting from the query also saved?
|
2
|
10
|
Correct.
|
Incorrect. A recordset is created each time you open or run a query. The answer is No.

@@QUES 010201t SXY Q,0,0,347,254
What determines which icon is displayed on the @UNew Objects@u button?
|
Choose an option.
|
The last new object you created
The active tab in the Database window
|
1
|
10
|
Correct.
|
Incorrect. The correct option is now highlighted.

@@QUES 010202t DTF Q,0,0,347,276
If you sort a query on multiple fields, Access implements your sorting criteria from _____ to _____ in the design grid.
|
Choose an option to fill the first blank.
|
Choose an option to fill the second blank.
|
%010left
%010right
|
1
|
Correct.
|
10
|
Incorrect. It's the other way around.
|
0
|
Incorrect.
|
0
|
Incorrect.
|
0
|
The full statement is now shown.

@@QUES 010203t MXY Q,0,0,272,350
Which of the following are views of a query available on the @UView@u button's drop-down menu?
|
Choose each appropriate item.
|
Datasheet view
Design view
Grid view
SQL view
Recordset view
|
1,2,4
|
30
|
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.

@@QUES 010204t T/F Q,0,0,350,264
If you click the @UClose Window@u button from the current view of a query without first saving the query, you will immediately lose the query.
|
2
|
10
|
Correct.
|
Incorrect. You will be prompted to save the query before the window closes. The statement is false.

@@QUES 010205t MXY Q,0,0,367,414
Identify the true statement(s) about the join lines indicating relationships between tables in the Design view of a query.
|
Choose each appropriate item.
|
Join lines without arrowheads represent inner joins
Symbols showing the type of relationship are visible above the join lines only if referential integrity is enforced
An arrowhead on a join line indicates an outer join
There is no way of identifying inner and outer joins by looking at the join lines - you must view the join properties
|
1,2,3
|
28
|
Correct.
|
7 per correct decision
|
Partly right. The correct options are now highlighted.
|
You have not made any correct choices. The correct options are now highlighted.

@@QUES 010206t FIB Q,0,0,331,202
If you enter criteria for several fields in one row of the design grid, Access performs ___ operations between them.
|
Type the missing word.
|
20
|
%007AND
|
Correct.
|

|

|
Yes, but the word used here is "".
|
OR
|
10
|
other
|
Incorrect. The missing word is "AND".
|
Incorrect. Access performs AND operations between criteria entered in different fields in a row.
|
The full statement is now shown.

@@QUES 010401t T/F Q,0,0,282,273
You can apply a sort order or filter criteria to a field without showing the field in the recordset.
|
1
|
10
|
Correct.
|
Incorrect. The statement is true.

@@QUES 010402t MXY Q,0,0,413,405
Identify the true statement(s) about calculated fields in a query.
|
Choose each appropriate item.
|
You cannot create a calculated field in a query without using the Expression Builder
The Expression Builder gives you an easy way of entering formulas to calculate fields in a query
The formula used to calculate a field becomes the field name in the recordset resulting from a query
You can change the name of a field that is shown in a recordset only if it is a calculated field
|
2
|
28
|
Correct.
|
7 per correct decision
|
Partly right. The only correct option is now highlighted.
|
You have not made any correct choices. The only correct option is now highlighted.