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

Text File | 1997-04-28 | 13.2 KB | 863 lines

@@QUES 030101 T/F Q,153,411,260,355
Do you think the following statement is true or false?

When you import data, the data remains in its external location, but you can read and change it from your database.
|
2
|

|
That's right.
|
Actually, the statement is false.
|
The statement is false.






@@QUES 030102 XYF Q,149,374,280,359
See if you can choose the correct option to fill the blank.

When you import data from another DBMS or file format, the data can be imported as a ______ .
|
Choose an option to fill the blank.
|
%010form
%010report
%010table
%010macro
|

|
3
|
That's right.
|
That's not it. The correct option is now highlighted.
|
The full statement is now shown.



@@QUES 030104 T/F Q,314,372,301,310
Do you think the following statement is true or false?

To link tables you need to select
^UFile - Get External Data - Link Tables.^u
|
1
|

|
That's right.
|
In fact, you do.
|
The statement is true.




@@QUES 030301 MXY Q,4,378,319,329
From which of the following do you think Access allows you to import or link data?
|
Choose each appropriate item.
|
Microsoft Excel
Delimited text files
Fixed-width text files
HTML files
|

|
1,2,3,4
|
That's right.
|
Partly right. All the options are correct and are now highlighted.
|
You have not made any correct choices. The correct options are now highlighted.
|
All the options are correct and are now highlighted.





@@QUES 030302 GD1 Q,214,331,268,213
Click the menu item that you think contains options that allow you to import spreadsheets.
|
Click a menu item.
|
0303021,(59,209,112,23)
|

|
That's it.
|
0303022,(82,209,112,20)
|
You haven't clicked the correct menu item. Try again.
|
In fact, it's the ^UImport^u menu item.
|
The correct menu item is now indicated.




@@QUES 030303 Y/N Q,157,391,252,282
In this example, do you think Access automatically assigns a data type to the selected field?
|
1
|

|
You're right.
|
In fact, it does.
|
The answer is Yes.





@@QUES 030304 Y/N Q,152,386,236,286
In this example, do you think Access assigns the table a Primary Key by default?
|
1
|

|
You're right.
|
In fact, it does.
|
The answer is Yes.





@@QUES 030305 Y/N Q,391,362,209,251
Do you think fixed-width text files use delimiters?
|
2
|

|
You're right.
|
In fact, they don't.
|
The answer is No.





@@QUES 030306 T/F Q,66,407,291,303
Do you think the following statement is true or false?

Access tries to determine whether the file is delimited or fixed-width.
|
1
|

|
That's right.
|
In fact, the statement is true.
|
The statement is true.





@@QUES 030307 T/F Q,22,398,230,308
Do you think the following statement is true or false?

Access uses the delimiter to divide the data into fields.
|
1
|

|
That's right.
|
In fact, the statement is true.
|
The statement is true.





@@QUES 030308 Y/N Q,264,448,283,291
Do you think Access can import from DBMSs that support the Open Database Connectivity standard?
|
1
|

|
You're right.
|
In fact, it can.
|
The answer is Yes.





@@QUES 030501 Y/N Q,22,270,251,253
Do you think the source data is changed when you export it?
|
2
|

|
You're right.
|
In fact, it isn't.
|
The answer is No.




@@QUES 030502 T/F Q,333,404,256,329
Do you think the following statement is true or false?

To export a table, you select ^UFile - Save As/Export^u and then select the table you want to export.
|
2
|

|
That's right.
|
Actually, you have to select the table before selecting ^UFile -^u ^USave As/Export^u.
|
The statement is false.




@@QUES 030503 SXY Q,227,408,319,350
What do you think loading the output of a database object into Excel does?
|
Choose an option.
|
It creates a link between the object and an Excel spreadsheet
It creates an Excel sheet that contains the object's data
It creates a text file
It appends the object's data to an existing Excel spreadsheet
|

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





