JOIN ADRE 2.0 Telegram Group

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
Advertisement
Article and Schedule Quiz Start Test!

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

ADRE 2.0 FULL LENGTH MOCK TEST

Take Mock Tests

Missiles Mock Test Start Test!
SSC MTS Mock Test Start Test
IBPS CLERK MOCK TEST Start Test
SSC MTS 2022 JULY 26 Shift 1 (ENGLISH) Start Test!
SSC GD Previous Year Paper 2021 Nov 17 Shift - I (Hindi) Start Test!
SSC CGL Tier - 1 PYP 2022 April 21 Shift- 1 (ENGLISH) Start Test!
MPSC PAPER I MOCK TEST 1 (ENGLISH) Start Test!
IB Security Assistant Mock test 1 (english) Start Test!
UP POLICE CONSTABLE MOCK TEST 1 Start Test!
DELHI POLICE CONSTABLE MOCK TEST 1 (HINDI) Start Test!
Advertisement
Assam Direct Recruitment Test Series