Access Exam

65. MC: You can click in the horizontal or vertical ____ to select all controls that intersect the selection line. A . ruler B . section header C . launcher D . command line

A. ruler

19. MC: A group of related fields, such as all the demographic information for one customer, is called a(n) ____. A . record B . table C . database D . object

A. record

55. MC: The Page Footer section prints ____. A . at the bottom of every page B . at the end of the entire report C . at the end of the first and last pages in the report D . once for every group of records

A. at the bottom of every page

15. MC: You use Query Design View to add ____ to limit the number of records shown in the resulting datasheet. A . criteria B . posts C . versioning D . indices

A. criteria

39. MC: In the accompanying figure, the ____ tool will create a form with one click, based on the selected table or query. A . first B . second C . third D . fifth

A. first

41. MC: The Align button in the Sizing & Ordering Group is available on the ____ tab. A . ARRANGE B . OPTIONS C . HOME D . FORMAT

A. Arrange

46. MC: Which of the following would most likely be used to display a Yes/No field on a form? A . Check box B . Command button C . Combo box D . Label

A. Check box

4. MC: Access saves ____ automatically as you move from record to record. A . data B . queries C . tables D . All of the above.

A. Data

45. MC: Which of the following is NOT a form view? A . Data B . Form C . Layout D . Design

A. Data

21. MC: In a datasheet, which mode assumes that you are trying to change the value of a particular field? A . Edit mode B . Navigation mode C . Update mode D . Form mode

A. Edit mode

27. MC: Which two properties are required for every field? A . Field Name and Data Type B . Field Name and Field Size C . Data Type and Format D . Field Size and Format

A. Field Name and Data Type

3. MC: A(n) ____ is a temporary view of the data that is removed when you close the datasheet. A . filter B . query C . grid D . sort

A. Filter

63. MC: Which two sections can be added to a report if you group records? A . Group Header and Group Footer B . Group Header and Detail C . Group Footer and Detail D . Group Summary and Detail

A. Group Header and Group Footer

36. MC: ____ View lets you make some design changes to a form while you are browsing the data. A . Layout B . Design C . Browse D . Data

A. Layout

2. MC: A(n) ____ is a saved object within the datasheet. A . query B . filter C . find D . union

A. Query

53. MC: 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. A . Shift B . Esc C . F5 D . Alt

A. Shift

5. MC: Criteria ____ are rules that specify how to enter criteria in a query. A . Syntax B . Formatting C . Sorting D . Filter by Form

A. Syntax

42. MC: When referencing field names within an expression, surround the field name with ____. A . [square brackets] B . {curly brackets} C . (parentheses) D . "quotation marks"

A. [square brackets]

