Access 2010 Test Questions

Access 2010 Test Questions

1. Which software program is used to create a database on a computer, add, change, and delete data in the database, and create queries, forms, and reports using the data in the database?

1. Microsoft Access 2010
2. Microsoft Excel 2010
3. Microsoft OneNote 2010
4. Microsoft Outlook 2010

Answer: A

2. Which view in Access 2010 contains the command to create a new database?

1. Datasheet
2. Design
3. File
4. Backstage

Answer: D

3. What is the purpose of creating and then saving a database before it is completed?

1. To prevent data loss
2. To create a backup copy
3. To enable Access to automatically save data as changes are made
4. To ensure that a user has selected an appropriate file name

Answer: C

4. What appears at the top of the Access work area to indicate objects that are open?

1. Ribbons
2. Object commands
3. Buttons
4. Object tabs

Answer: D

5. Which window component in Access 2010 enables a user to navigate through different portions of an object in a work area?

1. Scroll bars
2. Status bar
3. Ribbon
4. Title bar

Answer: A

6. In Access 2010, which area provides indicators and buttons based on information you type or tasks that are performed?

1. Scroll bars
2. Status bar
3. Ribbon
4. Title bar

Answer: B

7. Which of the following is considered the control center for Access 2010 and provides easy, central access to the commands needed to perform various tasks?

1. Scroll bars
2. Status bar
3. Ribbon
4. Title bar

Answer: C

8. Which Access 2010 feature provides on-screen notes containing the name of the command, available keyboard shortcuts, a description of the command, and directions for getting help using the command?

1. Tool Tag
2. Enhanced ScreenTip
3. ToolTip
4. Screen Notes

Answer: B

9. What is the name of the small arrow in the lower right corner of a ribbon group that provides access to additional options for the group?

1. Group Launcher
2. Group Options
3. Dialog Box Options
4. Dialog Box Launcher

Answer: D

10. What is the name of the area located in the top left corner of the Access 2010 program window that provides convenient, one-click access to frequently used commands?

1. Dialog Box Launcher
2. Shortcut Menu
3. Quick Access Toolbar
4. Quick Access Menu

Answer: C

11. Which key is used to display a KeyTip in Access 2010?

1. Ctrl
2. Shift
3. Alt
4. Tab

Answer: C

12. When a user of Access 2010 right-clicks an object, what is the name of the list of frequently used commands that displays?

1. Dialog Box Launcher
2. Shortcut Menu
3. Quick Access Toolbar
4. Quick Access Menu

Answer: B

13. Which type of database consists of a collection of tables, each of which contains information on a specific subject?

1. Relational
2. Interactive
3. Collaborative
4. Independent

Answer: A

14. In a table, which of the following contains information about a given person, product, or event?

1. Cell
2. Column
3. Record
4. Field

Answer: C

15. In a table, what contains a specific piece of information within a row?

1. Cell
2. Column
3. Record
4. Field

Answer: D

16. In a table, which is a way of exclusively identifying each record in the database?

1. Unique marker
2. Unique identifier
3. Primary marker
4. Primary category

Answer: B

17. In a table, which data type contains only monetary data?

1. Cash
2. Text
3. Currency
4. Number

Answer: C

18. Which term refers to storing the same field in more than one location in a database?

1. Redundancy
2. Repetition
3. Replication
4. Recurrence

Answer: A

19. Which view presents information in rows and columns similar to those in a spreadsheet?

1. Design
2. Datasheet
3. File
4. Backstage

Answer: B

20. Which view displays the area used to create a table or to modify the structure of a table?

1. Design
2. Datasheet
3. File
4. Backstage

Answer: A

21. Which is a mandatory selection when adding new fields to a table?

1. Input mask
2. Field size
3. Field name
4. Description

Answer: C

22. Which ribbon contains the command to change the table view?

1. Table Tools Layout
2. Table Tools Format
3. Table Tools Table
4. Table Tools Fields

Answer: D

23. After designing a table, what must a user do before exiting it?

1. Add field descriptions
2. Save the table
3. Spell check the table
4. Verify the table fields

Answer: B

24. In Table Design view, which area contains commands for designating a specific field size?

1. Field Properties
2. Table Tools
3. Field Options
4. Table Controls

Answer: A

25. Where is the command to undo your most recent change in Access 2010?

1. Shortcut Menu
2. Home Ribbon
3. Quick Access Toolbar
4. Enhanced ScreenTip

