Access 2000 Chapter 5-7

Front 1

Which program stars when you click a URL value for a Hyperlink field?

Back 1

Web browser

Front 2

What is the difference between opening a query and applying a query to a form?

Back 2

Opening a query runs the query and displays the results in Datasheet view. Applying a query to a form opens the query and displays the results in a form.

Front 3

What is a data access page?

Back 3

A data access page is a dynamic HTML page that you can open witha Web browser to view or update current data in an Access database.

Front 4

What is the difference between a bound control and an unbound control?

Back 4

A bound control is linked to a field in the underlying table or query; an unbound control is not.

Front 5

What data type is the primaty key when you let Access assign a primary key with the Import HTML wizard?

Back 5

AutoNumber

Front 6

What is the purpose of Filter By Form ?

Back 6

Filter By Form finds records that match multiple selection criteria using the same Access logical and comparison operators that you use in queries.

Front 7

Describe the seven sections in an access report.

Back 7

1. The Report Header section appears once at the beginning of a report. 2. The Page Header section appears at the top of each page of a report. 3. The Group Header section appears once at the beginning of a new group of records. 4. The Detail section appearsonce for each record in the underlying table or query. 5. The Group Footer section appears once ath the end of a group of records. 6. The Report Footer section appears once at the end of a report. 7. The Page footer section appears at the bottom of each page of a report.

Front 8

When do you use a parameter query?

Back 8

Use a parameter query when you want the user to be prompted to enter the selection criteria when the query runs.

Front 9

What does the field value of a hyperlink field represent?

Back 9

A hyperlink to another object

Front 10

How do you resize a control?

Back 10

Select the control, position the pointer on a sizing handle, and then click and drag the pointer

Front 11

If you modify a linked object, in what program do you make the changes?

Back 11

You use the source program in which the object was originally created.

Front 12

The ___________ Function lets you assign one value toa calculated field if a condition is true and a second if the condition is false.

Back 12

IIf

Front 13

What is the World Wide Web?

Back 13

The World Wide Web is a collection of HTML documents stored on the Web servers linked through the Internet.

Front 14

How do you change a label name?

Back 14

Right-click the label, click properties on the shortcut menu, click the format tab, edit the existing label in the caption text box or double-click it to select the current value, and then type a new caption.

Front 15

What is a grouped data acess page?

Back 15

A grouped data access page is a data access page that uses two or more group levels to display information from general catagories to specific details. You can view data on grouped data access pages, but you can't add, change, or delete data on them.

Front 16

How do you reuse a filter in the future?

Back 16

Save the filter as aa query, and then apply the query to a form.

Front 17

What is a theme?

Back 17

A theme is a predefined style for a data access page.

Front 18

How do you insert a picture, created using another software program, in a form?

Back 18

Open the form in Design veiw, click the Image button on the toolbar, position the pointer at the location for the upper-left corner of the picture, click the left mouse button, select the picture file, and then click OK.

Front 19

How do you insert a page number in a Page Header section?

Back 19

Click Insert on the menu bar; click Page Numbers; specify the format, position, and alignment of the page number; and then click OK.

Front 20

How do you right-align a goup of labels?

Back 20

Click a label, press and hold down the Shift key and click the other labels, click Format on the menu bar, point to Align, and then click Right

Front 21

Why might you want to hide duplicate values ina report that includes groups?

Back 21

Hiding duplicate values makes the report easier to read; duplicate values clutter the report.

Front 22

How do you move a control and its label together?

Back 22

Position the pointer anywhere on the border of the control, and then drag the control and its attached label box.

Front 23

When you insert an object in a report or form using the Insert Object dialog box how do you specify that the object is to be linked rather than embedded?

Back 23

Insert the object froma file and and select the Link check box.

Front 24

What is the Form Header section?

Back 24

The Form Header section lets you add titles, instructions, command buttons, and other information to the top of your form.

Front 25

What is the maximum number of conditional formats you can define for a control?

Back 25

Three

Front 26

How do you negate a selection criterion?

Back 26

Use the Not logical operator to negate a condition.

Front 27

What does the Report window in Design view have in common with the Form window in Design view? How do the two differ?

Back 27

The report window in Design view has many of the same components as the Form window in Design view, including a properties button, a fiels list button, and a toolbox button on the toolbar. Both windows also have horizantal and vertical rulers, a grid, and a Formating toolbar. Unlike the Form window in Design view , which initially displays a Page Header section and a Page Footer section.

