Top 550+ Solved Microsoft Access (MS Access) MCQ Questions Answer
Q. 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
Q. 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
Q. 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
Q. 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
Q. Which of the following views is used to graphically summarize and analyze data in a recordset?
a. Datasheet
b. Form
c. PivotChart
d. PivotTable
Q. 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.
Q. 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.
Q. 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.
Q. Using the keyword _______________ will return records in which the field value equals a defined text.
a. Between
b. Is Null
c. Like
d. Not
Q. What is the process of eliminating redundant fields by separating data into tables called?
a. Renormalizations
b. Filtering
c. Normalization
d. Sorting
Q. 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.
Q. 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
Q. Which of the following database objects extracts information from one or more tables or queries?
a. Forms
b. Queries
c. Reports
d. Tables