Set 5
Collection of Multiple Choice Questions (MCQs) or Objective Questions from Microsoft Access (MS-Access)for Compute Jobs Exams like Computer Operator, Computer Engineer, Computer Officer and so on.
Collection of Multiple Choice Questions (MCQs) or Objective Questions from Microsoft Access (MS-Access)for Compute Jobs Exams like Computer Operator, Computer Engineer, Computer Officer and so on.
1. When you save an Access project, what file format do you use?
a. .adp
b. .xm.
c. .mdb
d. All of above
Correct Answer: a
Microsoft Access Multiple Choice Questions (MCQs) published on http://www.psexam.com
2. Which of the following criterion would find records whose personality field does not equal “Nice”?
a. <>Nice
b. NOT Nice
c. <>”Nice”
d. IS NOT Nice
Correct Answer: c
Microsoft Access Multiple Choice Questions (MCQs) published on http://www.psexam.com
3. According to the Access timeline on Microsoft.com, which version of Microsoft Access first included the Northwind Traders sample database?
a. 1.0
b. 2.0
c. 7.0 for Windows 95
d. All of above
Correct Answer: a
Microsoft Access Multiple Choice Questions (MCQs) published on http://www.psexam.com
4. Which version of Access first provided ODBC connectivity to Oracle databse?
a. 1.1
b. 2.0
c. 97
d. All of the above
Correct Answer: a
Microsoft Access Multiple Choice Questions (MCQs) published on http://www.psexam.com
5. What was the lagest database size allowed by Access 1.0?
a. 128 MB.
b. 256 MB
c. 512 MB
d. None of above
Correct Answer: a
Microsoft Access Multiple Choice Questions (MCQs) published on http://www.psexam.com
6. What is the maximum length of a text field can be?
a. 512 characters
b. 50 characters
c. No limit
d. 255 characters.
Correct Answer: d
Microsoft Access Multiple Choice Questions (MCQs) published on http://www.psexam.com
7. What is the maximum character field size you can set for a field that has a text data type?
a. 64
b. 255
c. 512
d. All of above
Correct Answer: b
Microsoft Access Multiple Choice Questions (MCQs) published on http://www.psexam.com
8. Which of the following fields would not make a suitable primary key
a. A date field
b. An invoice number
c. An autoNumber field
d. A customer’s social security number
Correct Answer: a
Microsoft Access Multiple Choice Questions (MCQs) published on http://www.psexam.com
9. Auto reports can contain each of the following elements except:
a. A detail section
b. A page footer
c. A group header
d. All of the above
Correct Answer: c
Microsoft Access Multiple Choice Questions (MCQs) published on http://www.psexam.com
10.Need to see all the information from two tables on one form? Insert:
a. A page break
b. A subform
c. A linked command button
d. None of the above
Correct Answer: b
Microsoft Access Multiple Choice Questions (MCQs) published on http://www.psexam.com
11.What is the primary difference between a pivot table report and a cross tab query?
a. A pivot table report can contain sums, counts, and averages while a cross tab query cannot.
b. You can’t pivot a cross tab query
c. A cross tab query lets you group similar items. A pitot table report does not
d. None of above
Correct Answer: b
Microsoft Access Multiple Choice Questions (MCQs) published on http://www.psexam.com
12.The largest unit of a database is
a. A record
b. A field
c. A subfield
d. None of above
Correct Answer: b
Microsoft Access Multiple Choice Questions (MCQs) published on http://www.psexam.com
13.What’s the best Access object for an invoice you’ll mail to customers?
a. A report
b. A form
c. A table
d. All of the above
Correct Answer: a
Microsoft Access Multiple Choice Questions (MCQs) published on http://www.psexam.com
14.What is a Grouped Report?
a. A type of report that can be generated by the Report Wizard
b. A report that displays data that has been sorted in ascending or descending order
c. A report that displays data grouped by fields you specify
d. None
Correct Answer: c
Microsoft Access Multiple Choice Questions (MCQs) published on http://www.psexam.com
15.A(n) …., or command is the basic building block of a macro
a. Action
b. Expression
c. Function
d. Procedure
Correct Answer: a
Microsoft Access Multiple Choice Questions (MCQs) published on http://www.psexam.com
16.Which field allow to select items from drop down list?
a. An OLE field
b. A Memo Field
c. A lookup Field
d. A hyperlink field
Correct Answer: c
Microsoft Access Multiple Choice Questions (MCQs) published on http://www.psexam.com
17.What did the first Table Analyzer do?
a. Analyze the data in a set of flat files and automatically create a relational database system from that information
b. Provide a graphic way to design relational databases
c. Automate process of connecting tables to SQL Server
d. None
Correct Answer: a
Microsoft Access Multiple Choice Questions (MCQs) published on http://www.psexam.com
18.Pivot Table reports are good for:
a. Analyzing large amounts of data
b. Turning tables upside down
c. Breaking spreadsheet data into multiple worksheet
d. None of above
Correct Answer: a
Microsoft Access Multiple Choice Questions (MCQs) published on http://www.psexam.com
19.A report form
a. Appears on the computer monitor during data entry
b. Is used during report generation to format data
c. Both a and b
d. All of above
Correct Answer: b
Microsoft Access Multiple Choice Questions (MCQs) published on http://www.psexam.com
20.Which of the following columns can not be found in the macro design window?
a. Arguments column
b. Comment column
c. Conditions column
d. Actions column
Correct Answer: c
Microsoft Access Multiple Choice Questions (MCQs) published on http://www.psexam.com
| < Prev | Next > |
|---|
