201 to 300 MS Access MCQ Questions

MS Access MCQ Questions:

201. In Access 2007, to make changes in the Trust Center, you need to go to the ____.

a. Microsoft Office button
b. Navigation Pane
c. Quick Access toolbar
d. Database Tools command tab

202. For _________ data to be useful, both the sender and the receiver need to be able to read and use the data.

a. standardized
b. fixed
c. delimited
d. shared

203. Which of the following is a standard file format language for web documents?

a. HTML
b. XML
c. XSD
d. XSL

204. HTML stands for ____.

a. High Text Mail List
b. Hyperlink Markup Language
c. HyperText Markup Language
d. Hyperlink Transfer Markup Language

205. In Access 2007, to set a table to open as a document tab, you need to go to the ____.

a. Microsoft Office button
b. Navigation Pane
c. Quick Access toolbar
d. Database Tools command tab

206. Which of the following is the file extension for an Extensible Markup Language?

a. EML
b. HTML
c. XML
d. XSD

207. A(n) __________ is an Extensible Scheme Standard file that is an approved W3C standard design as a basic infrastructure.

a. HTML
b. XML
c. XSD
d. XSL

208. A disadvantage to a ____file is that there is no easy way to tell which fields are numbers, text, dates, or currency.

a. standardized
b. fixed
c. delimited
d. text

Q. What MCQ Set offers for the candidates of computer jobs exams?

a. Downloads of MCQ Banks
b. Huge collection of MCQ questions
c. Online MCQ quiz
d. Subjective questions and answers

209. A(n) _____ is an image control that displays in the background of a page on a form or report.

a. legend
b. icon
c. logo
d. watermark

210. Which colors are used to define a custom color?

a. Red, Blue, Yellow
b. Red, Green, Blue
c. Blue, Green, Orange
d. Green, Orange, Violet

211. If a color property contains “#336699”, how many blue units are in the color?

a. 33
b. 66
c. 99
d. 255

212. The _____ function returns a string that has been converted to uppercase text.

a. AllCap
b. UCase
c. UpCase
d. Upper

213. Which part of the IIF expression is the action performed if the true condition exists?

a. inner
b. first
c. second
d. third

214. If you need a calculation in an unbound control, you can create a custom _____.

a. string
b. expression
c. relationship
d. syntax

215. The _____ Builder is an Access tool for selecting colors from a palette or creating custom colors.

a. Color
b. Expression
c. Palette
d. Property

216. Which function evaluates a “true/false” expression and then performs one of two actions?

a. Case
b. IF
c. IIF
d. IsTrue

217. When adding an image, which size mode will change the height or width of the image fit the control?

a. Clip
b. Stretch
c. Zoom
d. Crop

218. The three parts of an IIF function are separated by _____.

a. dashes
b. asterisks
c. semicolons
d. commas

219. A Smart Tag can be set using the _____ tab in the property sheet.

a. Format
b. Tag
c. View
d. Data

220. A(n) _____ is a control that, when clicked, executes an action or series of actions.

a. combo box control
b. AutoFormat
c. Conditional Format
d. command button

221. According to the Leszynski Naming Conventions, which of the following is the prefix for a text box control?

a. txt
b. txb
c. tbc
d. tex

Q. What MCQ Set offers for the candidates of computer jobs exams?

a. Downloads of MCQ Banks
b. Huge collection of MCQ questions
c. Online MCQ quiz
d. Subjective questions and answers

222. How can a user open the Expression Builder dialog box?

a. By clicking the drop-down arrow on the Control Source property
b. By clicking the drop-down arrow of the Input Mask property in the Data tab
c. By clicking the Build button of the Input Mask in the Data tab
d. By clicking the Build button of the Control Source property in the Data tab

223. According to the Leszynski Naming Conventions, which of the following is the prefix for a combo box control?

a. cbo
b. cob
c. cmb
d. cbx

224. You have a Command button in the Form Footer, you click the Tabular Control Layout; an attached label will be added in what section?

a. Detail
b. Form Footer
c. Form Header
d. Page Header

225. The Allow _____ property controls whether new records can be added through the form.

a. Additions
b. Edits
c. Deletions
d. Data Entry

226. The _____ Smart Tag launches Microsoft Outlook to schedule an appointment or display a calendar.

a. Date
b. Time
c. Calendar
d. Appointment

227. The _____ Symbol Smart Tag launches Microsoft Explorer and obtains a stock quote.

