Top 550+ Solved Microsoft Access (MS Access) MCQ Questions Answer
Q. Which action will optimize your database performance?
a. Set the record set type to snapshot
b. Use the compact and repair database tool
c. Create a replica of the database
d. All of the above
Q. The arranging of data in a logical sequence is called
a. Sorting
b. Classifying
c. Reproducing
d. Summarizing
Q. According to access help, what’s a good way to design a database?
a. Start from data access pages and work backward
b. Sketch the design of your database using a pencil and paper
c. Use the table analyzer to reverse-engineer your flat source data.
d. None of above
Q. If a piece of data is stored in two places in the database, then
a. Storage space is wasted
b. Changing the data is one spot will cause data inconsistency
c. It can be more easily accessed
d. Both a and b
Q. A relational database management (RDBMS) package manages data in more than one file at once. How does it organize these file? As
a. Tables
b. Relations
c. Tuple
d. Both a and b
Q. Which of the following database objects asks a question of information in a database and then displays the result?
a. Tables
b. Reports
c. Queries
d. Forms
Q. What data type should yo choose for a zip code field in a table?
a. Text
b. Number
c. Memo
d. All of above
Q. In order to use dbms, it is important to understand
a. The physical schema
b. All sub schemas that the sytem supports
c. One sub schema
d. Both a and b
Q. A list consists of last names, first names, address and pin codes if all people in the list have the same last and the same pin code, a useful key would be
a. The pin code
b. The last name
c. A compound key consisting of the first name and the last name
d. All of the above
Q. What happens when you add the asterisk (*) from any field list ot a query?
a. The table will not include any fields from the table
b. The query sorts the table’s record in the order you specify
c. The query will include every field from the table
d. The query uses the records from the table without displaying them
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 ablve
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 report summary 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