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