Deck 15: Using Acess and the Web

Question 1

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

Answer 1

True

Question 2

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

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

Answer 2

D

Question 3

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

Answer 3

True

Question 4

Importing brings data into the database from an external file.

Question 5

HTML stands for _____.

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

Question 6

Hyperlink fields store files and webpages.

Question 7

The hyperlink pointer looks like a(n) _____.

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

Question 8

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

Question 9

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

Question 10

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

Question 11

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

Question 12

XML markup tags use the same as HTML markup tags.

Question 13

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

Question 14

You use Access to create an Access Web app.

Question 15

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

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

Question 16

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

Question 17

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 18

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

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

Question 19

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

Question 20

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

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

Question 21

What is the purpose of XML?

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

Question 22

XML stands for _____.

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

Question 23

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

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

Question 24

Webpage formatting and presentation is defined with which technology?

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

Question 25

Tags are entered into an HTML file in ____.

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

Question 26

CSS stands for _____.

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

Question 27

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 28

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

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

Question 29

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 30

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

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

Question 31

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 32

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

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

Question 33

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

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

Question 34

HTML tags are called HTML _____ by webpage developers

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

Question 35

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

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

Question 36

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 37

Which HTML tag would mark the end of bold content?

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

Question 38

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 39

Which HTML tag would you use to markup monospaced text?

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

Question 40

Which tag marks an HTML line break?

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

Question 41

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

Question 42

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

Question 43

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

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

Question 44

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

Question 45

The following code illustrates using HTML tags to format Rich Text:
=" Thank you for your order. Payment Notes: 105 deposit is
Due at time of booking. 50% nonrefundable deposit is due two weeks prior to
Departure date. The full balance is due 2 days prior to departure
Date. "
In the code 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 46

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

Question 47

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 48

The following code illustrates using HTML tags to format Rich Text:
=" Thank you for your order. Payment Notes: 105 deposit is
Due at time of booking. 50% nonrefundable deposit is due two weeks prior to
Departure date. The full balance is due 2 days prior to departure
Date. "
In the code 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 49

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

Question 50

The following code illustrates using HTML tags to format Rich Text:
=" Thank you for your order. Payment Notes: 105 deposit is
Due at time of booking. 50% nonrefundable deposit is due two weeks prior to
Departure date. The full balance is due 2 days prior to departure
Date. "
In the figure shown, how many line breaks are included?

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

Question 51

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

A) onedrive.com
B) microsoftonedrive.com
C) mydrive.com
D) one.com

Question 52

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

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

Question 53

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

Question 54

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

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

Question 55

The following code illustrates using HTML tags to format Rich Text:
=" Thank you for your order. Payment Notes: 105 deposit is
Due at time of booking. 50% nonrefundable deposit is due two weeks prior to
Departure date. The full balance is due 2 days prior to departure
Date. "
In the code 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

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

Question 57

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

Question 58

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 59

The following code illustrates using HTML tags to format Rich Text:
=" Thank you for your order. Payment Notes: 105 deposit is
Due at time of booking. 50% nonrefundable deposit is due two weeks prior to
Departure date. The full balance is due 2 days prior to departure
Date. "
In the code shown, how many line breaks are added after the first sentence?

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

Question 60

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

Question 61

Kristen wants to create a web app.  What software is required, and what is the purpose of each?

Question 62

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

Question 63

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

Question 64

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

Question 65

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

Question 66

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

Question 67

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 69

The template icons with a globe in the background are web app templates. ______________________

Question 70

You use the Modify Hyperlink dialog box to change the value of a Hyperlink. _____________________

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.