Exam 8: Sharing,integrating,and Analyzing Data

A file format that preserves the original formatting and pagination of its contents regardless of where it is viewed is the PDF (portable document format)file format.

(True/False)

4.8/5

(101)

Question 21

A(n)____________________ contains tags and other instructions that a Web browser processes and displays as a Web page.

(Short Answer)

4.8/5

(89)

Question 22

The horizontal axis of a chart that contains labels describing each of the data items.

(Multiple Choice)

4.8/5

(72)

Question 23

A program containing original information or an object.

(Multiple Choice)

4.8/5

(72)

Question 24

Begin the process of importing an XML file on the External Data tab in the ____________________ group.

(Short Answer)

4.9/5

(87)

Question 25

A specialized template which may contain tables,relationships,queries,forms,reports,and other database objects that can be imported into an existing database is a(n)____________________.

(Short Answer)

4.7/5

(79)

Question 26

Developers may customize the ____________________ programming language to describe the data contained and the data structure.

(Short Answer)

4.8/5

(80)

Question 27

The ____________________ Wizard allows Field Names to be added to text files imported into an Access database if the first row of the imported data does not contain field names.

(Short Answer)

4.7/5

(87)

Question 28

Which Excel external data option automatically updates a table in the Access database when the Excel source file is updated?

(Multiple Choice)

4.8/5

(74)

Question 29

To export an Access database object to an HTML document,click the ____ button on the External Data tab on the Ribbon.

(Multiple Choice)

4.9/5

(71)

Question 30

Access will create a table from data imported from an Excel spreadsheet if the table specified in the Get External Data dialog box does not exist when the ____option is chosen,and changes made to the source data will not be reflected in the database..

(Multiple Choice)

4.9/5

(84)

Question 31

A program in which information is placed from a program containing original information or an original object.

(Multiple Choice)

4.7/5

(89)

Question 32

Predefined templates for Access databases that include tables,relationships,queries,forms,reports,and other database objects are displayed in ____________________ view.

(Short Answer)

4.9/5

(79)

Question 33

Brij has just been promoted to Marketing Manager of a non-profit organization responsible for soliciting over three million dollars in donations annually. His company solicits donor information from local chapters of the non-profit organization. Brij decides to create an Access database that will allow him to keep all donor information in one database and create reports as well as marketing documents using the database. Based on your knowledge of importing and sharing Access data,answer the questions below. -Brij has been asked to share a report with the non-profit's Board of Directors which lists all donors by state.Brij created a query to appropriately sort the data and generated the report using Access.The report will be shared using e-mail.Which option is Brij most likely to choose to share this information?

(Multiple Choice)

4.9/5

(76)

Question 34

When an Access table is exported as an HTML file,the column headings in the HTML document are determined by the ____.

(Multiple Choice)

4.9/5

(90)

Question 35

The Chart Type window in Microsoft Graph offers the option to create custom chart types.

(True/False)

4.9/5

(70)

Question 36

The process of identifying and eliminating anomalies from a collection of tables is called ____.

(Multiple Choice)

5.0/5

(82)

Question 37

The form control that appears in the Access window with tabs at the top is the ____ Control.

(Multiple Choice)

4.9/5

(79)

Question 38

Table or query data may be exported directly to the mail merge feature in Microsoft Excel.____________________

(True/False)

4.9/5

(91)

Question 39

The encoding method for exporting Access data to an XML file which uses 16 bits to represent each character is the ____________________ encoding method.

(Short Answer)

4.9/5

(83)

Question 40

Showing 21 - 40 of 75

A file format that preserves the original formatting and pagination of its contents regardless of where it is viewed is the PDF (portable document format)file format.

A(n)____________________ contains tags and other instructions that a Web browser processes and displays as a Web page.

The horizontal axis of a chart that contains labels describing each of the data items.

A program containing original information or an object.

Begin the process of importing an XML file on the External Data tab in the ____________________ group.

A specialized template which may contain tables,relationships,queries,forms,reports,and other database objects that can be imported into an existing database is a(n)____________________.

Developers may customize the ____________________ programming language to describe the data contained and the data structure.

The ____________________ Wizard allows Field Names to be added to text files imported into an Access database if the first row of the imported data does not contain field names.

Which Excel external data option automatically updates a table in the Access database when the Excel source file is updated?

To export an Access database object to an HTML document,click the ____ button on the External Data tab on the Ribbon.

Access will create a table from data imported from an Excel spreadsheet if the table specified in the Get External Data dialog box does not exist when the ____option is chosen,and changes made to the source data will not be reflected in the database..

A program in which information is placed from a program containing original information or an original object.

Predefined templates for Access databases that include tables,relationships,queries,forms,reports,and other database objects are displayed in ____________________ view.

When an Access table is exported as an HTML file,the column headings in the HTML document are determined by the ____.

The Chart Type window in Microsoft Graph offers the option to create custom chart types.

The process of identifying and eliminating anomalies from a collection of tables is called ____.

The form control that appears in the Access window with tabs at the top is the ____ Control.

Table or query data may be exported directly to the mail merge feature in Microsoft Excel.____________________

The encoding method for exporting Access data to an XML file which uses 16 bits to represent each character is the ____________________ encoding method.

Creating a Database

Building a Database and Defining Table Relationships

Maintaining and Querying a Database

Creating Forms and Reports

Creating Advanced Queries and Enhancing Table Design

Using Form Tools and Creating Custom Formsmodule

Creating Custom Reports

Using Action Queries and Advanced Table Relationships

Automating Tasks With Macros

Using and Writing Visual Basic for Applications Code

Managing and Securing a Database

Relational Databases and Database Design

Filters