JOIN ADRE 2.0 Telegram Group

Microsoft Access Quiz | Microsoft Access Short Questions and Answers

Questions
41 Unlike text data type, this can store up to maximum of 65, 535 characters.
A memo
B data/time
C number
D All of above

Answer: memo
42 We can remove a relationship defined between two tables by
A From Edit menu choose Delete Relationship
B Select the relationship line and press Delete
C Choose Delete option from Relationship menu
D All of above

Answer: Select the relationship line and press Delete
Advertisement
Article and Schedule Quiz Start Test!

DOWNLOAD CURRENT AFFAIRS PDF FROM APP

43 It is a sign or symbol that specifies, operator, and values that produce a result
A operator
B query
C expression
D None of the above

Answer: operator
44 You can automatically include all of the field in a table in a query by___ a strike that appear list box in query design view
A Clicking
B Right clicking
C Double clicking
D None of the above

Answer: Double clicking
45 What is a form in MS Access
A It is a printed page where users will write their data to fill it up
B It is an input screen designed to make the viewing and entering data easier
C This is an important part of database used by analysts to draw conclusions
D All of above

Answer: It is an input screen designed to make the viewing and entering data easier
46 What are the columns in a Microsoft Access table called?
A Rows
B Records
C Fields
D Columns

Answer: Fields
47 A search value can be an exact value or it can be
A Logical Operator
B Relationship
C Wild card character
D Comparison operation

Answer: Wild card character
48 To achieve AND effect when you are entering criteria in a query design window
A write criteria values vertically one in a row
B write criteria values horizontally
C Write criteria values in same field separated with AND
D Write criteria values in same field separated with &

Answer: write criteria values horizontally
49 Which of the following creates a drop down list of values to choose from a list?
A OLE Object
B Hyperlink
C Memo
D Lookup Wizard

Answer: Lookup Wizard
50 It is a database object to view, change, and analyze data in different ways
A query
B form
C report
D None of the above

Answer: query
51 When entering field name, how many characters you can type in maximum?
A 60
B 64
C 68
D Any number of character

Answer: 64
52 Which of the following is not a field type in Access
A Memo
B Hyperlink
C OLE Object
D Lookup Wizard

Answer: Lookup Wizard
53 It is an association established between common fields of two tables.
A line
B relationship
C primary key
D records

Answer: relationship
54 A __ name must be unique within a database
A Table
B Field
C Record
D Character

Answer: Table
55 Referential integrity means
A Do not enter a value in the foreign key field of a child table if that value does not exist in the primary key of the parent table
B Do not enter a value in the primary key field of child table if that value does not exist in the primary key of the parent table
C Do not enter a value in the foreign key field of a parent table if that value does not exist in the primary key of the child table
D All of above

Answer: Do not enter a value in the foreign key field of a child table if that value does not exist in the primary key of the parent table
56 The database language that allows you to access or maintain data in a database
A DCL
B DML
C DDL
D None of above

Answer: DML
57 You can set a controls border type to make the border invisible.
A Transparent
B Invisible
C Do not display
D No border

Answer: Do not display
58 Cascade update option
A means do not change the value in the primary key field if that record has related records in another table
B means change all the related records in child tables if the record in parent table is changed
C Both of above
D None of above

Answer: Both of above
59 The default and maximum size of text field in Access
A 50 and 255 Characters
B 8 and 1 GB
C 266 characters & 64000 characters
D None of above

Answer: 50 and 255 Characters
60 Which of the following database object produces the final result to present?
A Forms
B Reports
C Queries
D Tables

Answer: Reports

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