Filters
Question type

Study Flashcards

When you export data from Access to Excel, the fields in Access become columns in Excel.

A) True
B) False

Correct Answer

verifed

verified

Match the following terms with their descriptions: I. PDF II. XPS III. RTF IV. CSV V. URL A. Useful for basic formatted text documents B. Created by Adobe Systems C. Double-clicking will open Excel D. Considered an alternative to PDF E. http://www.amazon.com

Correct Answer

verifed

verified

Access uses the ________ icon to indicate attachments.

Correct Answer

verifed

verified

paperclip,...

View Answer

Which of the following statements is not true about importing an Excel spreadsheet into Access?


A) You have less control over the imported data.
B) It will make the database file size larger.
C) There will be no dependency between the imported data and the original Excel sheet.
D) You have more control over the imported data.

E) All of the above
F) None of the above

Correct Answer

verifed

verified

All attachments appear as icons representative of the program that created the file.

A) True
B) False

Correct Answer

verifed

verified

Microsoft ________ is often the default program for opening RTF files.

Correct Answer

verifed

verified

One reason for creating the PDF format was that the user would not need a particular operating system to view the file.

A) True
B) False

Correct Answer

verifed

verified

Attaching files increases the size of the database.

A) True
B) False

Correct Answer

verifed

verified

In a form or report, you can interact with attachments using an attachment ________.

Correct Answer

verifed

verified

What allows you to manage attached files in forms and reports?


A) Attachment control
B) Attachment subform/subreport
C) Hyperlink control
D) Attached File control

E) B) and C)
F) None of the above

Correct Answer

verifed

verified

Which of the following will the hyperlink data type not link to?


A) File on your computer
B) File stored only in RAM
C) Website
D) Email address

E) None of the above
F) A) and D)

Correct Answer

verifed

verified

B

________ is the process of copying external data directly into the database.

Correct Answer

verifed

verified

Importing

Exporting objects from one Access database to another often saves time because you do not have to create the objects (tables, forms, reports) from scratch.

A) True
B) False

Correct Answer

verifed

verified

Unless you filter the table, by default when you export an Access table to Excel, all fields and records are exported.

A) True
B) False

Correct Answer

verifed

verified

URL is the location of a website or webpage on the Internet.

A) True
B) False

Correct Answer

verifed

verified

When a report which has an attachment control is viewed in Print Preview, which attachment displays?


A) All of them
B) None of them
C) The last one
D) The first one

E) A) and B)
F) A) and C)

Correct Answer

verifed

verified

When you export data from Access to Excel, the records in Access become ________ in Excel.

Correct Answer

verifed

verified

What is not a primary key option when importing a text file into Access?


A) Set no primary key
B) Use the first field name as the primary key
C) Override the existing primary key numbers
D) Allow Access to use the existing primary key if there are no values in the imported data higher than any existing data

E) C) and D)
F) All of the above

Correct Answer

verifed

verified

C

Match the following desired actions with the method used to accomplish those actions: I. Add a title and formatting to a document in Word from data in Access II. Add data to a table from a text file III. Use a table from one database in another database IV. Make data in a spreadsheet available to Access V. Add various files to one field in Access A. Import a text file B. Add an attachment field C. Export to Word D. Export an Access object E. Import from Excel

Correct Answer

verifed

verified

XML Paper Specification (XPS) is a file format designed by Adobe.

A) True
B) False

Correct Answer

verifed

verified

Showing 1 - 20 of 98

Related Exams

Show Answer