NEW
Font size
WorksheetsMS ACCESS 2010
Total questions: 30
Worksheet time: 30mins
What is a Primary key?
Foreign Key
Unique Key
Database key
all of the above
What is the Extension of MS ACCESS 2010?
.accdb
.acdb
acdb
dbacc
To Create a table in MS ACCESS click on
Table view
create
Open
none of these
____________ is used to store alphanumeric datatype?
Numbers
currency
Text
none of these
What are the different data types in MS ACCESS 2010?
Memo
text
numbers
date/ time
all of the above
A database helps you to organise the collected data in a _____format in a systematic manner
tabular
linear
The _______of the table are called records
rows
column
A computerized record keeping system is called as
Communication system
Database management System(DBMS)
Networking System
Full form of RDBMS is
Relational Database Management System
Rotational Database Maintenance System
Record Management System
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
Ms Access store related entries in it's row, which is called________
Record
Field
Form
Table
The four main objects of a relational database consist of:
form, table, query, report
form, table, database, query
form, sort, table, report
form, column, row, report
Data redundancy means
Duplicate data
Not Duplicated
None of these
Each item from this list is classified as...
Name
Birthdate
Social Security No.
Street
City
State
Zip
table
record
field/Attribute Name
Data Type
Which data type would be most suitable for the 'DateofBirth' field?
Currency
Number
Date/Time
Yes/No
Memo
When you organize data alphabetically or in numerical order. What are you doing?
Filtering
Sorting
Query
Form
Where do you configure the field properties of a Table?
Design View
Datasheet View
Access View
Which of the following best describes the results of the query shown?
Returns the school names of the athletes in the competetion
Returns the AthleteNumbers from Bogtown College
Returns the names of the athletes from Bogtown College
Return the names of the Athletes from each school
What is the Extension of MS ACCESS 2010?
.accdb
.acdb
acdb
dbacc
Which one the correct logo of ms Access?
