|
1 | | Begin the import process of information into access by going to the Ribbon and clicking: |
| | A) | Create. |
| | B) | Insert Record. |
| | C) | Table Data. |
| | D) | External Data. |
|
|
|
2 | | Before importing data from another source into Access, it's important to delete: |
| | A) | Blank rows and columns. |
| | B) | Field names. |
| | C) | Comments. |
| | D) | Row headers. |
|
|
|
3 | | After creating a new table through an import, modify the table properties using the: |
| | A) | Design view. |
| | B) | Import Wizard. |
| | C) | Data Converter. |
| | D) | Table view. |
|
|
|
4 | | For a successful import from Excel to an existing Access file, the first row of the Excel file must contain the exact names of all of the _______ in the Access table. |
| | A) | Headers |
| | B) | Formulas |
| | C) | Fields |
| | D) | Cell references |
|
|
|
5 | | When data is imported into a new table, Access uses the first eight rows of each column to assign the: |
| | A) | Data type. |
| | B) | Format. |
| | C) | Design. |
| | D) | Functions. |
|
|
|
6 | | If you plan to frequently repeat an import process, you can save the steps to perform the action more quickly by clicking: |
| | A) | Import to Macro. |
| | B) | Save Import. |
| | C) | Replicate Task. |
| | D) | Save to List. |
|
|
|
7 | | If you want to modify spreadsheet data in a linked table, including adding or deleting records, the changes must be made: |
| | A) | In Access. |
| | B) | In both the original and linked tables. |
| | C) | In a separate table. |
| | D) | In Excel. |
|
|
|
8 | | To reflect changes made in a linked Excel file while the Access table is open, you must: |
| | A) | Save the Excel file. |
| | B) | Close and reopen the Access table. |
| | C) | Save the Access table. |
| | D) | Close and reopen the Excel file. |
|
|
|
9 | | In error situations with inconsistent data, try relinking, but first fix the data in: |
| | A) | The Access file. |
| | B) | The Excel file. |
| | C) | The error window. |
| | D) | The link address. |
|
|
|
10 | | The default text editor in Windows is: |
| | A) | MS Word. |
| | B) | Notepad. |
| | C) | TextEdit. |
| | D) | WordPad. |
|
|
|
11 | | A file that uses a character or tab to separate each field is described as: |
| | A) | Delimited. |
| | B) | Field detected. |
| | C) | Fixed column. |
| | D) | AutoTabbed. |
|
|
|
12 | | A fixed-width file stores the data fields within predefined positions and usually has the file extension of: |
| | A) | .xlxs. |
| | B) | .addbx. |
| | C) | .txt. |
| | D) | .docx. |
|
|
|
13 | | The primary language used to build web pages is: |
| | A) | HTML. |
| | B) | PDF. |
| | C) | CSS. |
| | D) | BASIC. |
|
|
|
14 | | To merge documents, such as form letters, labels, or envelopes, with data sources from your Access databases, use: |
| | A) | MS Publisher. |
| | B) | Link Table window. |
| | C) | Mail Merge. |
| | D) | AutoAddress. |
|
|
|
15 | | You can add individual merge fields into labels by going to Arrange Labels and clicking: |
| | A) | Name Block. |
| | B) | New Field. |
| | C) | More Items. |
| | D) | Insert Label Item. |
|
|