Final Exam Access
Settings
.
- 1.What is a table?
- 2.In MS Access, AutoNumber Data Type
- A.
Can be Sequential
- B.
Can be Random
- C.
Can be Edited
- D.
Only A & B
- 3.Which object is used to create a form?
- A.
Tables and Queries
- B.
Tables only
- C.
Tables and reports
- D.
Queries and reports
- 4.What determines a table’s sort order?
- A.
Primary key
- B.
Field order
- C.
Index field
- D.
AutoNumber field
- 5.Which of the following is not a view for interacting with a form object?
- A.
Datasheet view
- B.
Design view
- C.
Form view
- D.
Layout view
- 6.There are three types of relationships in Microsoft Access: One-to-many Many-to-many One-to-one
- A.
True
- B.
False
- 7.Which is the valid data type in Access?
- A.
Number
- B.
Text
- C.
Currency
- D.
All of the above
- 8.Table, Query, Form, Report, Macro and Module are the objects in Ms Access
- A.
True
- B.
False
- 9.Table- The central framework of a database that stores data in fields (columns) and records (rows).
- A.
True
- B.
False
- 10.________________________________ are used to create a new report
- 11.What is an intersection of a row and a column?
- A.
Form
- B.
Cursor
- C.
Cell
- D.
Record
- 12.Which of the following is not a view for interacting with a form object?
- A.
Datasheet view
- B.
Design view
- C.
Form view
- D.
Layout view
- 13.Which is the valid data type in Access?
- A.
Number
- B.
Text
- C.
Currency
- D.
All of the above
- 14.It is important to assign appropriate data types to a field since they specify what type of data can be entered into a field.
- A.
True
- B.
False
- 15.Which data type is better to use for storing phone number in the following format “977-1-1234567”?
- A.
Text
- B.
AutoNumber
- C.
Number
- D.
Currency
- 16.Which criteria return only those addresses beginning with the letter “K”?
- A.
Address = “K”
- B.
Address = “K*”
- C.
Address = “K?”
- D.
Address = “K#”
- 17.How to make a date field DOB store the dates like “2002/10/17” ?
- A.
By setting the input mask property to “yyyy/mm/dd”
- B.
By setting the format property to “yyyy/mm/dd”
- C.
By entering dates in yyyy, mm, dd order
- D.
None of the above
- 18.Which leads you through the process of creating a table?
- A.
Wizard
- B.
Assistant
- C.
Relation
- D.
Coach
- 19.Which data type is better to use for storing the price of an item?
- A.
Text
- B.
AutoNumber
- C.
Number
- D.
Currency
- 20.Ms Access is a software to manage data to produce information which is called Database Management System or DBMS
- A.
True
- B.
False
- 21.Which of the following is not a valid Data Type in MS Access?
- A.
Memo
- B.
Picture
- C.
Currency
- D.
AutoNumber
- 22.In MS Access “Hyperlink” Data Type can store
- A.
Web Address
- B.
Email Address
- C.
Path of a file
- D.
All of the above
- 23.Which of the following views enables you to enter values in to a table?
- A.
Design
- B.
Datasheet
- C.
Database
- D.
Layout
- 24.A report is graphical interface used for data entry.
- A.
True
- B.
False
- 25.Is [your statement here] true or false?
- A.
True
- B.
False
Back to top