Microsoft Access Quiz | Microsoft Access MCQs and Answers

Questions
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
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
junior administrative assistant jaa test series