@@QUES 030504 T/F Q,134,438,335,287
Do you think the following statement is true or false?

In this example, the report's group levels have been converted to Excel outline levels.
|
1
|

|
That's right.
|
In fact, they have.
|
The statement is true.





@@QUES 030505 SXY Q,21,384,350,315
In this example, as which type of text file do you think Access formats the data by default?
|
Choose an option.
|
Rich Text Format
Fixed-width
Delimited
|

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




@@QUES 030506 Y/N Q,57,455,294,303
If you view the file, do you think the data will be displayed in columns that all begin at the same location?
|
1
|

|
You're right.
|
In fact, it will.
|
The answer is Yes.





@@QUES 030507 MXY Q,262,404,292,340
Of which of the following do you think you can load the output into Word?
|
Choose each appropriate item.
|
Tables
Queries
Forms
Reports
Macros
|

|
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 030508 Y/N Q,351,360,256,268
In this example, do you think you can export data to Word by clicking the ^UOfficeLinks^u button?
|
2
|

|
You're right.
|
In fact, you have to first click the down-pointing arrow beside the ^UOfficeLinks^u button.
|
The answer is No.





@@QUES 030101t DTF Q,0,0,301,352
_________ data creates a copy of it in your database.

_________ data leaves it in its external location, but allows you to read and change it from your database.
|
Choose an option to fill the first blank.
|
Choose an option to fill the second blank.
|
Importing
Linking
|
1
|
Correct.
|
10
|
Incorrect. It's the other way around.
|
0
|
Incorrect.
|
0
|
Incorrect.
|
0
|
The full statements are now shown.





@@QUES 030102t XYF Q,0,0,264,358
When you link data from another DBMS or file format, the data is linked as a ______ .
|
Choose an option to fill the blank.
|
%010form
%010table
%010report
%010query
|
2
|
20
|
Correct.
|
Incorrect. The correct option is now highlighted.
|
The full statement is now shown.





@@QUES 030103t DTF Q,0,0,256,330
Access generally works faster with ________ data than with ______ data.
|
Choose an option to fill the first blank.
|
Choose an option to fill the second blank.
|
%010linked
%010imported
|
2
|
Correct.
|
10
|
Incorrect. It's the other way around.
|
0
|
Incorrect.
|
0
|
Incorrect.
|
0
|
The full statement is now shown.






@@QUES 030104t SXY Q,0,0,280,350
How are the icons for linked tables displayed in an Access database?
|
Choose an option.
|
In the same way as the icons for local tables
With an arrow beside them
With a circle beside them
With a cross beside them
|
2
|
18
|
Correct.
|
Incorrect. The correct option is now highlighted.
|






@@QUES 030105t MXY Q,0,0,365,350
Which of the following can you include when you import tables from another Access database?
|
Choose each appropriate item.
|
The previously defined relationships
Custom menus
Custom toolbars
The data that the table contains
|
1,2,3,4
|
24
|
Correct.
|
6 per correct decision
|
Partly right. All the options are correct and are now highlighted.
|
You have not made any correct choices. The correct options are now highlighted.
|






@@QUES 030106t Y/N Q,0,0,250,300
If you are importing queries, can you choose to save the imported queries as tables?
|
1
|
10
|
Correct.
|
Incorrect. The answer is Yes.
|






@@QUES 030301t MXY Q,0,0,331,384
From which of the following DBMSs or file formats can Access import or link data?
|
Choose each appropriate item.
|
dBase
Excel
Paradox
Lotus 1-2-3
Delimited and fixed-width text files
|
1,2,3,4,5
|
30
|
Correct.
|
6 per correct decision
|
Partly right. All the options are correct and are now highlighted.
|
You have not made any correct choices. The correct options are now highlighted.
|






@@QUES 030302t T/F Q,0,0,268,305
When you import from an Excel file, you can only import the first sheet in the workbook.
|
2
|
10
|
Correct.
|
Incorrect. The statement is false.