a. MSN Money
b. Portfolio
c. Financial
d. Stock

228. Which of the following is NOT true about background images?

a. They are similar to watermarks in Word.
b. They are displayed behind the controls in a form.
c. They do not print when a form or a report is printed.
d. They can be inserted on a form or a report.

229. In a query, what symbol is used to surround a parameter\’s user prompt?

a. [ ]
b. { }
c. ” ”
d. ( )

230. A(n) _______________ query locates data from one or more tables.

a. select
b. summary
c. parameter
d. action

231. Which function extracts the name of the month from a date/time value?

a. Month
b. MonthName
c. MonthLabel
d. MonthValue

232. Which of the following queries prompts users for input data by displaying dialog boxes?

a. Append
b. Delete
c. Parameter
d. Update

233. A(n) _______________ query makes changes to or moves records in a dynaset, in a single operation.

a. select
b. summary
c. parameter
d. action

234. Which of the following queries modifies fields not records?

a. Append
b. Delete
c. Make-Table
d. Update

235. A summary query can be created by adding which row to the design grid of a select query?

a. Arguments
b. Group
c. Summary
d. Total

236. Which of the following functions is used to all the values in a numeric field?

a. Num
b. Count
c. Sum
d. Total

Q. What MCQ Set offers for the candidates of computer jobs exams?

a. Downloads of MCQ Banks
b. Huge collection of MCQ questions
c. Online MCQ quiz
d. Subjective questions and answers

237. Which of the following queries can create a table?

a. Append
b. Delete
c. Make-Table
d. Update

238. In a query, which row do you need to place wildcards to affect a parameter?

a. Arguments
b. Criteria
c. Fields
d. Tables

239. You created a query with two tables that have relationship of One-To-Many with referential rules applied. The first table has 3 records and the second has 8. With using a right outer join, how many records will the resulting recordset have?

a. 5
b. 8
c. 24
d. Not enough information to tell

240. Which of the following types of joins displays records with the same value in the common field?

a. Inner join
b. Left outer join
c. Right outer join
d. Self join

241. A global join will be created automatically when using tables in a(n) _____.

a. form
b. report
c. query
d. field

242. Which of the following is the default join between two recordsets?

a. Inner join
b. Left outer join
c. Right outer join
d. Self join

243. In a query\’s Design View, right-clicking the sloping portion of the join line between two tables and selecting Delete will delete what?

a. The join line but not the relationship between the two tables
b. The relationship between the two tables locally
c. The relationship between the two tables globally
d. The primary key of the first table

244. What is an index?

a. A wizard that creates a functional database structure based on the user\’s selections
b. A widely recognized naming convention for database objects
c. A sort order for records, which is identified in the table design
d. A set of relationship rules that enforce defined database relationships

245. You created a query with two tables that did NOT have a join line. The first table has 12 records and the second has 5. The resulting recordset would have how many records?

a. 7
b. 17
c. 60
d. Not enough information to tell

246. Which of the following dialog boxes enables users to enforce referential integrity in a One-To-Many relationship?

a. Edit Relationships
b. Indexes
c. Option
d. Show Table

247. In a junction table, the _____ field consists of the foreign key from both the linked tables.

a. first defined
b. last defined
c. foreign key
d. primary key

248. What does an inner join display?

a. Records from the second recordset and only records from the first recordset where the common fields are equal
b. Records from the first recordset and only records from the second recordset where the common fields are equal
c. Records that have the same value in the common field
d. Records from the first recordset only

249. The page count of a report can be determined by clicking the _______ button.

a. First Page
b. Previous
c. Next
d. Last Page

250. When you add fields in ____, a Field List pane displays.

a. Design View
b. Layout View
c. Print Preview
d. Report View

251. Any report, including a basic report, can be modified in __.

a. Form View
b. Layout View
c. Print Preview
d. Report View

252. A ____ often display summary data such as totals or counts.

a. Group Header
b. Group Footer
c. Report Header
d. Page Footer

253. Which of the following can a Report Wizard NOT do?

a. Add summary functions
b. Create groups
c. Group fields into more than one Control Layout
d. Select fields

254. ______ allows you to resize controls, adjust column widths, move columns, and change labels while viewing the actual data in the report.

a. Design View
b. Layout View
c. Print Preview
d. Report View

255. Which report section prints once at the bottom of every printed page?

a. Detail
b. Page Header
c. Page Footer
d. Report Header

256. Which report section only prints one time at the end of the report?

