Microsoft Access

Microsoft Access

1. What is the purpose of creating and saving a database before it is completed?
A. To prevent data loss
B. To create a backup copy
C. To enable Access to automatically save data as changes are made
D. To ensure that a user has selected an appropriate file name

2. 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?
A. Group Launcher B. Group Options C. Dialog Box Options D. Dialog Box Launcher

3. Which view in Access 2010 contains the command to create a new database?
A. Datasheet B. Design C. File D. Backstage

4. Which is a mandatory selection when adding new fields to a table?
A. Input mask B. Field Size C. Field name D. Description

5. Which Ribbon contains the commands to insert or delete new rows and columns in a Report?
A. Report Layout Tools Design B. Report Layout Tools Arrange
C. Report Layout Tools Format D. Report Layout Tools Page Setup

6. Which window component in Access 2010 enables a user to navigate through different portions of an object in a work area?
A. Scroll bars B. Status bar C. Ribbon D. Title bar

7. Which view is used to make changes to a Report but does not display the actual Report?
A. Report view B. Print Preview C. Layout view D. Design view

8. 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?
A. Microsoft Access 2010 B. Microsoft Excel 2010
C. Microsoft OneNote 2010 D. Microsoft Outlook 2010

9. In a table, what contains a specific piece of information within a row?
A. Cell B. Column C. Record D. Field

10. What is the process of returning a damaged or failed database to its correct state called?
A. Recovery B. Backing up C. Installation D. Compacting

11. Which view presents information in rows and columns similar to a spreadsheet?
A. Design B. Datasheet C. File D. Backstage

12. Which print orientation displays the printout across the 8.5 inch width of the page?
A. Landscape B. Photographic C. Backdrop D. Portrait

13. When a Table is open in Access 2010, what are the buttons located in the lower-left corner of the screen used for?
A. Database Navigation B. Table Navigation
C. Record Removal D. Access Object Navigation

14. If an object's property sheet is NOT visible in the object's design view, the method to open it requires:
A. Double clicking the object's design tab
B. Clicking the Property Sheet Command on the object's design tab
C. Double clicking the object name
D. Right clicking the Property Sheet Command on the object's design tab

15. When a user of Access 2010 right clicks on an object, what is the name of the list of frequently used commands that displays?
A. Dialog Box Launcher B. Shortcut Menu C. Quick Access Toolbar D. Quick Access Menu

16. When entering data into a table which is NOT a method to correct typing errors?
A. Backspace to remove characters to the left
B. Use the Delete key to remove characters to the right
C. Use the mouse to select the text to replace and enter in the correct data
D. Delete the entire record, by clicking the record selector and choosing the delete command

17. Which Group on the Report Layout Tools Design Ribbon contains the command to include an automatic calculation on a Report?
A. Themes B. Controls C. Tools D. Grouping & Tools

18. In Datasheet view, what does the asterisk (*) that appears to the left of an empty record indicate?
A. Delete Record B. New Record C. Selected Record D. Current Record

19. Which view is used to preview a Report on screen and allows changes to be made to the Report?
A. Report view B. Print Preview C. Layout view D. Design view

20. When viewing a Table in datasheet view, what must a user do to make all data in the entire field visible?
A. Rebuild the table B. Refresh the table C. Resize the column D. Resize the row

21. Which feature of Access 2010 corrects common mistakes when entering text into a cell?
A. AutoSpell B. AutoCorrect C. AutoSelect D. Spell Check

22. When working in Access 2010, which function key is a shortcut to finding answers to questions or information about various topics from Microsoft Office Access Help?
A. F7 B. F1 C. F3 D. F5

23. Which character is used in a criterion to represent a collection of characters?
A. Exclamation point (!) B. Asterisk (*) C. Question Mark (?) D. Ampersand ()

24. Which view displays the area used to create a table or modify the structure of a table?
A. Design B. Datasheet C. File D. Backstage

25. In a database, where is the command for creating a new table from Table Design View located?
A. File tab B. Home Ribbon C. Create Ribbon D. Database Tools Ribbon

26. 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 describing the data in each of the columns and the remaining rows contain the data?
A. Excel List B. Text List C. Excel Chart D. Excel Table

27. In a Query, what condition must the records that are included satisfy?
A. Measure B. Benchmark C. Criterion D. Principle

28. Which is NOT a file type that may be imported into Microsoft Access 2010?
A. Text files (.txt) B.HTML files (.htm or .html)
C. Microsoft Publisher files (.pub) D. Microsoft Excel files (.xlsx)

29. How is a Query stored after it is created and saved?
A. As an image B. As a database object C. As a database macro D. As database code

30. What occurs when external data is added into Access and a copy of the data is added to a Table in an Access database?
A. Exporting B. Pasting C. Compact D. Importing

31. Which of the following is a table data type that contains only monetary data?
A. Cash B. Text C. Currency D. Number

32. In a table, which of the following contains information about a given person, product, or event?
A. Cell B. Column C. Record D. Field

33. What provides a printable map of how database tables are related?
A. Table Join Report B. Database Report C. Relationship Map D. Relationship Report

34. Which type of database object is typically used to print data for a presentation?
A. Query B. Form C. Table D. Report

35. In a table, which is a way of exclusively identifying each record in the database?
A. Unique marker B. Unique identifier C. Primary marker D. Primary category