37. MC: Expressions must start with what character? A . [ left square bracket B . = equal sign C . ( left parenthesis D . : colon

B. = equal sign

11. MC: The accompanying figure shows the database in ____ View. A . Criteria B . Design C . Field D . None of the above.

B. Design

23. MC: Which Access object provides an easy-to-use data entry screen? A . macro B . form C . table D . module

B. Form

26. MC: Which of the following is NOT a data type? A . Number B . Formula C . Date/Time D . Short Text

B. Formula

1. MC: A join line is also called a(n) ____ line. A . query B . link C . connection D . objectivity

B. Link

8. MC: Query Design View presents the fields you can use for that query in small windows called field ____. A . glossaries B . lists C . links D . catalogs

B. Lists

10. MC: The ____ button filters records that equal, do not equal, or are otherwise compared with the current value. A . Comparative B . Selection C . Comparison D . Advanced

B. Selection

56. MC: The Page Header section prints ____. A . at the top of the first page B . at the top of every page (but below the Report Header on the first page) C . before every group of records D . after every group of records

B. at the top of every page (but below the Report Header on the first page)

13. MC: The wildcard character that stands for any single character is the ____. A . ampersand (&) B . question mark (?) C . exclamation mark (!) D . caret ()

B. question mark (?)

20. MC: A specific category of data such as a customer's name, city, state, or phone number is called a(n) ____. A . object B . record C . field D . table

C. Field

6. MC: In the accompanying figure, "StateName" and "Price" are ____ names. A . table B . report C . field D . query

C. Field

60. MC: Which report view's primary purpose is to allow you to modify report controls while reviewing live data? A . Report View B . Print Preview C . Layout View D . Design View

C. Layout view

44. MC: Which form creation tool can you use to build a form based on Multiple Items, Datasheet, or Split Form, for example? A . Form Design B . Blank Form C . More Forms D . Form Wizard

C. More Forms

25. MC: Which is NOT true about Access? A . It can be used to create forms B . It relates lists of information in a relational database. C . Reporting is limited to 20 saved reports. D . Multiple users can simultaneously enter and update data within Access.

C. Reporting is limited to 20 saved reports

22. MC: Which Access object contains all of the raw data within the database? A . query B . form C . table D . module

C. table

38. MC: In the accompanying figure, the ____ tool will create a form from scratch in Form Layout View. A . first B . second C . third D . fourth

C. third

59. MC: Which of the following shows a calculated expression using appropriate syntax to subtotal a field called Quantity? A . =Sum(Quantity) B . =Sum[Quantity] C . =Sum{Quantity} D . =Sum([Quantity])

D. =Sum([Quantity])

14. MC: To find numbers greater than or equal to 500, use which comparison operator? A . <> B . <= C . >> D . >=

D. >=

58. MC: Which command is used to copy a control from one report section to another? A . Move B . Second C . Duplicate D . Copy

D. Copy

57. MC: Which command can you use to move a control from one section to another on a report? A . Move B . Place C . Adjust D . Cut

D. Cut

62. MC: Which section prints once for every record? A . Group Header B . Group Footer C . Report Header D . Detail

D. Detail

64. MC: You can add a field as a grouping field in which pane? A . Properties B . Field List C . Toolbox D . Group, Sort, and Total

D. Group, Sort, and Total

47. MC: You can insert a logo on a form using the ____ button in the Controls group. A . Graphic Art B . Art C . Graphic Image D . Insert Image

D. Insert Image

7. MC: 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. A . query B . objectivity C . connection D . link

D. Link

18. MC: ____ integrity refers to a set of Access rules that govern data entry and helps to ensure data accuracy. A . Hierarchical B . Network C . Schematic D . Referential

D. Referential

28. MC: While editing a record, pressing [Esc] twice ____. A . deletes the current field B . deletes the current datasheet C . removes all data from the current record D . removes all changes made to the record you are currently editing

D. Removes all changes made to the record you are currently editing

61. MC: Which report view's primary purpose is to quickly review the report without page breaks? A . Print Preview B . Layout View C . Design View D . Report View

D. Report View

9. MC: SQL stands for ____. A . Structured Query Lingo B . Standard Query Lingo C . Standard Query Language D . Structured Query Language

D. Structured Query Language

43. MC: Which control is used to create a three-dimensional aspect to a form? A . Command button B . Toggle button C . Rectangle control D . Tab control

D. Tab control

54. MC: The Group Header section prints ____. A . at the top of the first page of the report B . at the top of every page C . once for every record D . before every group of records

D. before every group of records

24. MC: Which is NOT a feature of Access reports? A . headers B . footers C . calculations on groups of records D . easy-to-use data entry screen

D. easy-to-use data entry screen

35. MC: ____ records are those on the many side of a relationship that do not have a match on the one side. A . indexed B . split C . unlicensed D . orphan

D. orphan

40. MC: Referential integrity prevents the creation of ____ records. A . indexed B . split C . unlicensed D . orphan

D. orphan

12. MC: The button in the accompanying figure ____. A . sorts records in descending order B . sorts records in ascending order C . helps you select a single record or all records in a datasheet D . removes the current sort order

D. removes the current sort order

16. T/F: The asterisk (*) is the wildcard character used to search for any single character.

False

30. T/F: If a number has already been incremented beyond 1 for a first record in a field of the AutoNumber data type, the AutoNumber data type can no longer work as intended.

False

51. T/F: In the accompanying figure, the first tool in the list creates a form from scratch in Form Design View.

False

17. T/F: The question mark (?) is the wildcard character used to search for any single character.

True

29. T/F: A subdatasheet shows the records on the "many" side of a one-to-many relationship.

True

31. T/F: More than one person can be entering, updating, and using an Access database at the same time.

True

32. T/F: Tables contain all of the raw data in the database.

True

33. T/F: The linking field on the "many" side of a one-to-many relationship is called the foreign key field.

True

34. T/F: Values in an AutoNumber field are automatically created by Access.

True

48. T/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

49. T/F: A tab control is an unbound control

True

50. T/F: 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

52. T/F: It would make sense to set the Tab Stop property of a text box that will not be used for data entry to No.

True

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

True

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

True

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

True