Microsoft Access Quiz | Microsoft Access Short Questions and Answers

Sports GK Questions and Answers 2024 (Latest Updated)

Awards & Honours GK Questions 2024 (Latest Updated)

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
Assam Direct Recruitment Test Series

Teacher Eligibility Test

Assam Direct Recruitment Test Series