Top 550+ Solved Microsoft Access (MS Access) MCQ Questions Answer
Q. Which of the following queries modifies fields not records?
a. Append
b. Delete
c. Make-Table
d. Update
Q. A summary query can be created by adding which row to the design grid of a select query?
a. Arguments
b. Group
c. Summary
d. Total
Q. Which of the following functions is used to all the values in a numeric field?
a. Num
b. Count
c. Sum
d. Total
Q. In a query, which row do you need to place wildcards to affect a parameter?
a. Arguments
b. Criteria
c. Fields
d. Tables
Q. Which of the following types of joins displays records with the same value in the common field?
a. Inner join
b. Left outer join
c. Right outer join
d. Self join
Q. A global join will be created automatically when using tables in a(n) _____.
a. form
b. report
c. query
d. field
Q. Which of the following is the default join between two recordsets?
a. Inner join
b. Left outer join
c. Right outer join
d. Self join
Q. In a query\'s Design View, right-clicking the sloping portion of the join line between two tables and selecting Delete will delete what?
a. The join line but not the relationship between the two tables
b. The relationship between the two tables locally
c. The relationship between the two tables globally
d. The primary key of the first table
Q. What is an index?
a. A wizard that creates a functional database structure based on the user\'s selections
b. A widely recognized naming convention for database objects
c. A sort order for records, which is identified in the table design
d. A set of relationship rules that enforce defined database relationships
Q. You created a query with two tables that did NOT have a join line. The first table has 12 records and the second has 5. The resulting recordset would have how many records?
a. 7
b. 17
c. 60
d. Not enough information to tell
Q. Which of the following dialog boxes enables users to enforce referential integrity in a One-To-Many relationship?
a. Edit Relationships
b. Indexes
c. Option
d. Show Table
Q. In a junction table, the _____ field consists of the foreign key from both the linked tables.
a. first defined
b. last defined
c. foreign key
d. primary key
Q. What does an inner join display?
a. Records from the second recordset and only records from the first recordset where the common fields are equal
b. Records from the first recordset and only records from the second recordset where the common fields are equal
c. Records that have the same value in the common field
d. Records from the first recordset only