GkSeries.com

Microsoft Access Quiz | Microsoft Access MCQs and Answers

Download PDF

Free download in PDF Microsoft Access MCQs and Answers for competitive exams. These short objective type questions with answers are very important for Board exams as well as competitive exams. These short solved questions or quizzes are provided by Gkseries.
Go To Download Page
81 How can you link a table with another so that a field in current table will display values in drop down box from another table while entering data:
[A] Query Wizard
[B] Look up Wizard
[C] Form Wizard
[D] Report Wizard
Answer: Look up Wizard
82 To create primary key for a table when in design view
[A] Type PRIMARY in field type box when creating required field
[B] Mark the Primary check box in field name of required field
[C] Click the Primary Key button in Design ribbon when the cursor is in required field
[D] None of the above
Answer: Click the Primary Key button in Design ribbon when the cursor is in required field

DOWNLOAD CURRENT AFFAIRS PDF FROM APP

83 A primary key in any table has the properties
[A] Not Null
[B] No Duplicates
[C] Both of above
[D] None of above
Answer: Both of above
84 A composite key is
[A] Required when a table does not have any unique fields in it
[B] The primary key with AutoNumber as the field type
[C] Made up of two or more fields to uniquely identify records
[D] Is a foreign key that uniquely identifies records
Answer: Made up of two or more fields to uniquely identify records
85 If I create ‘Student’ field in ‘Fees’ table to store ‘student_id’ of ‘Students’ table, then this ‘Student’ field in ‘Fees’ table is called:
[A] Foreign key
[B] Native key
[C] Composite key
[D] Primary key
Answer: Foreign key
86 Every table in relational database contain a field or combination of fields that can uniquely identify each records, it is called
[A] Foreign key
[B] Native key
[C] Composite key
[D] Primary key
Answer: Primary key
87 Which of the following expresses correct order?
[A] Characters, Fields, Records, Tables, Files, Databases
[B] Characters, Fields, Records, Tables, Database, Files
[C] Databases, Tables, Files, Records, Field, Character
[D] Files, Databases, Tables, Records, Fields, Characters
Answer: Characters, Fields, Records, Tables, Files, Databases
88 An Access database object that is used to enter, view or edit records
[A] Table
[B] Form
[C] Query
[D] Report
Answer: Form
89 Which of the following can be an example of a database?
[A] Address book of all the suppliers of a company
[B] Salary sheet of all the employees of a company
[C] Records of daily sales transactions of a company
[D] All of above
Answer: All of above
90 Database Management Systems are featured with:
[A] The facility to easy editing, spelling check, auto pagination, lay out and printing reports
[B] The ability to store large amount of data to facilitate easy update, sort and retrieval
[C] The ability to calculate efficiently with the help of built-in functions and analyze
[D] All of above
Answer: The ability to store large amount of data to facilitate easy update, sort and retrieval
91 The complete information about an entity in a database is called
[A] Data
[B] Information
[C] Field
[D] Record
Answer: Record
92 A database object in MS Access that stores a question about the data in database?
[A] Table
[B] Form
[C] Query
[D] Report
Answer: Query
93 Which of the following is not a database object in MS Access?
[A] Tables
[B] Query
[C] Report
[D] Relationship
Answer: Relationship
94 Each record is constituted by a number of individual data items which are called
[A] Fields
[B] Data Types
[C] Relations
[D] Tables
Answer: Fields
95 The task of arranging data in order is called
[A] Searching
[B] Sorting
[C] Ordering
[D] Shorting
Answer: Sorting
96 Collection of related records in a database is known as
[A] File
[B] Bench
[C] Table
[D] Relationship
Answer: Table
97 Which of the following term is least related to database?
[A] Attributes
[B] Tuples
[C] Relationship
[D] Columns
Answer: Columns
98 A database can be best described as
[A] Organized collection of data
[B] Useful presentation of data
[C] Graphical representation of data
[D] All of above
Answer: Organized collection of data
99 Which of the following may not be a database?
[A] Data presented in table in MS Word document
[B] Data entered in Excel spreadsheet
[C] A presentation created in PowerPoint
[D] A telephone diary
Answer: A presentation created in PowerPoint
100 A part of database that stores only one type of data is
[A] Report
[B] Field
[C] Query
[D] Record
Answer: Field

Please share this page

Click Here to Read more questions

Teacher Eligibility Test