Deck 16: Access and the Web

Question 1

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

Answer 1

True

Question 2

Hyperlink fields store files and Web pages.

Answer 2

False

Question 3

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

Answer 3

True

Question 4

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

Question 5

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

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

Question 6

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 7

Importing brings data into the database from an external file.

Question 8

HTML stands for _____.

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

Question 9

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

Question 10

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

Question 11

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 12

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

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

Question 13

You use Access 2013 to create an Access Web app.

Question 14

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

Question 15

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

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

Question 16

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

Question 17

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

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

XML markup tags use the same as HTML markup tags.

Question 20

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

Question 21

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 22

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 23

Which HTML tag would mark the end of bold content?

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

Question 24

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

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

Question 25

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 26

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 27

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 28

Which tag marks an HTML line break?

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

Question 29

HTML tags are called HTML _____ by Web page developers

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

Question 30

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

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

Question 31

Web page formatting and presentation is defined with which technology?

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

Question 32

Which HTML tag would you use to markup monospaced text?

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

Question 33

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

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

Question 34

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

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

Question 35

XML stands for _____.

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

Question 36

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

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

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

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 39

CSS stands for _____.

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

Question 40

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

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

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

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

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

Question 43

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

Question 44

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

Question 45

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

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

Question 46

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 47

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 48

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 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 header entry?

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

Question 51

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

Question 52

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 53

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 54

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

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

Question 55

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 56

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 57

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 58

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

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

Question 59

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 60

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

Question 61

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

Question 62

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

Question 63

Sara needs to distribute some Access forms and reports to others throughout her company.  Discuss the disadvantages of using an Access Web app for this purpose.

Question 64

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

Question 65

The figure shows a portion of an XML file.

Question 66

Kristen wants to distribute some Access forms and reports to others throughout her company.  What software is required, and what is the purpose of each?

Question 67

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

Question 68

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

Question 69

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

Question 70

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 71

Kent needs to distribute some Access forms and reports to others throughout his company.  Discuss the advantages of using an Access Web app for this purpose.

Question 72

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

Question 73

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

Question 74

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

Question 75

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

Question 76

Doug wants to store hyperlinks to Word documents in a field. Explain how this is done.  Use the figure as a reference for the hyperlink data for the first record.

Question 77

The figure shows a portion of an HTML file.

Question 78

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