*Microsoft Access Final Review

The wildcard character that stands for any number of characters is the ____.

*-asterix

91. In large datasheets, you may want to ____ certain fields so that they remain on the screen at all times. 92. In the accompanying figure, "StateName" and "Price" are ____ names. 93. Bound controls exist only to describe or enhance the appearance of the form. 94. In the accompanying figure, the ____ tool will allow you to create a form by answering a series of questions provided by the Form Wizard dialog boxes. 95. When an image or control is selected in Design View, you can use ____, which are small squares at the corners of the selection box, to resize the image. 96. Which shortcut key moves focus to the previous field of the current record? 97. Which control is both a list box and a text box control? 98. Which is NOT a feature of Access reports? 99. Referential integrity prevents the creation of ____ records. 100. Which of the following comparison operators means "greater than"? 101. Which of the following is NOT available to you as you start Access? 102. In the accompanying figure, the ____ tool is used to navigate or move between different areas of the database. 103. Which Access object contains all of the raw dacalculations on groups of records)ta within the database? 104. Which data type stores only one of two values? 105. A(n) ____ is a saved object within the datasheet. 106. Which two sections can be added to a report if you group records? 107. The Group Header section prints ____. 108. The Spacing feature represents the space between controls. 109. Which command is used to copy a control from one report section to another? 110. Which form creation tool can you use to create a form from scratch in Form Design View? 111. The Report Footer section prints ____. 112. A query can be used to create calculated fields. 113. The Align button in the Sizing & Ordering Group is available on the ____ tab. 114. Filters are used to select a subset of records in a datasheet. 115. Which control is used to provide consistent descriptive text as you navigate from record to record? 116. The Group Footer section prints ____. 117. Which keystroke combination moves focus to the last field of the last record? 118. One way to select more than one control at a time in Report Design View is to click a control and press and hold ____ while clicking other controls. 119. To delete records from a query datasheet, click the record selector button to the left of the record, click the HOME tab, click the Delete button in the Records group, and click Yes. 120. In the accompanying figure, the first tool in the list creates a form from scratch in Form Design View. 121. Enter OR criteria on different Criteria rows in the query design grid. 122. A(n) ____ is a temporary view of the data that is removed when you close the datasheet. 123. Which of the following is NOT a bound control? 124. You can press an arrow key to move a selected control. 125. In a datasheet, which mode assumes that you are trying to change the value of a particular field? 126. Which form creation tool can you use to create a form by answering a series of questions provided by dialog boxes? 127. When referencing field names within an expression, surround the field name with ____ 128. ____ will find all records where there is any entry in the field, even if the entry is 0. 129. The wildcard character that stands for any single character is the ____. 130. Controls placed in this form section print once for every record. 131. You can add fields to a form in either Layout View or Design View. 132. To filter for comparative data, use the Filter By Selection. False ? 133. It would make sense to set the Tab Stop property of a text box that will not be used for data entry to No. 134. Deleting a field from a query also deletes it from the underlying table. 135. ____ refers to the space between the outer edge of the control and the data displayed inside the control. 136. Which report view's primary purpose is to quickly review the report without page breaks? 137. Portrait orientation is 8.5" wide by 13" tall. 138. Which report view's primary purpose is to allow you to modify report controls while reviewing live data? 139. The easiest way to filter the records for an exact match is to use Filter By Form. 140. Which of the following keys will help you delete unwanted data in Edit mode? 141. The question mark (?) is the wildcard character used to search for any single character. 142. On a form, text box controls display data from an underlying record source. 143. Which of the following comparison operators means "less than or equal to"? 144. Which control provides an easy way to initiate a command or run a macro? 145. For your report to fit on one page in a given orientation, you may need to move all of the controls within a given mark on the horizontal ____. 146. To add, delete, or change fields in a query, you use Query Design View. 147. In the accompanying figure, the ____ tool will create a form with one click, based on the selected table or query. 148. You use Query Design View to add ____ to limit the number of records shown in the resulting datasheet. 149. Which two properties are required for every field? 150. Which command can you use to move a control from one section to another on a report?