Answer: C

26. In Datasheet view, what does the asterisk (*) that appears to the left of an empty record indicate?

1. Delete record
2. New record
3. Selected record
4. Current record

Answer: B

27. In Datasheet view, how does a user delete a record?

1. Double-click the record selector
2. Click the record selector and choose Delete from the Create Ribbon
3. Double-click the record selector and choose Delete from the Database Tools Ribbon
4. Click the record selector and choose Delete from the Home Ribbon

Answer: D

28. When opening an Access 2010 database, why would a security warning appear below the ribbon?

1. To notify you that some content is disabled due to your computer’s security settings
2. To notify you of a possible invasion of privacy on your computer
3. To notify you that the database is infected with a virus
4. To notify you that important content in the database has been deleted

Answer: A

29. When a table is open in Access 2010, what are the buttons located in the lower left corner of the screen used for?

1. Database navigation
2. Table navigation
3. Record removal
4. Access Object navigation

Answer: B

30. When viewing a table in Datasheet view, what must a user do to make all data in the entire field visible?

1. Rebuild the table
2. Refresh the table
3. Resize the column
4. Resize the row

Answer: C

31. Which print orientation utilizes the width of a page?

1. Landscape
2. Photographic
3. Backdrop
4. Portrait

Answer: A

32. Which print orientation utilizes the height of a page?

1. Landscape
2. Photographic
3. Backdrop
4. Portrait

Answer: D

33. Where is the command for creating a new table from Table Design view?

1. File tab
2. Home Ribbon
3. Create Ribbon
4. Database Tools Ribbon

Answer: C

34. Which feature of Access 2010 corrects common mistakes users make when entering text into a cell?

1. AutoSpell
2. AutoCorrect
3. AutoSelect
4. Spell Check

Answer: B

35. When data is created in Excel 2010 for import to Access 2010, which format is the data stored in so that the first row contains column headings and the remaining rows contain the data?

1. Excel list
2. Text list
3. Excel chart
4. Excel table

Answer: A

36. What process occurs when external data is added to Access and copied to a database table?

1. Exporting
2. Pasting
3. Compact
4. Importing

Answer: D

37. What do you use to ask questions that will retrieve data from the database?

1. Criteria
2. Queries
3. Benchmarks
4. Reports

Answer: B

38. What type of query is used when no restrictions, calculations, or special order must be applied to the data?

1. Simple query
2. Crosstab query
3. Duplicates query
4. Unmatched query

Answer: A

39. What object may be used in a simple query?

1. Macro
2. Report
3. Form
4. Table

Answer: D

40. How is a query stored after it is created and saved?

1. As an image
2. As a database object
3. As a database macro
4. As database code

Answer: B

41. In a query, what condition must the records included in the result satisfy?

1. Measure
2. Benchmark
3. Criterion
4. Principle

Answer: C

42. Which is a formatted document typically used for data entry in Access 2010?

1. Query
2. Form
3. Table
4. Report

Answer: B

43. Which type of database object is typically used to print data?

1. Query
2. Form
3. Table
4. Report

Answer: D

44. Which view previews a report on screen but prevents changes to the report from being made?

1. Report view
2. Print Preview
3. Layout view
4. Design view

Answer: A

45. Which view previews a report on screen and allows changes to be made to the report?

1. Report view
2. Print Preview
3. Layout view
4. Design view

Answer: C

46. Which view is used to make changes to a report but does not display the actual report?

1. Report view
2. Print Preview
3. Layout view
4. Design view

Answer: D

47. Which ribbon contains the commands to insert or delete new rows and columns in a report?

1. Report Layout Tools Design
2. Report Layout Tools Arrange
3. Report Layout Tools Format
4. Report Layout Tools Page Setup

Answer: B

48. Which ribbon contains the commands to remove, add, or resize columns in a report?

1. Report Layout Tools Design
2. Report Layout Tools Arrange
3. Report Layout Tools Format
4. Report Layout Tools Page Setup

Answer: A

49. Which group on the Report Layout Tools Design Ribbon contains the command to include an automatic calculation on a report?

1. Themes
2. Controls
3. Tools
4. Grouping & Totals

Answer: D

50. Which refers to file details used to help organize and identify a database?

1. Keywords
2. Metatags
3. Properties
4. Parts

Answer: C

