Microsoft Access Quiz | Microsoft Access Multiple Choice Questions with Answers

Sports GK Questions and Answers 2024 (Latest Updated)

Awards & Honours GK Questions 2024 (Latest Updated)

Questions
61 What do you mean by one to many relationship between Student and Class table?
A One student can have many classes
B One class may have many student
C Many classes may have many students
D Many students may have many classes

Answer: One student can have many classes
62 The key uniquely identifies each record in a table.
A primary key
B key word
C filed name
D All of above

Answer: primary key
Advertisement
Article and Schedule Quiz Start Test!
DOWNLOAD CURRENT AFFAIRS PDF FROM APP
63 If you write criteria values vertically (one in a row) it will mean
A OR conditions
B AND conditions
C NOT condition
D None of above

Answer: OR conditions
64 Both conditions display on the same row in the design grid when ___operator is in use
A OR
B IN
C AND
D LIKE

Answer: AND
65 Which of the following store command to retrieve data from database?
A Forms
B Reports
C Queries
D Tables

Answer: Queries
66 DCL provides commands to perform actions like
A Change the structure of tables
B insert, update or delete records and data values
C authorizing access and other control over database
D None of above

Answer: authorizing access and other control over database
67 If you need to edit a relationship
A Right click the relationship line and choose Edit Relationship
B Double click the relationship line
C Both of above
D None of above

Answer: Both of above
68 Microsoft Access is a
A RDBMS
B OODBMS
C ORDBMS
D Network database model

Answer: RDBMS
69 Which of the following statement is true?
A Foreign key fields don’t allow duplicate values
B In primary key field you can enter duplicate value
C In an indexed field you may or may not enter duplicate value depending upon setting
D All statements are true

Answer: In an indexed field you may or may not enter duplicate value depending upon setting
70 What is the maximum length a text field can be?
A 120
B 255
C 265
D 75

Answer: 255
71 It is used to calculate and restructure data for easier analysis of your data. It calculates the sum,
A Parameter
B Select
C crosstab
D Append

Answer: crosstab
72 It is a query that when run displays its own dialog box prompting you for information, such as
A Select
B crosstab
C Parameter
D Append

Answer: Parameter
73 Which of the following statement is true
A Reports can be used to retrieve data from tables and calculate
B Queries can be printed in well formatted manner and presented as the information
C Queries can include calculated fields that do not exist in table
D Reports and forms are similar but forms are use to print but reports to display on screen only

Answer: Queries can include calculated fields that do not exist in table
74 What is the difference between ‘Open’ and ‘Open Exclusively’?
A Open statement opens access database files and Open Exclusively opens database files of other program like Oracle
B Open Exclusive locks whole database so that no one can access it whereas Open locks only the record that is being accessed
C Both Open and Open Exclusively are same
D Open Exclusive command does not exist in MS Access

Answer: Open Exclusive locks whole database so that no one can access it whereas Open locks only the record that is being accessed
75 It is most common type of query. It retrieves records from one or more tables and then displays the
A Parameter
B Select
C crosstab
D All of above

Answer: Select
76 Which of the following is a method to create a new table in MS Access?
A Create table in Design View
B Create Table using wizard
C Create Table by Entering data
D All of above

Answer: All of above
77 While creating relationship, when you drag a field of a field to drop into another table the mouse pointer changes into
A a doctor’s sign
B thin + sign
C outline rectangle
D None of above

Answer: outline rectangle
78 Queries in Access can be used as
A view, change and analyze data in different ways
B a source of records for forms and reports
C Only a
D Both a and b

Answer: Both a and b
79 Which field type can store photos?
A Hyperlink
B OLE
C Both of these can be used
D Access tables can’t store photos

Answer: OLE
80 The___ operator will cause a record to be selected only if two or more conditions are satisfied
A Or
B If or
C Range
D And

Answer: And
Assam Direct Recruitment Test Series

Teacher Eligibility Test

Assam Direct Recruitment Test Series