Top 550+ Solved Microsoft Access (MS Access) MCQ Questions Answer
Q. You can display a database object in design view by
a. Opening the database object and clicking the view button on the toolbar
b. Selecting the database object and clicking the design button on the database window
c. Selecting the database object and press Ctrl + V
d. Opening the database object and selecting Tools>Design view
Q. How can you display the relationship in a database?
a. Select View > Relationship form the menu
b. Click the Relationship button on the toolbar
c. Select Edit >Relationship from the menu
d. All the above are true
Q. If you are creating a cross tab query, what must table you are querying contain?
a. Lots of confusing information
b. More than 100 records
c. At least one field
d. None of the above
Q. A query summarizes information in a grid,organized by regions and months. Which type of query is this?
a. A cross tab query
b. An update query
c. A parameter query
d. An action query
Q. What type of text box does the toolbox and to a form?
a. Unbound
b. Bound
c. Rebound
d. Calculated
Q. The filter by selection feature allows you to filter
a. Those records that match an entity in a field
b. Records based on a criterion you specify
c. Records that meet any of several criteria you specify
d. All of above
Q. What is the memo data type field used for?
a. To add table
b. To store objects created in other programs
c. For long text entries
d. For shout text entries of no more than 255 characters
Q. What is the purpose of the description column in Table Design View?
a. To define the data type applied to each field within the table
b. To describe the data that should be entered in each field
c. To enter lookup data that the field should refer to.
d. None of the above
Q. What is the propose to a sub datasheet?
a. To provide a hierarchial view of related tables or queries in a single window
b. To display grouped data in a report
c. To display summarized data.
d. All of the above
Q. Which of the following is not a selection technique ?
a. To select a word, double click the word
b. To select an entire table click the empty bosx to the left of the field names
c. To select a row, click the record selector box to the left of the row
d. To select a column, double click anywhere in the column
Q. How can you display Pivot Table reportsummary data in a currency format?
a. Use custom calculation
b. Type in the currency symbol
c. Modify the field settings
d. None of the above
Q. What method can you use to add a new table to your database?
a. Use Design View to create a table
b. Enter data directly by using a datasheet
c. Both of above
d. All of the above
Q. Which action do you use in a a macro to automatically send a report snapshot in an email message?
a. Use mail
b. Send object
c. Run macro
d. All of the above
Q. How can you display sales grouped by country, region, and salesperson, all at the same time?
a. Use the Sort Descending command.
b. Use the Pivot table view command
c. Use the find command on specified groups
d. All of above
Q. The checking operation performed on input data is called the
a. Validation of data
b. Verification of data
c. Cross check
d. Control of data