Q221
Open questionThe following criterion is NOT written using the proper syntax?
Select an option to see the answer and solution.
Computer Fundamentals · all questionsMS Access
MS Access
practice.
Practice every MCQ with options. Use Show answers when you want the correct option and solution.
514
Questions
12/26
Page
Pick an option on a question to see the right answer and solution.
Q222
Open questionIn which order do you place the field to sort a Dynaset first by zipcode, then by lastname and then by firstname?
Select an option to see the answer and solution.
Q223
Open questionIn Access press to Cycle through the field grid, field properties, Navigation Pane, access keys in the Keyboard Access System, Zoom controls, and the security bar (Design view of tables)
Select an option to see the answer and solution.
Q224
Open questionWhich control type do you use to create a calculated control?
Select an option to see the answer and solution.
Q225
Open questionAn organized collection of logically related data is known as
Select an option to see the answer and solution.
Q226
Open questionWhat is the memo data type field used for?
Select an option to see the answer and solution.
Q227
Open questionThis type of query summarizes large amounts of data in easy-to-read, row-and-column format.
Select an option to see the answer and solution.
Q228
Open questionWhich of the following is not a field type in Access
Select an option to see the answer and solution.
Q229
Open questionWhen creating a new table which method can be used to choose fields from standard databases and tables
Select an option to see the answer and solution.
Q230
Open questionThe Table _______________ Wizard analyzes a database and recommends changes for normalization.
Select an option to see the answer and solution.
Q231
Open questionWhich criteria return only those addresses beginning with the letter "K"?
Select an option to see the answer and solution.
Q232
Open questionWhich of the following database object is created first before any other created?
Select an option to see the answer and solution.
Q233
Open questionWhich function evaluates a "true/false" expression and then performs one of two actions?
Select an option to see the answer and solution.
Q234
Open questionA part of database that stores complete information about an entity such as employee, sales, orders etc.
Select an option to see the answer and solution.
Q235
Open questionThe procedure for selecting multiple controls on a report?
Select an option to see the answer and solution.
Q236
Open questionAfter entering all fields required for a table, if you realize that the third field is not needed, how will you remove?
Select an option to see the answer and solution.
Q237
Open questionWhat is an index?
Select an option to see the answer and solution.
Q238
Open questionWhich of the following is NOT a report section?
Select an option to see the answer and solution.
Q239
Open questionWhat happens when you release mouse pointer after you drop the primary key of a table into foreign key of another table?
Select an option to see the answer and solution.
Q240
Open questionIn table design view what are the first column of buttons used for
Select an option to see the answer and solution.