Deck 17: Chapter Access and the Web

Question 1

What is the default color of a visited hyperlink entry in a field?

A) black
B) red
C) blue
D) purple

Answer 1

D

Question 2

Hyperlink fields store files and Web pages.

Answer 2

False

Question 3

When you export a table to an HTML file, you have the option preserve the formatting and layout of the table.

Answer 3

True

Question 4

Hyperlink fields automatically update if the location of the Web page or file changes.

Question 5

HTML stands for _____.

A) Hypertext Master Lines
B) Hypertext Markup Language
C) Hyperlink Mass Language
D) Hyperlink Marketing Lines

Question 6

Both a command button and a label can be modified to work as hyperlink controls.

Question 7

The process of exporting a report to an HTML or XML file is very similar.

Question 8

You use Access 2013 to create an Access Web app.

Question 9

You can create a Hyperlink field in a table's datasheet view.

Question 10

An image control can be modified to work as hyperlink controls.

Question 11

You must be signed in to your Microsoft account to access your SkyDrive.

Question 12

What is the default color of a hyperlink entry in a field?

A) black
B) red
C) blue
D) purple

Question 13

You must know the email address of someone you want to share a file with using SkyDrive.

Question 14

The Hyperlink Address property is found on the _____ tab of the property sheet.

A) Format
B) Data
C) Event
D) Other

Question 15

Which data type should you use to store Web page address data in a record such as www.boston.com ?

A) Attachment
B) WebPage
C) HTML
D) Hyperlink

Question 16

You can open an HTML file in a browser such as Firefox or Internet Explorer.

Question 17

XML markup tags use the same as HTML markup tags.

Question 18

The hyperlink pointer looks like a(n) _____.

A) red x
B) pointing hand
C) white arrow
D) black double-headed arrow

Question 19

Importing brings data into the database from an external file.

Question 20

When you hover over hyperlink data in a datasheet with your mouse, what appears?

A) A ScreenTip with the path to the hyperlink resource
B) A thumbnail picture of the hyperlink resource
C) The Description property of the resource
D) A MiniToolbar that allows you to format the entry

Question 21

Which form control would you use to format text with HTML markup tags?

A) label
B) text box
C) combo box
D) list box

Question 22

Web page formatting and presentation is defined with which technology?

A) HTML
B) Rich Text controls
C) XML
D) CSS

Question 23

XML stands for _____.

A) Extensible Markup Language
B) Extraneous Markup Language
C) Extraordinary Markup Language
D) External Markup Language

Question 24

The beginning of text to be formatted is marked with a(n) _____ tag.

A) start
B) beginning
C) front
D) opening

Question 25

Which file is helpful to allow a human to easily read an XML file?

A) HTML
B) XSD
C) XDOC
D) XSL

Question 26

Tags are entered into an HTML file in ____.

A) (parentheses)
B) {curly brackets}
C)
D) [square brackets]

Question 27

When exporting to XML, which helper file is created that contains a description of the data's characteristics?

A) XML
B) XSD
C) XSL
D) XLS

Question 28

Which tag marks an HTML line break?

A) break
B) lb/
C) break/
D) br/

Question 29

Which file provides information about the data types and properties that can be used to ensure the integrity of an XML file?

A) HTML
B) XSD
C) XDOC
D) XSL

Question 30

HTML tags are called HTML _____ by Web page developers

A) elements
B) content
C) styles
D) rules

Question 31

You can import data from an HTML file into Access provided the data is structured in the HTML file with ____ tags.

A) formatting
B) table
C) font
D) database

Question 32

Which HTML tag would mark the end of bold content?

A) b
B) /b
C) bold
D) /bold

Question 33

What is the purpose of XML?

A) To markup content on a web page
B) To markup data to be shared between computer programs
C) To style a Web page
D) To define the layout of a Web page

Question 34

When exporting to XML, which helper file is created that contains a description of how the data is to be formatted?

A) XML
B) XSD
C) XSL
D) XLS

Question 35

CSS stands for _____.

A) Cascading Single Styles
B) Cascading Style Sheets
C) Computing Style Sets
D) Computing Style Series

Question 36

Which HTML tag would you use to markup monospaced text?

A) code
B) monospace
C) Courier
D) type

Question 37

The line break HTML tag is an example of a(n) _____.

A) opening tag
B) paired tag
C) closing tag
D) empty tag

Question 38

Which html tag identifies the color, font face, and size of the marked content?

A) text
B) markup
C) font
D) format

Question 39