Front 28

Decribe how you would use a control wizard to add a tab control to a form.

Back 28

Open the form in Design Veiw , click the Tab Control tool on the toolbox, position the pointer in the form at the location for the upper-left corner of the tab control, and then click the left mouse button.

Front 29

What is the caption property for an object , and when is would you change it?

Back 29

The caption property for an object determines the text displayed for the object. You can change the Caption property value for an object when the default value is difficult to read or understand.

Front 30

A(n) ___________ is a predefined format you use to enter data in a field

Back 30

input mask

Front 31

What is OLE?

Back 31

OLE stands for the object linking and embedding;a program that supports OLE can create objects that can be embedded or linked in another program.

Front 32

What is a subdatasheet?

Back 32

If two tables hava a one to many relationship, when you display the primary table in Datasheet view, you can use a subdatasheet to display ans edit the records from the related table.

Front 33

How do you calculate group totals and overall totals?

Back 33

Place a textbox in the Group Footer or Report Footer section. In the textbox enter the expression =Sum([fieldname]), where field name is the name of the field you want to total.

Front 34

What is the pupose of the asterisk(*)in a pattern match query?

Back 34

The asterisk is a wildcard that represents any string of characters in a pattern match query.

Front 35

How do you export a table or the results of a query to Excel?

Back 35

Select the table or query in the database window and open the table or query in the Datasheet view, click Tools on the menu bar , point to office links, and then click Analyze It with MS Excel.

Front 36

When do you use the In comparison operator?

Back 36

Use the In comparison operator to define a condition with two or more values.

Front 37

What is the purpose of a Web Browser?

Back 37

A Web Browser is a program used to view HTML documents.

Front 38

What is a lookup wizard field

Back 38

A lookup wizard filed lets you select a value froma list of possible values, making data entry easier.

Front 39

How do you view a hyperlink that is named in a hyperlink field?

Back 39

Click on the hyperlink field value to open the hyperlinked document or object.

Front 40

Which comparison operator is used to select records based on a specific pattern?

Back 40

Like

Front 41

What do you type in a text box to tell Access to print the current date?

Back 41

Type =Date() in the text box

Front 42

What is an HTML template?

Back 42

An HTML template is a file that contains HTML instructions for creating a Web Page with both text and graphics, together with special instructions that will tell Access where to place the Access data on the page.

Front 43

How do you Left-Align objects in a column?

Back 43

Click on an object, hold down the Shift Key and click the other objects, release the Shift Key, click Format on the menu bar, point to Align, and then click Left.

Front 44

What is a grouping field?

Back 44

A grouping field is a field from the underlying table or query by which records are grouped in a report.

Front 45

What is a hyperlink?

Back 45

A hyperlink links one web document to another.

Front 46

What types of HTML formats can Access import as table data?

Back 46

Access can import HTML data that is formatted as a table or as a list.

Front 47

What are two ways to update links to linked objects in a report?

Back 47

Each linked object is updated automatically when the report is opened. To update links manually, click Edit on the menu bar, click OLE/DDE Links, select the link or links to update, Click update now, and then click close.

Front 48

What is the difference between embedding and linking?

Back 48

An embedded object preserves its connection to the program in which it was created. Any changes you make to the object are reflected in the Access embedded file not in the original file. A linked object preserves its connection to the original source file. Any changes you make in the object aare reflected in both the linked file in Access and the original file.

Front 49

What is HTML

Back 49

HTML stands for Hypertext Markup Langugage, the language used to create World Wide Web Documents.

Front 50

What is the function of the Sorting and Grouping button?

Back 50

The Sorting and Grouping button opens the Sorting and Grouping dialog box. which allows you to specify sorting and frouping fields for a report.

Front 51

When do you use the Textbox Tool?

Back 51

Use the Textbox Tool to create a text box in a form or report.

Front 52

What is a custom report?

Back 52

A custom report is a report you make by modifying a report created by Auto Report or the report wizard, or by creating a report from scratch in Design view.

Front 53

What is the purpose of the Zoom button in Print Preview?

Back 53

Clicking the Zoom button changes the size of the page displayed in Print Preview.

Front 54

In the insert Hyperlink dialog box, what are you three choices for the hyperlink filed value?

Back 54

a file, a URL, an object in the opened Access database.

Front 55

Why might you want to embed or link an object in an Access report?

Back 55

You embed or link objects in an Access report to include objects created by other programs, including objects that you cannot create in Access(for example, charts).