Font size
WorksheetsMicrosoft Access
Total questions: 20
Worksheet time: 15mins
What is a database?
An organized collection of related data.
A record that stores all the information for one item in a table.
A table that stores information about one specific kind of item in a database.
A column in a table that stores a piece of data for a record.
These are key objects in a database. They contain the data that is stored in the database and are made up of rows and columns.
Table
Report
Query
Form
In a Table, a column is known as a ...
Record
Row
Field
Stage
What is the purpose of a primary key?
To uniquely identify the record
The common field in a child table that maintains relation with the master table
It will ensure that values are entered twice
A common field on which two tables are linked
What are the best match for below data type description?
A simple alphanumeric data type such as names, titles, etc. which is limited to a maximum of 255 characters in length, which is controlled by field size.
Short Text
Long Text
Number
Currency
What is a report in MS Access
A) It is an object in MS-Access that is used to view and print data
B) It is an input screen designed to make the viewing and entering data easier
C) This is an important part of database used by analysts to draw conclusions
D) All of above
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
When working with a database application, what is the function of a wizard?
to complete a task for you
to guide you through the steps required to complete a task
to ensure all default settings are implemented
to suggest the most efficient way to complete a task
Keisha wants to see only winter seasons from her database. What should she use to see and save them?
Filter
Form
Query
A field's data type determines what kind of information can be stored there.
True
False
Which datatype will be used to generate numbers automatically while inserting data?
Number
Automatic Number
Auto number
Integer
Datatype to use for an "AMOUNT" field.
Numeric
Boolean
Currency
Alphanumeric
Click all the views in Microsoft Access database.
Datasheet view
Design view
Form view
Teleview
In a query, we use _____________ to get or filter the data from the database.
Criteria
Crickets
Datatypes
None of the above
Query criteria
Wildcards
Datatypes
Field names
Access offers different views of objects. Which view do you use to edit a table?
Datasheet View
Design View
Table View
Print View
What are the best match for below data type description?
Data values for the years 100 through 9999.
Short Text
Long Text
Date/Time
Currency
What software do you use to make databases?
Access
Excel
PowerPoint
Word
What are four main objects in a database?
Balance, Proximity, Unity, Consistency
Tables, Queries, Forms, Reports
Spell check, Grammar, Ruler, Tools
Cells, Columns, Rows, Entries
A database object that you can use to create a user interface for a database application.
form
report
record
field
