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