Exam 9: Get Connected
Exam 1: Office 365 Common Features100 Questions
Exam 2: Introduction to Access87 Questions
Exam 3: Tables and Queries in Relational Databases97 Questions
Exam 4: Query Calculations and Expressions87 Questions
Exam 5: Basic Forms and Reports89 Questions
Exam 6: Data Validation and Data Analysis96 Questions
Exam 7: Action and Specialized Queries98 Questions
Exam 8: Advanced Forms and Reports98 Questions
Exam 9: Get Connected98 Questions
Exam 10: Fine-Tuning the Database100 Questions
Exam 11: Enhanced Database Techniques97 Questions
Select questions type
In order to save time in data entry, it is almost always preferable to export the data as well as the structure when exporting to another database.
(True/False)
5.0/5
(37)
Which of the following Access objects cannot be exported to Excel?
(Multiple Choice)
4.8/5
(42)
When you export data from Access to Excel, the fields in Access become ________ in Excel.
(Short Answer)
4.9/5
(43)
When you export data from Access to Excel, the fields in Access become what in Excel?
(Multiple Choice)
4.9/5
(37)
Match the following terms with their descriptions:
I. Attachment controls
II. XPS
III. Attachment field
IV. URL
V. CSV text file
A. Developed by Microsoft
B. Location of a website
C. Used to attach several files to a record
D. Allows you to manage attached files in forms and reports
E. Uses a comma to delineate columns
(Essay)
4.9/5
(33)
The hyperlink data type that enables you to link to a file on your computer, to a webpage on the Internet, or to an email address.
(True/False)
4.8/5
(41)
One advantage of linking to an external Excel sheet is that you can edit the data directly in Access instead of having to open the file in Excel and make the changes there.
(True/False)
4.8/5
(45)
Because RTF is designed to work with several programs, it does not support standard alignment options.
(True/False)
4.8/5
(46)
What does the number indicate if you see it in parenthesis to the right of the paperclip icon?
(Multiple Choice)
4.7/5
(39)
If you open and modify an attached file in its associated application, Access will automatically save the modified file back into the database.
(True/False)
4.8/5
(37)
________ allows you to connect to an external database without having to import the table into your current database.
(Short Answer)
4.9/5
(32)
When exporting from Access to Excel, you can use an Access table or ________.
(Short Answer)
4.9/5
(43)
If you want to export several objects from one database to another at the same time, make sure the Multiple Objects check box is checked.
(True/False)
4.8/5
(30)
Showing 81 - 98 of 98
Filters
- Essay(0)
- Multiple Choice(0)
- Short Answer(0)
- True False(0)
- Matching(0)