No student devices needed. Know more
30 questions
A computerized record keeping system is called as
Communication system
Database management System(DBMS)
Networking System
6. What function enables you to ask questions about the data stored in a database and returns the answers based on your criteria?
Query
Form
Report
Table
Access can import a table of data from Excel.
True
False
A unique identifier used in creating a table that assures there will be no duplicate data.
Primary Key
Query
Data Type
DBMS stands for-
Data basic maintenance system
Data base maintenance system
Data base management system
Data base managed system
Fields in database are similar to _________ in tables.
Rows
Columns
Cells
Values
What you understand by data redundancy?
Assurance of the accuracy of data
Duplicate values in database
Security of Data
None of these
Which view of table is used to insert a field name in table.
Design View
Datasheet View
All of these
Which datatype will be used to generate numbers automatically while inserting data?
Number
Auto number
Integer
Lookup
Which option is used to display the data in printable format in MS-Access?
Report
Query
Form
Module
What TAB is used to Create a Report, a Query, a Form or another Table?
Design
Home
Database Tools
Create
Which field property gives an alternate name to the field?
Validation Rule
Input Mask
Caption
Format
Which datatype displays a drop down list to choose one of the values?
Attachment
OLE object
Lookup Wizard
Short Text
In Access, the short text can be upto ______________
2048 characters
65,535 characters
255 characters
30 characters
When you organize data alphabetically or in numerical order. What are you doing?
Filtering
Sorting
Query
None of these
You can find field definition grid and field properties in this table view.
Design
Datasheet
Both
None of these
Which field property does not allow prohibited values to be entered in the database?
Input mask
Validation rule
Caption
Field size
Which field property can be used to facilitate data entry like phone number?
Input mask
Validation rule
Field Format
Field size
Which is not true for field name?
Field name cannot start with a space
It allows use of periods
It can be Upper, Lower or Mixed cases
Underscore is allowed
The default file type for a document in MS Access is _______________
.accdb
.xls
.xml
.txt
Which field would be the primary key in the table?
Book ID
Title
Author
Any of these
Which database object allows you to enter data in a customized format?
table
module
query
form
The validation rule to display marks within the range of 0 to 300 would be .....................
>=0 and <=300
>0 and <300
0 and 300
Any of these
Which feature in Access 2013 helps to find out the sum, count, average etc. on the data?
ΣTotals
ΣAutosum
a. How many records are they?
What option locks the selected fields to the left and makes them appear even when you scroll?
Freeze
Sort
Filter
Hide
By default, which is the first field created in a new table in Access 2013?
Id
Field1
Name
None of these
In Access 2013, the title bar appears at the top of the window.
T
F
A specific piece of information in a table is called a ...............................
DATA
VALUE
FIELD
RECORD
A caption field property allows up to .............................. characters
2048
1024
65535
255
Explore all questions with a free account