Question - 1
Microsoft Access is a _____
RDBMS
Network Database Model
ORDBMS
None of the above
Show Answer
Solutions
Answer- A
Question - 2
Which of the following is not a type of Microsoft access database object?
Table
Macros
Modules
Worksheets
Show Answer
Solutions
Answer- D
Question - 3
The size of yes/no field is always ________
Answer- A
Question - 4
____ are the set Visual Basic procedures and declarations stored as one unit.
Modules
Tables
Reports
Macros
Show Answer
Solutions
Answer- A
Question - 5
In which of the following view, you can’t change the table data?
Pivot table view
Datasheet view
Design view
None of the above
Show Answer
Solutions
Answer- C
Question - 6
Which of the following is database management system software?
MS Excel
MS Access
MS PowerPoint
MS Word
Show Answer
Solutions
Answer- B
Question - 7
Data items groped together for storage purposes are called a
Result
Record
List
All the above
Show Answer
Solutions
Answer- B
Question - 8
Which of the following creates a drop down list of values to choose from?
Lookup wizard
Hyperlink
Clip object
None of the above
Show Answer
Solutions
Answer- A
Question - 9
A ____ enables you to view data from a table based on a specific criterion.
Query
Modules
Reports
Forms
Show Answer
Solutions
Answer- A
Question - 10
The size of a field with number data type can not be _____
Answer- D
Question - 11
Ho can you edit a relationship already established between two tables?
Right click the relationship line and choose Edit Relationship
Double click the relationship line
Both A&B
None of above
Show Answer
Solutions
Answer- C
Question - 12
what can be the maximum length of a text field ?
128
255
527
As much as we can
Show Answer
Solutions
Answer- B
Question - 13
Which is the valid data type in Access?
Currency
Text
Number
All the above
Show Answer
Solutions
Answer- D
Question - 14
The default data type for a field is
Varchar
Text
Number
AutoNumber
Show Answer
Solutions
Answer- B
Question - 15
Which of the following is not a type of relationship that can be applied inAccess database?
One to One
One to Many
Many to Many
All of above
Show Answer
Solutions
Answer- D
Question - 16
In MS Access, which data type is appropriate to store large text and numbers?
Answer- C
Question - 17
In how many views, you can create a table in Access?
Answer- B
Question - 18
Which of the following is a method to createa new table inMS Access?
Using Design View
CreateTable Wizard
Directly Entering Data
All The above
Show Answer
Solutions
Answer- D
Question - 19
Which program do you use to edit code for data access pages?
Microsoft script editor
Microsoft data access pages editor
Microsoft code editor
None of these
Show Answer
Solutions
Answer- A
Question - 20
To switch between to Form view from design view, press
Answer- C
Practice more set questions