MS-Access Multiple Choice Questoins - Set 4 for objective exam
61. Which command is used to replace
a. REPLACE
b. REPLACE ALL
c. Add record from edit menu
d. All of above
Correct Answer: c
62. What is part of a database that holds only one type of information?
a. Report
b. Field
c. Query
d. Record
Correct Answer: b
63. When using Access Database, use this feature to have Access select only certain records in the database to prepare form letters.
a. Report
b. Table
c. Query
d. Tools
Correct Answer: c
64. Which commands are used to execute DOS commands in Dbase?
a. RUN
b. !
c. Both of above
d. None
Correct Answer: c
65. All of the following terms are related to computerized databases except which one?
a. Search
b. Sort
c. Field names
d. Record grab
Correct Answer: a
66. Memo field in database file is used to
a. Store lengthy number
b. Store images
c. Store audio files
d. Store long textual information
Correct Answer: d
67. Applications that rely on databases are
a. Supermarket stock control, theater bookings and payroll
b. Accounts, online banking, PowerPoint presentations
c. Internet shopping, robotics, computer games
d. None of above
Correct Answer: a
68. which of the following is not a Access database object
a. table
b. form
c. query
d. datasheet
Correct Answer: d
69. Data owners must protect their data against corruption or loss. One sensible method to achieving this is to
a. Take regular backups
b. Keep a hardcopy printout of all data
c. Keep fingers crossed at all times
d. None of above
Correct Answer: a
70. Facilities offered by databases are
a. The ability to store a large amount of data in a structured format, easy update, sort, query, production of reports
b. Easy editing, spell check, perform calculations, library of mathematical functions, replication
c. The ability to rotate images, copy and paste, fill scale
d. None of above
Correct Answer: a
71. Users who store data about real people for marketing purposes must register the data and its potential use with
a. The computer misuse controller
b. The data protection controller
c. HM customs and excise
d. None of above
Correct Answer: b
72. When you double click a query object, you open
a. The object in design view
b. The object in print preview
c. The result of the query
d. The underlying table on which the query is based
Correct Answer: b
73. checks that are added to databases to detect unsuitable data on inpt are called
a. validation
b. verification
c. vegetation
d. none of above
Correct Answer: a
74. Auto Report allows you to
a. View a subset of your data
b. Create a simple report
c. Create a data entry form
d. Enter records
Correct Answer: b
75. Auto Form allows you to
a. View a subset of your data
b. Create a simple report
c. Create a data entry form
d. Enter records
Correct Answer: b
76. The asterisk (*) is sometimes used in database queries. This character is then called a
a. Wildcard
b. Dummy
c. Ditto
d. All of the above
Correct Answer: a
77. When performing a look-up operation using a form
a. You enter the search value into the form
b. You look at each form sequentially until you see the one you want
c. You type the key in an entry line, and the correct form is displayed
d. All of the above
Correct Answer: d
78. Which custom date format displays the numeric day of the year when a date is entered?
a. YY
b. YYYY
c. Y
d. All of above
Correct Answer: c