a. Report Header
b. Page Header
c. Report Footer
d. Page Footer

257. Which of the following database objects can have more than one Group Header/Footer section?

a. Forms
b. Queries
c. Reports
d. Tables

258. Which of the following statements about the Label Wizard is NOT true?

a. Adding groups can help organize the labels.
b. It helps users to create package labels.
c. It allows users to select a label type and size.
d. It allows users to sort the labels.

259. Which of the following views enables users to create and modify the sections of a form?

a. Datasheet
b. Design
c. Form
d. Layout

Q. What MCQ Set offers for the candidates of computer jobs exams?

a. Downloads of MCQ Banks
b. Huge collection of MCQ questions
c. Online MCQ quiz
d. Subjective questions and answers

260. To align controls in rows and columns like a spreadsheet, with labels across the top, which layout should be used?

a. Datasheet
b. Justified
c. Stacked
d. Tabular

261. Which Form tool creates a new form that show both a form and datasheet views?

a. Form
b. Form Wizard
c. Multiple Item Form
d. Split Form

262. Which of the following statements about tab order setting is NOT true?

a. The actual tab order setting for a form can be used in the Form View.
b. The tab order setting determines the movement of the insertion point through a form.
c. The tab order setting is usually right-to-left and top-to-bottom.
d. The default tab order setting can be altered by moving the controls in the Design View.

263. What type of controls are text boxes when data from the recordset is visible?

a. Align
b. Bound
c. Calculated
d. Unbound

264. When increasing the Control Padding, space is added where?

a. Between the content of the controls and the outside edge of then controls
b. Between all controls
c. Between the control and the Form\’s edge
d. Between controls and gridlines

265. Which of the following is NOT possible when printing Forms?

a. Print page 1, 3, and 5
b. Print pages 1 through 5
c. Print selected records
d. Print only the third record

266. To apply an AutoFormat to an entire Form, what must you select first?

a. Form Selector
b. Document tab
c. Detail section
d. Any control

267. Which is NOT an option of the Picture Size Mode property?

a. Clip
b. Fit
c. Stretch
d. Zoom

268. Which mode sizes an image to fit the control while maintaining the proportions of the original image?

a. Clip
b. Fit
c. Stretch
d. Zoom

269. Which of the following views is used to graphically summarize and analyze data in a recordset?

a. Datasheet
b. Form
c. PivotChart
d. PivotTable

270. Which of the following statements about criteria in a query is NOT true?

a. Criteria can contain wildcard characters.
b. Criteria in a query selects or excludes certain records.
c. Criteria cannot be specified as an expression.
d. Multiple criteria can be specified using AND, OR, and relational operators.

271. Which of the following statements does NOT hold true for the Top Values property?

a. The Top Values property displays only the highest values from the query.
b. The Top Values property requires the fields to have a defined sort order.
c. The Top Values property finds a specified number of records.
d. The Top Values property finds a specified percentage of records.

272. Which of the following statements about calculated fields is NOT true?

a. A calculated field does not store data in a recordset.
b. Calculated fields use an expression or formula as its data source.
c. Data contained in a calculated field is created the first time a query is run.
d. A calculated field can be created using the Expression Builder dialog box.

273. Using the keyword _______________ will return records in which the field value equals a defined text.

a. Between
b. Is Null
c. Like
d. Not

274. What is the process of eliminating redundant fields by separating data into tables called?

a. Renormalizations
b. Filtering
c. Normalization
d. Sorting

275. Which of the following statements about PivotChart View is NOT true?

a. It is used to graphically summarize and analyze data in a table, query, or form.
b. It can be used to view different levels of detail or to specify custom layout.
c. It displays field values that can be switched for different views of data.
d. It displays the same information as a crosstab query, except for the counts and sums of numeric fields.

276. Which of the following search criteria is invalid?

a. $45*
b. *cal*
c. D*m??
d. AS150*

Q. What MCQ Set offers for the candidates of computer jobs exams?

a. Downloads of MCQ Banks
b. Huge collection of MCQ questions
c. Online MCQ quiz
d. Subjective questions and answers

277. In a query, using the keyword _______________ will return records in which the field value is between two numbers.

a. Between
b. Is Null
c. Like
d. Not

278. Which of the following database objects extracts information from one or more tables or queries?

a. Forms
b. Queries
c. Reports
d. Tables

279. Referential integrity cannot be set for _______________ relationships.

a. One-To-One
b. Indeterminate
c. One-To-Many
d. Many-To-Many