36. In Access 2010, which area provides indicators and buttons based on information you type or tasks that are performed?
A. Scroll bars B. Status bar C. Ribbon D. Title bar

37. Where is the command to undo your most recent change in Access 2010 located?
A. Shortcut menu B. Home Ribbon C. Quick Access Toolbar D. Enhanced Screen Tip

38. What appears at the top of the Access work area to indicate objects that are open?
A. Ribbons B. Object commands C. Buttons D. Object tabs

39. Which command button is featured in Microsoft Access 2010 as a quick and easy means of creating a form?
A. Form Creator B. Form Builder C. Form Developer D. Form Tool

40. What is NOT a modification that is applied to a report's layout?
A. Setting up the report to print in landscape format
B. Applying a new theme to the report
C. Creating a summary total in the report footer
D. Rearranging the layout of controls on the report

41. In Datasheet View, how does a user delete a record?
A. Double click the record selector
B. Click the record selector and choose Delete from the Create Ribbon
C. Double click the record selector and choose Delete from the Database Tools Ribbon
D. Click the record selector and choose Delete from the Home Ribbon

42. Which print orientation displays the printout across the 11 inch width of the page?
A. Landscape B. Photographic C. Backdrop D. Portrait

43. Which Ribbon contains the commands to remove, add, or resize columns in a Report?
A. Report Layout Tools Design B. Report Layout Tools Arrange
C. Report Layout Tools Format D. Report Layout Tools Page Setup

44. Which area contains the command to view or change information about a database file?
A. File Tab B. Home Ribbon C. Database Tools Ribbon D. Create Ribbon

45. What are details about a file that are used to help organize and identify the database called?
A. Keywords B. Metatags C. Properties D. Parts

46. Which key on the keyboard is used to display KeyTip in Access 2010?
A. CTRL B. Shift C. ALT D. Tab

47. Which is NOT a comparison operator used to evaluate a field value to determine if a specific criterion is met?
A. = (equal) B. * (multiple) C. > (greater than) D. < (less than)

48. 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?
A. Tool Tag B. Enhanced ScreenTip C. ToolTip D. Screen Notes

49. Which term refers to storing the same field in more than one location in a database?
A. Redundancy B. Repetition C. Replication D. Recurrence

50. Which type of database consists of a collection of tables, each of which contains information on a specific subject?
A. Relational B. Interactive C. Collaborative D. Independent

51. What are symbols that represent any character or combination of characters and are commonly used to specify the criterion in a Query called?
A. Wildcards B. Replacements C. Common denominators D. Substitutes

52. What are questions asked of a database in which the answers are given through the data in the database called?
A. Criteria B. Queries C. Benchmarks D. Reports

53. Which view allows a user to specify fields, criteria, sorting, and calculations when creating a Query?
A. Datasheet B. Design C. File D. Backstage

54. Which is NOT one of the three basic parts of the report?
A. Page header B. Page footer C. Detail D. Page border

55. When problems occur in a database, what is the process of removing wasted space from the database and repairing the problems?
A. Recovery B. Backing up C. Installation D. Compacting

56. What type of database is a collection of data that is NOT related to any other collection of data?
A. Joined B. Relational C. Flat D. Managed

57. The process of rewriting a Microsoft Access 2010 database file to store objects and data in a smaller amount of space is called:
A. Backup the database B. Zip the database
C. Compact and repair the database D. Combine the database.

58. When working in a table, which Ribbon contains the command to change the table view?
A. Table Tools Layout B. Table Tools Format C. Table Tools Table D. Table Tools Fields

59. What object may be used in a Simple Query?
A. Macro B. Report C. Form D. Table

60. Which view is used to preview a Report on screen but prevents changes to the Report from being made?
A. Report view B. Print Preview C. Layout view D. Design view

61. Which term describes the process of periodically making a copy of a database to protect it in the event of failure or damage?
A. Recovery B. Backing up C. Installation D. Compacting

62. In the table design view, which area contains commands for designating a specific field size?
A. Field Properties B. Table Tools C. Field Options D. Table Controls

63. When operating an Access 2010 Database, why would a security warning appear below the Ribbon area?
A. To notify you that some content is disabled due to your computer's security settings
B. To notify you of a possible invasion of privacy on your computer
C. To notify you that the database is infected with a virus
D. To notify you that important content in the database has been deleted

64. After designing a table, what must a user do before exiting the table?
A. Add field descriptions B. Save the table
C. Spell check the table D. Verify the table fields

65. 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?
A. Scroll bars B. Status bar C. Ribbon D. Title bar

66. What type of Query is used when no restrictions, calculations, or special order must be applied to the data?
A. Simple Query B. Crosstab Query C. Duplicates Query D. Unmatched Query

67. Which does NOT reflect an item that the designer must verify PRIOR to creating the database?
A. Questions that the database should be able to answer
B. Colors or design elements to include
C. The audience that will use the database
D. How the data is related

68. What is the area located in the top left corner of the Access 2010 program window to provide convenient, one-click access to frequently used commands called?
A. Dialog Box Launcher B. Shortcut Menu C. Quick Access Toolbar D. Quick Access Menu

69. Which of the following is a formatted document containing fields with data that is typically used for data entry in Access 2010?
A. Query B. Form C. Table D. Report

70. The command that creates a Microsoft Access 2010 report without predefined labels and fields is called a:
A. Report Wizard B. Blank Report Tool C. Report Design D. Blank Report Wizard