(A) Previous button
(B) Next button
(C) First page button
(D) Last page button
Category: MS Access Mcqs
MS Access Mcqs for NTS, PPSC, FPSC, SPSC, KPPSC, AJKPSC, PMS, PTS, Data Entry Operator, Computer Operator and all computer related exams.
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