280. A relationship is created between how many tables?

a. One
b. Two
c. Three
d. Any number

281. The common field linking the two datasheets is the _______________ key field in the main datasheet and the _______________ key field in the linked datasheet.

a. primary, foreign
b. primary, common
c. foreign, primary
d. foreign, common

282. Referential integrity can be enforced if both _______________ belong to the same Microsoft Access database.

a. queries
b. fields
c. records
d. tables

283. In the Relationship window, related fields from each table are connected by a(n) _______________.

a. default field
b. linking tables
c. index
d. join line

284. Relationships between tables can be graphically viewed in the _______________ window.

a. Design
b. Joins
c. Relationships
d. Tables

285. A One-To-Many relationship that is not enforcing referential integrity, displays what symbol next to the foreign key field?

a. 1
b. ?
c. r
d. None

286. In the Field List of a table, the primary key appears _______________.

a. bold
b. italicized
c. underlined
d. with key icon

287. What type of relationship is created when you select a primary key in both related tables?

a. One-To-One
b. Indeterminate
c. One-To-Many
d. Many-To-Many

288. The Table _______________ Wizard analyzes a database and recommends changes for normalization.

a. Analyzer
b. Documenter
c. Cleanup
d. Normalization

289. The Input Mask wizard does NOT include the ability to do which of the following?

a. Force all uppercase
b. Define placeholder
c. Store symbols with data
d. Use preset masks

290. Which of the following field properties enforces the use of parentheses when keying an area code?

a. Field Size
b. Format
c. Input Mask
d. Validation Rule

291. Which of the following field properties is an expression that specifies criteria or requirements for entering data?

a. Field Size
b. Format
c. Input Mask
d. Validation Rule

292. In Datasheet View, what appears at the top of each column?

a. Data type
b. Description
c. Field name
d. Primary key

293. Which is NOT a method of creating a table?

a. Datasheet View
b. Design View
c. Layout View
d. Template

294. Which of the following views displays the field name, description, and properties of a table?

a. Datasheet View
b. Design View
c. Layout View
d. Table View

295. Which of the following properties identifies the type of information stored in a field?

a. Data type
b. Field description
c. Field name
d. Field properties

296. Which of the following field properties displays a model or pattern for entering data?

a. Field Size
b. Format
c. Input Mask
d. Validation Rule

297. Which of the following data types automatically generates a consecutive number?

a. Autonumber
b. Memo
c. Number
d. Text

298. Database properties do NOT include ___________.

a. title
b. author
c. company
d. size

299. To remove all Sorts in a table you can click the ______ command.

a. Clear All Sorts
b. Delete All Sorts
c. Eliminate All Sorts
d. Remove All Sorts

Q. What MCQ Set offers for the candidates of computer jobs exams?

a. Downloads of MCQ Banks
b. Huge collection of MCQ questions
c. Online MCQ quiz
d. Subjective questions and answers

300. A(n) _____________ is dynamic mathematical calculation that displays a single value for a specific field.

a. format row
b. criteria row
c. aggregate function
d. format layout

Answers:

Click the Like, Tweet or Google+ buttons below to show correct answers:

Q.No-Correct Answer

201 – a	202 – d	203 – a	204 – c	205 – a	206 – c	207 – c	208 – d	209 – d	210 – b
211 – c	212 – b	213 – c	214 – b	215 – a	216 – c	217 – b	218 – d	219 – d	220 – d
221 – a	222 – d	223 – a	224 – c	225 – a	226 – a	227 – c	228 – c	229 – a	230 – a
231 – b	232 – c	233 – d	234 – d	235 – d	236 – b	237 – c	238 – b	239 – c	240 – a
241 – b	242 – a	243 – b	244 – c	245 – c	246 – a	247 – c	248 – c	249 – d	250 – b
251 – b	252 – b	253 – c	254 – b	255 – c	256 – c	257 – c	258 – a	259 – b	260 – d
261 – d	262 – c	263 – b	264 – b	265 – a	266 – a	267 – b	268 – d	269 – c	270 – c
271 – a	272 – c	273 – c	274 – c	275 – d	276 – a	277 – a	278 – b	279 – b	280 – b
281 – a	282 – d	283 – d	284 – c	285 – d	286 – d	287 – a	288 – a	289 – a	290 – c
291 – d	292 – c	293 – c	294 – b	295 – a	296 – c	297 – a	298 – d	299 – a	300 – c