1. Which is not an option for Filter on a text field?
Correct : B. Between
2. The Search tool is best used when searching for ______ data.
Correct : A. simple
3. Which of the following Find and Replace dialog box options finds records in which the beginning of a field matches the Find What entry?
Correct : C. Match: Start of Field
4. Which of the following functions CANNOT be used in the Totals row?
Correct : D. Round
5. Before printing a datasheet, you can use ____ to determine whether to change the page orientation from portrait to vertical orientation.
Correct : D. Print Preview
6. What is the keyboard shortcut to move to the last records in a table?
Correct : D. [Ctrl]+[End]
7. A ____ is a major database object used to display information in an attractive, easy-to-read screen format.
Correct : A. form
8. Print options can be changed in the Print ____.
Correct : D. dialog box
9. Which major database object stores all data?
Correct : D. Table
10. The insertion point looks like a(n) ____.
Correct : D. I-beam
11. Access file operations can be found by clicking the ____.
Correct : C. Office Button
12. A ____ is a major database object used to display information in a printable page format.
Correct : C. report
13. In Datasheet View, new records are added to a table ____.
Correct : B. at the end of the table
14. What happens when a user selects a record in a form and presses [Delete]?
Correct : A. The record is deleted in the form and from its source table.
15. Which of the following CANNOT be done to data using a Form?
Correct : A. Store
16. What is one of the advantages for using a form over other Access objects?
Correct : A. Utilizes field placement to improve the efficiency of data entry.
17. Which of the following methods CANNOT be used to copy a block of text from one part of a table to another?
Correct : C. Press [Ctrl]+[+] and [Ctrl]+[-].
18. A(n) ____ in the Record Selector indicates a new record.
Correct : C. asterisk
19. All attachment fields display as a(n) ____ in Datasheet View.
Correct : D. paperclip
20. Which of the following methods CANNOT be used to delete records from a table?
Correct : B. Pressing [Ctrl]+[\']
21. Where can you find the undo command in Access?
Correct : D. Quick Access toolbar
22. An application that executes on separate PCs like this is called a(n) __________ application.
Correct : B. distributed
23. The most popular commercial DBMS.
Correct : D. Oracle
24. The ability of a database to grow as the data tracking needs grow is its __________.
Correct : A. scalability
25. The most open source DBMS.
Correct : C. MySQL
26. A DBMS that runs on many different operating systems is said to be __________.
Correct : C. platform independent
27. Search engines use a(n) __________ to automatically index sites.
Correct : A. crawler
28. The __________ performs document tracking.
Correct : D. EDM software
29. An enterprise solution with data storage, a client interface and a security system is a(n) __________ system.
Correct : B. 3-tier
30. __________ will answer questions you did not think to ask of your data.
Correct : C. knowledge discovery
31. __________ is the clear leader for personal databases.
Correct : A. Microsoft Access
32. The __________ is the software tool to store or access data.
Correct : B. DBMS
33. __________ are documents that when filled in create records.
Correct : A. Forms
34. This database has only one table.
Correct : C. flat-file
35. The __________ field is used to hold a yes or no answer.
Correct : D. logical
36. To delete records or perform calculations on a table, the best tool to use is a __________.
Correct : A. query
37. __________ is used to build ‘intuitive’ queries.
Correct : C. QBE
38. To print information from a table, the __________ tool is the best choice.
Correct : B. report
39. To store your picture in a database requires a(n) __________ field.
Correct : A. BLOB
40. The __________ is used to access one record at a time.
Correct : C. form
41. SQL stands for __________.
Correct : B. Structured Query Language
42. What are the different views to display a table
Correct : D. All of above
43. Which of the following creates a drop down list of values to choose from?
Correct : D. Lookup wizard
44. The command center of access file that appears when you create or open the MS Access database file.
Correct : A. Database window
45. In a database table, the category of information is called __________
Correct : B. Field
46. It is an association established between common
Correct : B. Relationship
47. This is the stage in database design where one gathers and list all the necessary fields for the database project.
Correct : A. Data definition
48. Which of the following statement is true?
Correct : C. In an indexed field you may or may not enter duplicate value depending upon setting
49. The database language that allows you to access or maintain data in a database
Correct : A. Dcl
50. What is the difference between ‘open’ and ‘open exclusively’
Correct : B. Open exclusive locks whole database so that no one can access it whereas open locks only the record that is being accessed
51. After entering all fields required for a table, if you realize that the third field is not needed, how will you remove?
Correct : D. Select the third row in table design view then delete
52. Two tables can be linked with relationship so that the data integrity can be enforced. Where can you find relationship command
Correct : D. Tools menu
53. What do you mean by one to many relationship between student and class table?
Correct : A. One student can have many classes
54. Referential integrity means
Correct : A. Do not enter a value in the foreign key field of a child table if that value does not exist in the primary key of the parent table
55. Cascade delete option
Correct : C. Is available in edit relatiionship dialog box which makes sure that all the related records will be deleted automatically whn the record from parent table is deleted
56. When a picture or other graphic image is placed in the report header section it will appear____
Correct : A. Once in the bugging of the report
57. Which of the following database object is created first before any other created?
Correct : A. Table
58. This type of database contains multiple tables that are connected to produce combined output from all tables.
Correct : C. Relational
59. The ‘filter by selection’ allows you to filter those records
Correct : A. That match the selected field
60. The operation of checking input data against specified criteria is known as?
Correct : B. Data validation
61. Some rules are set in databases to check and permit only correct values. What is this feature called?
Correct : D. Data validation
62. Database access levels are specified so as to define who can access what in a database. It is identified through
Correct : A. User id
63. What it is called to present information in a particular order based on numeric or alphabetical value?
Correct : A. Sorting
64. A collection of related records in database is known as a
Correct : C. File
65. A part of database that stores complete information about an entity such as employee, sales, orders etc.
Correct : B. Record
66. To create this, you enter an expression in the design grid that instructs access to perform a calculation using the current field values.
Correct : D. Calculated field
67. The ascending order of data hierarchy is?
Correct : A. Bit - byte - field - record - file - databse
68. Which of the following database object can be used if you need to mail the invoice to customers?
Correct : C. A report
69. When creating an input mask this character does not require an entry, but if an entry is made it must be a letter from a-z
Correct : A. ?
70. In access, this displays the results of a calculation in a query
Correct : B. Calculated field
71. In access, this operation copies a backup file from the storage medium back onto the computer
Correct : B. Restore
72. If you make an invalid entry in the input mask wizard dialog box, this will display to advise you that the entry is not correct
Correct : B. Validation error
73. In the form wizard dialog box, the fields from the selected table are displayed in this list box.
Correct : D. Available fields
74. This form displays the field name labels down the left side of the column, with the data for each field just to the right of its corresponding label.
Correct : C. Columnar
75. This form displays data in a table layout with field name labels across the top of the page and the corresponding data in rows and columns under each heading.
Correct : D. Tabular
76. This form displays multiple records, one per row, in the form window
Correct : A. Datasheet
77. In this form, a single record may appear in multiple rows in the form window in order to fully display the field name label and data.
Correct : C. Justified
78. Which of the following is not a form style available in the form wizard dialog box.
Correct : D. Highlights
79. You can move between fields in a form by using any of these keys except
Correct : D. Page up
80. Queries are based on this, allowing you to use a query as the source for forms and reports
Correct : B. Tables
81. This type of query summarizes large amounts of data in easy-to-read, row-and-column format.
Correct : A. Crosstab
82. Which of the following is not one of the methods available in the new query dialog box to create queries?
Correct : D. Datasheet view
83. This query wizard will create a select query.
Correct : C. Simple
84. The quickest way to add a field to the selected fields list is to double-click its field name in this list.
Correct : D. Available fields
85. The result of a query is displayed in a
Correct : B. Query datasheet
86. Changing the order of this in the query datasheet does not affect the field order in the table.
Correct : C. Column
87. In the second subform wizard dialog box you specify the table to use as the data source and the
Correct : C. Fields from the selected table
88. This is not one of the sections of the form design window
Correct : B. Form content
89. When you select this control, its associated text control is also selected and the two controls will act as one when manipulated.
Correct : B. Form
90. In access, this view is used to create and modify the structure of a form.
Correct : C. Form design
91. To set a password for the database, select ____________ in the Microsoft Access open window.
Correct : D. Open exclusive
92. To enter the input mask wizard
Correct : D. Click on the three dots to the right of the input mask entry field
93. Saving a database in access is done
Correct : A. At the beginning of the database
94. The file extension for an access 2003 database is
Correct : D. Mdb
95. Which of the following best describes the grouped report?
Correct : C. A report that displays data grouped by fields you specify
96. What is the use of description field in table design window?
Correct : C. Both of above
97. How can you display the related records from other tables in datasheet view?
Correct : A. Click on the expand indicator next to the record
98. Which of the following query type is best suitable to analyze data?
Correct : A. Cross tab queries
99. Which of the following is a database management system?
Correct : C. Oracle
100. In relational database schema each tuple is divided into fields known as?