Font size
WorksheetsMS Access class 3
Total questions: 50
Worksheet time: 27mins
DBMS stands for-
Data basic maintenance system
Data base maintenance system
Data base management system
Data base managed system
Ms-Access is a ___________ database
Flat File
Relational
Object Oriented
Flat
Fields in database are similar to _________ in tables.
Rows
Columns
Cells
Values
For unique identification of record, we required a _________ key.
Primary
Secondary
Composite
Alternate
Which view of table is used to insert a field name in table.
Date sheet
Design
Database
all of the above
The default extension of Ms-Access file is __________
.acccdb
.accdb
.abccd
.acbdc
Which option is used to display the data in printable format in MS-Access?
Report
Query
Datesheet
Relationship
Which key is used to define relationship between 2 tables?
Candidate key
Composite key
Primary key
Secondary key
Which datatype will be used to generate numbers automatically while inserting data?
Number
Auto number
Automatic Number
Integer
Tick the Functions of a Database
Updating
Sorting
Editing
Playing
A computerized record keeping system is called as
Communication system
Database management System(DBMS)
Networking System
Which of the following is the correct definition of a Record?
It has only one type of information
Collection of Files
All information about a single entity.
Fields in database are similar to _________ in tables.
Rows
Columns
Cells
Values
Which view of table is used to insert a field name in table.
Date sheet
Design
Database
all of the above
Short currency
Each item from this list is classified as...
Name
Birthdate
Social Security No.
Street
City
State
Zip
table
record
field/Attribute Name
Data Type
Table Rows are called...
fields
records
table
entry
Table Columns are called...
rows
fields
table
form
Which data type would be most suitable for the 'DateofBirth' field?
Currency
Number
Date/Time
Yes/No
Memo
Where do you configure the field properties of a Table?
Design View
Datasheet View
Access View
The best data type to choose for a postcode would be
Number
Text
Date/Time
Currency
Which of the following is the correct definition of a Record?
It has only one type of information
Collection of Files
All information about a single entity.
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
Access can import a table of data from Excel.
True
False
When you close a new table, it asks you for what
name of the file
where to save it
nothing
A unique identifier used in creating a table that assures there will be no duplicate data.
Primary Key
Query
Data Type
MS Access is part of MS Office suite
correct
not correct
Which is the best description of a database?
Stores data
Stores data in a organised structure
Stores data in an organised and logical structure
A collection of fields and records in a specific category
Record
Table
Field
All data related to one item in a table is a ...
Record
Field
Table
MS Access is an automatic database managenent system
true
false
Ms-Access is a ___________ database
Flat File
Relational
Object Oriented
Flat
For unique identification of record, we required a _________ key.
Primary
Secondary
Composite
Alternate
Which view of table is used to insert a field name in table.
Date sheet
Design
Database
all of the above
Which datatype will be used to generate numbers automatically while inserting data?
Number
Auto number
Automatic Number
Integer
A Primary Key is a code that uniquely identifies a _____________ in a Database.
Record
Field
Text
Number
A _________ is a computerized filing system that is used to organize and maintain a collection of information for future use.
Query
Report
Database
Spreadsheet
