Computer Quiz 185

1) While Creating a Table using the MS Access, you will get an interface, as shown on the screen this Interface shows, you are Working on the______View
a) Data sheet
b) Design
c) Pivot Table
d) Report

2) Referring to the given Table structure, you should ensure that every record in the_____field should be non-blank and must be unique.
a) Category
b) Cost of Goods
c) Salary
d) ID

3) ______ is a database object that is mainly used to enter and display records and make changes to existing onscreen
a) Query
b) Form
c) Report
d) Input Mask

4) The______field property specifies a value which is automatically entered in a filed when a new record is added in a table.
a) Caption
b) Default Value
c) Input Mask
d) Required

5) All of the following are data types available in MS Access, EXCEPT
a) Boolean
b) Date/Time
c) Hyperlink
d) Currency

6) Refer the image shown on the screen. You can enter maximum 255 characters in the “Category” field.
a) True
b) False

7) You are creating a from using MS Access. While working on the form, you get a view as shown in the given image. Identify the name of this form view.
a) Datasheet View
b) Form View
c) Layout View
d) Design View

8) Refer the image given on the screen, Using this wizard you can generate a report Showing only ID, Category, Sale, Cost of Goods and Salary fields on the screen.
a) True
b) False

9) In MS Access, You can store the information/ records by using______
a) Reports
b) Tables
c) Wizards
d) Buttons

10) Which of the following is not a valid way to add a new table to the database?
a) Select from several premade table themes
b) Create a table in design view
c) Begin entering data into a data sheet
d) Use the table template to create a table

ANSWERS
1-b) Design
2-d) ID
3-b) Form
4-b) Default Value
5-a) Boolean
6-b) False
7-d) Design View
8-a) True
9-b) Tables
10-a) Select from several premade table themes