51. Which contains the command to view or change information about a database file?

1. File tab
2. Home Ribbon
3. Database Tools Ribbon
4. Create Ribbon

Answer: A

52. Which term describes the process of periodically making a copy of a database to protect it in the event of failure or damage?

1. Recovery
2. Backing up
3. Installation
4. Compacting

Answer: B

53. What is the process of returning a damaged or failed database to its correct state called?

1. Recovery
2. Backing up
3. Installation
4. Compacting

Answer: A

54. What term describes the process of repairing and removing wasted space from a database?

1. Recovery
2. Backing up
3. Installation
4. Compacting

Answer: D

55. Which Access 2010 function key is a shortcut to Microsoft Office Access Help?

1. F7
2. F1
3. F3
4. F5

Answer: B

56. Which view allows a user to specify fields, criteria, sorting, and calculations when creating a query?

1. Datasheet
2. Design
3. File
4. Backstage

Answer: B

57. What are symbols that represent any character or combination of characters and are commonly used to specify the criterion in a query?

1. Wildcards
2. Replacements
3. Common denominators
4. Substitutes

Answer: A

58. Which character is used in a criterion to represent a collection of characters?

1. Exclamation point (!)
2. Asterisk (*)
3. Question mark (?)
4. Ampersand (@)

Answer: B

59. Which character is used in a criterion to represent an individual character?

1. Exclamation point (!)
2. Asterisk (*)
3. Question mark (?)
4. Ampersand (@)

Answer: C

60. Which check box in query Design view is used to include a particular field in a criterion while not displaying the field in the query results?

1. Display
2. Present
3. Include
4. Show

Answer: D

61. Which query type is flexible and prompts the user for input whenever it is used?

1. Top value
2. Parameter
3. Update
4. Make table

Answer: B

62. Which type of operator enables a user to equate two values in a query criterion?

1. Assessment
2. Evaluation
3. Comparison
4. Appraisal

Answer: C

63. Which operator is used when each individual criterion must be true in order for the compound criterion to be true?

1. Or
2. Nor
3. Plus
4. And

Answer: D

64. Which operator must be used for a compound criterionto be true if either criterion provided is true?

1. Or
2. Nor
3. Plus
4. And

Answer: A

65. What ensures that a query result appears in a specific order?

1. Filtering
2. Sorting
3. Ordering
4. Placing

Answer: B

66. Which property on a query properties sheet must be modified to eliminate duplicates in a query?

1. Duplicate
2. Replication
3. Identical
4. Unique Values

Answer: D

67. Which query allows a user to quantify query results by displaying only a specific number of records or a percentage of records?

1. Top value
2. Parameter
3. Update
4. Make table

Answer: A

68. What must be done to include multiple tables that contain identical values in matching fields?

1. Relating
2. Intersecting
3. Joining
4. Linking

Answer: C

69. What is the Access 2010 default join that finds records from two tables with identical values in matching fields?

1. Outer
2. Inner
3. Left outer
4. Right outer

Answer: B

70. What type of join displays all records from one table and the common records from another table?

1. Outer
2. Inner
3. Left outer
4. Right outer

Answer: A

71. What is drawn between two tables in the query Design view to illustrate matching fields and indicate that the tables are related?

1. Relationship connector
2. Table link
3. Join line
4. Table line

Answer: C

72. How is the Join Properties dialog box easily accessed in query Design view?

1. Double-click the join line
2. Right-click the join line and select Join Properties from the Shortcut Menu
3. Select Join Properties from the Query Tools Layout Ribbon
4. Select Properties from the Quick Access Toolbar

Answer: B

73. What is the process of copying data from an Access database for use in another application called?

1. Exporting
2. Importing
3. Transferring
4. Distributing

Answer: A

74. Which file type places each record on a separate line and uses a special character to separate fields?

1. Bound
2. Defined
3. Delimited
4. Isolated

Answer: C

75. Which term refers to a field that can be computed from other fields in a database?

1. Analyzed
2. Calculated
3. Evaluated
4. Estimated

Answer: B

76. Which dialog box accessed through query Design view is used to manually enter an expression for a field?

1. Properties
2. Build
3. Create
4. Zoom

Answer: D

77. Which type of operation performs mathematical functions, such as MAX, MIN, or COUNT, on a group of records?

1. Statistical
2. Geometric
3. Aggregate
4. Algebraic

Answer: C

