Microsoft Access Quiz | Microsoft Access Objective Type Questions and Answers

Sports GK Questions and Answers 2024 (Latest Updated)

Awards & Honours GK Questions 2024 (Latest Updated)

Questions
21 A __________ enables you to view data from a table based on a specific criterion
A Form
B Query
C Macro
D Report

Answer: Query
22 The expression builder is an access tool that controls an expression___ for entering an expression
A Table
B Box
C Cell
D Palette

Answer: Box
Advertisement
Article and Schedule Quiz Start Test!
DOWNLOAD CURRENT AFFAIRS PDF FROM APP
23 The__ button on the tool box display data from a related table
A Sub form sub report
B Relationships
C Select objects
D More controls

Answer: Sub form sub report
24 Which of the following database object hold data?
A Forms
B Reports
C Queries
D Tables

Answer: Tables
25 Which is not a view to display a table in Access?
A Datasheet View
B Design View
C Pivot Table & Pivot Chart View
D None of above

Answer: None of above
26 Which of the field has width 8 bytes?
A Memo
B Number
C Date/Time
D Hyperlink

Answer: Date/Time
27 Which of the following is NOT a type of Microsoft Access database object?
A Table
B Form
C Worksheets
D Modules

Answer: Worksheets
28 In table design view, which key can be used to switch between the field names and properties panels?
A F3
B F4
C F5
D F6

Answer: F6
29 Following is not a database model
A network database model
B relational database model
C Object Oriented database model
D None

Answer: None
30 To create queries in Access
A You can drag and drop fields on query builders
B you can type the SQL command in SQL view
C You can use query wizard or design view
D All of above

Answer: All of above
31 This option allows you to build a new table by entering data directly into the datasheet.
A datasheet view
B design view
C link table
D None of the above

Answer: datasheet view
32 Which of the following is not a type of relationship that can be applied in Access database
A One to One
B One to Many
C Many to Many
D All of above can be applied

Answer: All of above can be applied
33 What does the show check box in query design window indicate
A It indicates whether the field is to be used or not
B It indicates whether the field is to be displayed in query result or not
C It indicates whether the field names to be displayed in query result or not
D None of above

Answer: It indicates whether the field is to be displayed in query result or not
34 In table design view what are the first column of buttons used for
A Indicate Primary Key
B Indicate Current Row
C Both of above
D None of above

Answer: Both of above
35 Which field type will you select when creating a new table if you require to enter long text in that field?
A Text
B Memo
C Currency
D Hyperlink

Answer: Memo
36 To duplicate a controls formatting you can use___
A Manager
B Wizard
C Painter
D Control

Answer: Painter
37 After entering all fields required for a table, if you realize that the third field is not needed, how will you remove?
A You need to delete the whole tablThere is no method to remove a particular field only.
B Delete all the fields from third downwards and reenter the required fields again.
C Select the third column in datasheet view then Delete
D Select the third row in table design view then Delete

Answer: Select the third row in table design view then Delete
38 To create relationship between two tables
A drag the primary key of a table into foreign key of another table
B drag the foreign key of a table into the primary key of another table
C drag any field from parent table and drop on child table
D Any of above can be done to create relationship

Answer: drag the primary key of a table into foreign key of another table
39 To sort records in a table
A Open table, click on the field on which the sorting is to be done, then click Sort button on database toolbar
B Open table, click Sort button on database toolbar, choose field based on which to sort, click OK
C Click the field heading to sort it ascending or descending
D All of above

Answer: Open table, click on the field on which the sorting is to be done, then click Sort button on database toolbar
40 How can you define a field so that when entering data for that field it will display ****** instead of actual typed text
A Input mask
B Validation Rule
C Indexed
D IME Mode

Answer: Input mask
Assam Direct Recruitment Test Series

Teacher Eligibility Test

Assam Direct Recruitment Test Series