(A) Previous button
(B) Next button
(C) First page button
(D) Last page button
Tag: MS Access Mcq Questions
Which of the following is the default join between two record sets?
(A) Right outer join
(B) Left outer join
(C) Self join
(D) Inner join
A global join will be created automatically when using tables in a?
(A) Report
(B) Query
(C) Field
(D) Form
In a query which row do you need to place wildcards to affect a parameter?
(A) Criteria
(B) Fields
(C) Arguments
(D) Tables
Which query can create a table?
(A) Update
(B) Make-Table
(C) Delete
(D) Append
Which of the following functions is used to all the values in a numeric field?
(A) Total
(B) Sum
(C) Count
(D) Num
A summary query can be created by adding which row to the design grid of a select query?
(A) Group
(B) Arguments
(C) Total
(D) Summary
Which of the following queries modifies fields not records?
(A) Make-Table
(B) Delete
(C) Append
(D) Update