78. Which is the process of categorizing records that share a common characteristic?

1. Sorting
2. Grouping
3. Filtering
4. Ordering

Answer: B

79. What type of query calculates a statistic for data that is grouped by two different types of information?

1. Update
2. Parameter
3. Action
4. Crosstab

Answer: D

80. Which area appears on the left side of Access 2010 windows and displays a list of objects available in the database?

1. Objects Pane
2. Database Pane
3. Navigation Pane
4. List Pane

Answer: C

81. What type of form enables a user to simultaneously view both simple form and database views of the data?

1. Split
2. Dual
3. Divided
4. Distributed

Answer: A

82. Which command on the Home Ribbon is used to search for records that satisfy a specific criterion?

1. Search
2. Find
3. Examine
4. Research

Answer: B

83. Which Access 2010 feature enables a user to display one or more records that satisfy a specific criterion?

1. Sorting
2. Finding
3. Searching
4. Filtering

Answer: D

84. Which command on the Home Ribbon is used to search a field for a collection of selected characters?

1. Sort Ascending
2. Advanced Filter
3. Selection
4. Toggle Filter

Answer: C

85. Which command on the Access 2010 Home Ribbon is used to change the display between filtered and unfiltered records in a table?

1. Sort Ascending
2. Advanced Filter
3. Selection
4. Toggle Filter

Answer: D

86. When a database is created, what is defined when names and data types are assigned to all data fields in a table?

1. Structure
2. Definition
3. Design
4. Theme

Answer: A

87. Which type of field enables a user to select from a list of values when updating the contents of a field?

1. Calculated
2. Attachment
3. Lookup
4. Hyperlink

Answer: C

88. What type of query enables a user to make the same change to all records satisfying a certain criterion?

1. Update
2. Append
3. Action
4. Make table

Answer: A

89. What type of query enables a user to add the results of a query to an existing table in a database?

1. Update
2. Append
3. Action
4. Make table

Answer: B

90. What type of query enables a user to add the results of a query to a new table in a database?

1. Update
2. Append
3. Action
4. Make-Table

Answer: D

91. What type of query is used to remove at once all records that meet specific criteria?

1. Update
2. Action
3. Delete
4. append

Answer: C

92. What are the rules that a user must follow when entering data into a table?

1. Text
2. Validation
3. Criterion
4. Properties

Answer: B

93. What occurs when a user violates a rule while entering data in a table?

1. Message appears
2. Computer beeps
3. Database shuts down
4. Table closes

Answer: A

94. What value does Access 2010 display in a particular field on screen before a user begins adding a record?

1. Automatic entry
2. Correct value
3. Default value
4. Suggested information

Answer: C

95. Which property is modified to affect the way data appears in a field?

1. Font
2. Text
3. Design
4. Format

Answer: D

96. Which dialog box offers a variety of methods for changing the way a table appears in datasheet view?

1. Text Formatting
2. Datasheet Formatting
3. Table Formatting
4. Font Formatting

Answer: B

97. Which ensures that the value of a foreign key must match that of another table’s primary key (or unique identifier)?

1. Referential integrity
2. Validation rules
3. Table properties
4. Input mask

Answer: A

98. Which type of relationship means that a record in the first table is related or matches more than one record in the second table?

1. One to one
2. Many to many
3. One to many
4. One to any

Answer: C

99. Within a related table, what type of datasheet appears as an expandable item in front the record to which it is related?

1. Linked
2. Subdatasheet
3. Attached
4. Expandable

Answer: B

100. What area within the datasheet enables a user to modify the order in which data appears?

1. Field selector drop-down arrow
2. Row selector button
3. Sort button
4. Ordering command

Answer: A

101. When viewing a report, where does the subtotal related to the group of records appear?

1. Group header
2. Record header
3. Detail section
4. Group footer

Answer: D

102. Which offers a quick, step-by-step process for creating a report in Access 2010?

1. Report dialog box
2. Report Guides
3. Report Wizard
4. Design view

Answer: C

103. Which is divided into various sections to help clarify the presentation of database data?

1. Report
2. Form
3. Table
4. Query

Answer: A

104. What are the objects that appear in a report called?

1. Fields
2. Controls
3. Switches
4. Sections

Answer: B

105. Which of the following is used to display data that comes from the database in a report?

1. Calculated controls
2. Sections
3. Bound controls
4. Unbound controls

Answer: C