89. False 91. Freeze 92. Field 93. False (Unbound) 94. Form Wizard 95. Sizing handles 96. Shift-Tab 97. Combo box 98. (All are: Headers, footers, graphics and calculations on groups of records) 99. Orphan 100. > 101. Recalibrate an existing database 102. Navigation 103. Table 104. Yes/No 105. Query 106. Group Header and group Footer 107. Before every group of records 108. False (Padding) 109. Move, second, copy, duplicate? 110. Form design 111. End of the report 112. True 113. Arrange 114. True 115. Label 116. At every group of records 117. Control End 118. Shift 119. true 120. False (it's the 1st one) 121. True 122. Filter 123. Label 124. True 125. Edit 126. Form Wizard 127. [square brackets] 128. Is Not Null 129. ? (question mark) 130. Detail 131. True 132. Filter by form 133. true 134. False 135. Margin 136. Report View 137. False (8.5 x 11) 138. Layout View 139. False (filter by Selection) 140. Backspace 141. True 142. True 143. <= 144. Command button 145. ruler 146. True 147. Form 148. Criteria 149. Field Name and data Type 150. Cut

The following comparison operators means "not equal to"?

<>

86. Expressions must start with what character?

= equal sign

Which of the following is the correct expression to count the number of records using a field named City?

=COUNT([CITY])

Which of the following shows a calculated expression using appropriate syntax to subtotal a field called Quantity?

=sum([Quantity])

To find numbers greater than or equal to 500, use which comparison operator?

>=

88. The ________ is the wildcard character used to search for any single character.

? question mark

The Page Footer section prints ____.

At the bottom of every page.

The Page Header section prints ____.

At the top of every page (but below the Report Header on the first page)

Which data type links files created in other programs such as pictures or documents?

Attachment

26. Which data type is used for sequential integers controlled by Access?

Autonumber

Which of the following is NOT a common report embellishment?

Command Buttons?

____ are tests or limiting conditions you set to determine which records will be selected in a filter or query.

Criteria

Which editing keystroke deletes one character to the right of the insertion point?

Delete

25. The accompanying figure shows the database in ____ View.

Design

Which section prints once for every record?

Detail

In Navigation mode, press [Tab] or ____ to move to the next field within the same record.

Enter

T or F: A filter can be used to create calculated fields.

False

T or F: The tasks that can be accomplished by each of the various report views are mutually exclusive.

False

T or F: The purpose of a report is to provide an easy-to-use data entry interface.

False. The purpose of a report is to feed back information

In the accompanying figure, "StateName" and "StateAbbreviation" appear in the States ____ list.

Field

To move a field in the query design grid, click its ____, and then drag it left or right.

Field selector

To review a printout of a table before printing, on the ____ tab, click Print, and then click Print Preview.

File

The ____ button provides a list of values in the selected field that can be used to customize a filter.

Filter

Which Access object provides an easy-to-use data entry screen?

Form

____ refers to enhancing the appearance of the information.

Formatting

Which of the following is NOT a data type?

Formula

You can add a field as a grouping field in which pane?

Group, sort, total

Which shortcut key moves focus to the first field of the current record?

Home

You can insert a logo on a form using the ____ button in the Controls group.

Insert Image

To find all records where there is any entry in the field, even if the entry is 0, which criteria should you use?

Is not null

85. In the accompanying figure, the item with the infinity sign at one end and the number 1 at the other is called a(n) ____ line.

Link

Which control displays a list of possible data entries from which the user can choose?

List Box

A query datasheet is sometimes called a ____ of the data

Logical view

Which form creation tool can you use to build a form based on Multiple Items, Datasheet, or Split Form, for example?

More Forms

Tables, queries, and forms are examples of Access ____.

Objects

____ records are those on the many side of a relationship that do not have a match on the one side.

Orphan

Which section prints below the Report Header on page one?

Page Header

A group of related fields, such as all the demographic information for one customer, is called a(n) ____.

Record

____ integrity refers to a set of Access rules that govern data entry and helps to ensure data accuracy.

Referential

While editing a record, pressing [Esc] twice ____

Removes all change made to the record you are currently editing

You can click in the horizontal or vertical ____ to select all controls that intersect the selection line.

Ruler

Use the ____ command to save the current object with a new name.

Save As

The ____ button filters records that equal, do not equal, or are otherwise compared with the current value.

Selection

78. SQL stands for ____.

Structured query language

64. Criteria ____ are rules that specify how to enter criteria in a query.

Syntax

The _____ button helps you navigate to the first, previous, next, last or new record

Tab

Which control is used to create a three-dimensional aspect to a form?

Tab control

You can press ____ to move the focus through the controls of the form.

Tab or Enter

Which control, when it appears pressed, displays "yes" information?

Toggle?

87. You can apply more than one grouping order to a report.

True

By copying a query before starting to make modifications to it, you can avoid changing the original query by mistake.

True

Deleting a field from a form does not delete it from the underlying table or have any effect on the data contained in the field.

True

T or F :A query allows the selection of a subset of fields and records from one or more tables, then presents the selected data as a single datasheet.

True

T or F: A background image is an image that fills the entire form or report, appearing "behind" the other controls.

True

T or F: A form allows you to arrange the fields of a record in any layout so a database user can quickly and easily find, enter, edit, and analyze data.

True

T or F: A tab control is an unbound control.

True

T or F: Access reports can be created by selecting fields from one or more tables or queries.

True

T or F: Forms can be used to enter and edit data.

True

T or F: The Report Wizard automatically applies many formatting embellishments to a report.

True

T or F: When using a wizard, you can click the Back button to review previous dialog boxes.

True

T or F: You enter and edit data in a query datasheet in the same way you do in a table datasheet.

True

The same expression in different sections of a report produces different calculations.

True

You can both group and sort records on the same report.

True

You can rename labels in Report Layout View.

True

Grouping means to sort records plus provide extra report sections.

True(header/footer sections).

If a report is too wide, you will see a green error indicator in the ____ corner of the report.

Upper-left

When you double-click a field in a field list in Query Design View, it is ____

added to the next available position in the query grid

The Report Header section prints ____.

at the top of the first page

Which of the following would most likely be used to display a Yes/No field on a form?

check box

Each item on the form is called a

control

Access saves ____ automatically as you move from record to record.

data

Calculated expressions start with an

equal sign

A specific category of data such as a customer's name, city, state, or phone number is called a(n) ____.

field

24. The Form Wizard prompts you for information it needs to create a form, such as the ____ for the form.

fields, title, and layout

The ____ tool will create a form from scratch in Form Layout View.

form Design

Controls placed in the ____ form section print only once at the top of the printout.

form header

Which data type stores Web addresses?

hyperlink

____ View lets you make some design changes to a form while you are browsing the data.

layout

A join line is also called a(n) ____ line.

link

Query Design View presents the fields you can use for that query in small windows called field ____.

lists

Which report view's primary purpose is to review each page of the entire report as it will appear if printed?

print preview

A ____ box is an outline box you create by dragging the pointer in Report Design View.

selection

____ View provides the most options for defining fields.

table design

Which of the following would NOT be considered a graphic image?

text