@@QUES 030303t MXY Q,0,0,333,350
Which of the following can you specify in the Import Spreadsheet Wizard dialog box?
|
Choose each appropriate item.
|
A field's name
Whether or not a field is indexed
A field's data type
Whether or not a field is imported
|
1,2,4
|
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 030304t SXY Q,0,0,339,350
What does a delimiter in a text file indicate?
|
Choose an option.
|
The data type of a field
The size of the file
The length of a row
The end of one field and the beginning of another
|
4
|
20
|
Correct.
|
Incorrect. The correct option is now highlighted.






@@QUES 030305t SXY Q,0,0,307,393
Suppose you want to import a delimited text file.

Which of the following file types do you need to select in the Import dialog box?
|
Choose an option.
|
^UDelimited text files^u
^UFixed-width text files^u
^UText files^u
^UMicrosoft Excel^u
|
3
|
18
|
Correct.
|
Incorrect. The correct option is now highlighted.






@@QUES 030306t SXY Q,0,0,292,350
What do the letters ODBC signify?
|
Choose an option.
|
Other Database Connection
Open Database Connectivity
Open Database Communication
Operating Database Connector
|
2
|
20
|
Correct.
|
Incorrect. The correct option is now highlighted.






@@QUES 030307t MXY Q,0,0,308,416
When you are linking dBase files to an Access database, which of the following do you need to specify?
|
Choose each appropriate item.
|
Any index files associated with the dBase file
The names of the fields in the linked table
The data types of the fields in the linked table
A unique record identifier
|
1,4
|
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 030501t T/F Q,0,0,277,319
When you export data, you create a link between the source data and the destination file or database.
|
2
|
10
|
Correct.
|
Incorrect. The statement is false.






@@QUES 030502t MXY Q,0,0,254,350
To which of the following can Access export data?
|
Choose each appropriate item.
|
FoxPro
dBase
Excel
Lotus 1-2-3
Paradox
|
1,2,3,4,5
|
25
|
Correct.
|
5 per correct decision
|
Partly right. All the options are correct and are now highlighted.
|
You have not made any correct choices. The correct options are now highlighted.






@@QUES 030503t Y/N Q,0,0,242,280
When you are exporting data, can you choose to copy to the source database?
|
1
|
10
|
Correct.
|
Incorrect. The answer is Yes.






@@QUES 030504t MXY Q,0,0,279,367
Of which of the following do you think you can load the output into Word or Excel?
|
Choose each appropriate item.
|
Queries
Tables
Reports
Forms
|
1,2,3,4
|
24
|
Correct.
|
6 per correct decision
|
Partly right. All the options are correct and are now highlighted.
|
You have not made any correct choices. The correct options are now highlighted.





@@QUES 030505t MXY Q,87,449,474,421
Suppose you want to export the Customers table to a Rich Text Format file.

Which of the following can you do?
|
Choose each appropriate item.
|
Select File - ^USave As/Export^u and then select ^URich Text Format^u from the Save as type drop-down list box
Select File - ^USave As/Export^u and then select ^UText Files^u from the Save as type drop-down list box
Select ^UPublish It with MS Word^u from the ^UOfficeLinks^u menu
Select ^UFile - Save As/Export^u and then select ^UMicrosoft Word^u from the Save as type drop-down list box
|
1,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 030506t MXY Q,0,0,329,407
Which of the following can you do by clicking the ^UOfficeLinks^u button?
|
Choose each appropriate item.
|
Export data to an Excel spreadsheet
Export data to a Word document
Merge data using the Microsoft Word Mail Merge Wizard
Export data to any ODBC-compliant DBMS
|
1,2,3
|
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.





@@QUES 030507t T/F Q,0,0,334,290
When you use the ^UPublish It with MS Word^u command, you can choose the type of text file you want to create.
|
2
|
10
|
Correct.
|
Incorrect. A Rich Text Format file is automatically created. The statement is false.
|