Quizzes
Search
Take Quizzes
Animal
Nutrition
Love
Relationship
Computer
Sports
Society
Business
Geography
Language
Personality
Harry Potter
Movie
Television
Music
Online Exam
Health
Country
Art
Entertainment
Celebrity
Math
Game
Book
Fun
Science
Food
History
Education
All Topics
Create a Quiz
Quiz Maker
Training Maker
Survey Maker
Flashcards
Brain Games
See All
ProProfs.com
Search
Create A Quiz
Take Quizzes
Animal
Nutrition
Love
Relationship
Computer
Sports
Society
Business
Geography
Language
Personality
Harry Potter
Movie
Television
Music
Online Exam
Health
Country
Art
Entertainment
Celebrity
Math
Game
Book
Fun
Science
Food
History
Education
All Topics
Products
Quiz Maker
Training Maker
Survey Maker
Flashcards
Brain Games
See All
ProProfs.com
Quizzes
Quizzes
Final Exam Access
25 Questions
|
By Catherine Halcomb | Updated: Mar 21, 2022
| Attempts: 248
Share
Start
Share on Facebook
Share on Twitter
Share on Whatsapp
Share on Pinterest
Share on Email
Copy to Clipboard
Embed on your website
Question
1
/ 25
0 %
0/100
Score
0/100
1.
________________________________ are used to create a new report
Submit
Start Quiz
About This Quiz
.
2.
What's your name?
We’ll put your name on your report, certificate, and leaderboard.
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
Submit
3.
Table- The central framework of a database that stores data in fields (columns) and records (rows).
True
False
Submit
4.
Which is the valid data type in Access?
Number
Text
Currency
All of the above
Submit
5.
Which is the valid data type in Access?
Number
Text
Currency
All of the above
Submit
6.
Which leads you through the process of creating a table?
Wizard
Assistant
Relation
Coach
Submit
7.
There are three types of relationships in Microsoft Access: One-to-many Many-to-many One-to-one
True
False
Submit
8.
Is [your statement here] true or false?
True
False
Submit
9.
Table, Query, Form, Report, Macro and Module are the objects in Ms Access
True
False
Submit
10.
What is an intersection of a row and a column?
Form
Cursor
Cell
Record
Submit
11.
Which of the following is not a valid Data Type in MS Access?
Memo
Picture
Currency
AutoNumber
Submit
12.
Which of the following is not a view for interacting with a form object?
Datasheet view
Design view
Form view
Layout view
Submit
13.
A report is graphical interface used for data entry.
True
False
Submit
14.
Which data type is better to use for storing the price of an item?
Text
AutoNumber
Number
Currency
Submit
15.
In MS Access "Hyperlink" Data Type can store
Web Address
Email Address
Path of a file
All of the above
Submit
16.
Which of the following is not a view for interacting with a form object?
Datasheet view
Design view
Form view
Layout view
Submit
17.
Match the following
Record
Select a Match
A single set of data values pertaining to an entity
An item of data
Category of information represented by a column or cell in a table pertaining to all records
Field
Select a Match
A single set of data values pertaining to an entity
An item of data
Category of information represented by a column or cell in a table pertaining to all records
Value
Select a Match
A single set of data values pertaining to an entity
An item of data
Category of information represented by a column or cell in a table pertaining to all records
Submit
18.
Which object is used to create a form?
Tables and Queries
Tables only
Tables and reports
Queries and reports
Submit
19.
What determines a table's sort order?
Primary key
Field order
Index field
AutoNumber field
Submit
20.
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
Submit
21.
In MS Access, AutoNumber Data Type
Can be Sequential
Can be Random
Can be Edited
Only A & B
Submit
22.
Which of the following views enables you to enter values in to a table?
Design
Datasheet
Database
Layout
Submit
23.
Which criteria return only those addresses beginning with the letter "K"?
Address = “K”
Address = “K*”
Address = “K?”
Address = “K#”
Submit
24.
Which data type is better to use for storing phone number in the following format "977-1-1234567"?
Text
AutoNumber
Number
Currency
Submit
25.
Ms Access is a software to manage data to produce information which is called Database Management System or DBMS
True
False
Submit
View My Results
Related Quizzes
CCNA Final Exam 1
CCNA Final Exam 1
Language Arts 7 Final
Language Arts 7 Final
12g English Final Exam
12g English Final Exam
Thank you for your feedback!
Would you like to edit this question to improve it?
No thanks
Name:
Email:
Oops! Give us more information:
Incorrect Question
Incorrect Answer
Typos
I have a feedback
Submit
Please provide name and email to proceed.
Please provide correct email to proceed.
Please provide feedback.
Please select the option.
All (25)
Unanswered (
)
Answered (
)
________________________________ are used to create a new report
It is important to assign appropriate data types to a field...
Table- The central framework of a database that stores data in fields...
Which is the valid data type in Access?
Which is the valid data type in Access?
Which leads you through the process of creating a table?
There are three types of relationships in Microsoft Access:...
Is [your statement here] true or false?
Table, Query, Form, Report, Macro and Module are the objects in Ms...
What is an intersection of a row and a column?
Which of the following is not a valid Data Type in MS Access?
Which of the following is not a view for interacting with a form...
A report is graphical interface used for data entry.
Which data type is better to use for storing the price of an item?
In MS Access "Hyperlink" Data Type can store
Which of the following is not a view for interacting with a form...
Match the following
Which object is used to create a form?
What determines a table's sort order?
How to make a date field DOB store the dates like "2002/10/17" ?
In MS Access, AutoNumber Data Type
Which of the following views enables you to enter values in to a...
Which criteria return only those addresses beginning with the letter...
Which data type is better to use for storing phone number in the...
Ms Access is a software to manage data to produce information ...
X
OK
X
OK
Cancel
X
OK
Cancel
Back to top
Back to top
Advertisement