Which tag marks the beginning of a row of data in HTML?

A) row
B) record
C) tr
D) td

Question 40

Who is the leading international standards committee on fundamental Web technologies?

A) World Wide Web Consortium
B) Microsoft
C) IBM
D) Google

Question 41

Create a(n) _____ data type when you want to store a link to a Web page or file in a field.

Question 42

The Edit Hyperlink dialog box in the figure indicates that the user is in the process of creating a link to a(n) _____.

A) Word document
B) Web page
C) E-mail address
D) report object

Question 43

Being Web compatible means that a form can be opened and used with Internet Explorer when the database is published to a(n) _____ server.

Question 44

When importing data from an XML file, what helps define field data types?

A) the schema file, the XSD file
B) the choices you make in the import XML Wizard
C) the associated css file
D) the helper HTML file

Question 45

_____ is the language used to describe content in a traditional Web page.

Question 46

In the figure shown, what html tag is used to mark the beginning of a table row?

A) table
B) tr
C) th
D) html

Question 47

Which address would you enter into a browser to work with your SkyDrive?

A) skydrive.com
B) microsoftskydrive.com
C) mydrive.com
D) sky.com

Question 48

The figure shows HTML ____ to mark up the content in the text box.

Question 49

_____ is a cloud-based storage and file-sharing service provided by Microsoft.

Question 50

In the figure shown, what html tag is used to mark the beginning of a table?

A) table
B) tr
C) th
D) html

Question 51

In the figure shown, what formatting change is made to the last sentence?

A) the color is red
B) the size is 6
C) the font face is Arial
D) the font is italic

Question 52

You convert a label into a hyperlink label by modifying the label's Hyperlink _____ property.

Question 53

What HTML tag marks the beginning of a table header entry?

A) table
B) header
C) th
D) tbl

Question 54

In the figure shown, what formatting change is made to the "50% nonrefundable..." sentence?

A) the color is red
B) the size is 6
C) the font face is Arial
D) the font is italic

Question 55

In the figure shown, how many line breaks are included?

A) 2
B) 4
C) 6
D) 8

Question 56

Which tag marks the beginning of a field of data in HTML?

A) column
B) field
C) tr
D) td

Question 57

In the figure shown, what formatting change is made to the first sentence?

A) the color is red
B) the size is 6
C) the font face is Arial
D) the font is italic

Question 58

An Access Web app is saved with the extension of _____.

A) .accdb
B) .laccdb
C) .webaccdb
D) .accdw

Question 59

In the figure shown, how many line breaks are added after the first sentence?

A) 1
B) 2
C) 3
D) 4

Question 60

In the figure shown, what html tag is used to mark the beginning of a table header entry?

A) table
B) tr
C) th
D) html

Question 61

Describe the role of the three XML files that are created when you export Access data to an XML file format.

Question 62

An Access Web app is a special type of Access database that is stored on a SharePoint 2013 server.

Question 63

Match the HTML tag to its purpose.
a.
d.
b.

e.
c.
marks the end of italicized text

Question 64

You must have access to a SharePoint 2013 server that is configured to support Access Web apps to start creating them.

Question 65

The figure shows the HTML ____ tag to create a line break.

Question 66

In an XSD file, the markup of the data is a description of the fields and their properties.

Question 67

The figure shows a portion of an XML file.

Question 68

In the figure shown, the table tag marks the beginning of a table row.

Question 69

Which type of form could Cody create to provide an easy-to-use database interface that is also Web compatible?

Question 70

The figure shows a portion of an HTML file.

Question 71

Match the HTML tag to its purpose.
a.
d.
b.

e.
c.
marks the beginning of a text font size

Question 72

Explain why HTML formatting tags are appropriate to use in an Access report but not for current web page development.

Question 73

Use a community folder to share files with other people in your SkyDrive.

Question 74

Match the HTML tag to its purpose.
a.
d.
b.

e.
c.
creates a line break

Question 75

Forms in a traditional desktop database are called screens in an Access Web app.

Question 76

HTML 4 is the latest version of HTML as defined by leading Web technology standards.

Question 77

Match the HTML tag to its purpose.
a.
d.
b.

e.
c.
marks the beginning of bold text

Question 78

Explain why XML files make it easier to pass data between two programs as compared to HTML files.

Question 79

Word Text is a Text Format property that allows you to mix formatting of text displayed by a text box on a form or report.

Question 80

Match the HTML tag to its purpose.
a.
d.
b.

e.
c.
marks the end of font formatting