WorksheetsMS-Access
Total questions: 41
Worksheet time: 2hrs 46mins
What software do you use to make databases?
Access
Excel
PowerPoint
Word
In your database, information is stored in the ...
Table
Report
Query
Form
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
In a Table, a column is known as a ...
Record
Garden
Field
Stage
Records in a table can be updated any time.
True
False
Which object would you create to share the data from your database with others?
Form
Report
Query
Table
One example of a database would be ...
grocery list
stamp collection
movie collection
cell phone contact list
Access offers different views of objects. Which view do you use to edit a table?
Datasheet View
Design View
Table View
Print View
In a Table, a row is known as a ...
File
Field
Record
Stage
The best way to edit and update your data is in a ...
Report
Form
Query
Table
An organized collection of information about a subject is a ...
database
table
file
record
These store information in records and fields.
Tables
Forms
Queries
Reports
These provide printable views of table or query data that you can share.
Tables
Forms
Queries
Reports
These provide printable views of table or query data that you can share.
Tables
Forms
Queries
Reports
These provide data entry and lookup.
Tables
Forms
Queries
Reports
The most common way to look at a table in Access is ...
Datasheet View
Design View
Table View
Print View
These sort, filter, and summarize data.
Tables
Forms
Queries
Reports
Multiple tables that are related to each other is known as ...
Access Database
Relational Database
Database Tables
Informational Database
A table is divided into __________________
field and form
fields and records
datasheet and design
record and form
A table is divided into __________________
field and form
fields and records
datasheet and design
record and form
A __________ helps us to keep the information in our database structured
Primary Key
Record
Autonumber
Field
Which of these options is the best to use for a primary key?
Number
Currency
Short Text
Autonumber
We have two kinds of view in Access. Datasheet view and (a) view.
A collection of words, numbers or pictures with meaning is known as (a)
When moving from top to bottom in a database, you are on a (a)
Which view can be used to enter data into the database?
Design View
Record View
Field View
Form View
In Microsoft Access, a field labelled “Price” must be created as
Currency
Primary Key
Number
Short Text
Which of these is not an example of a field type?
Picture
Short Text
Date and Time
Yes/No
1. Data _____________ refers to ensuring accuracy and consistency of data.
Integrity
Collation
Assessment
System
A request for data results from a database or for action on the data.
query
table
file
record
A database object that you can use to create a user interface for a database application.
form
report
record
field
This can offer a way to view, format, and summarize the information in your Microsoft Access database.
query
table
form
report
record
A group of fields, such as a telephone number, address and name, which are pertinent to a particular item. These are also known as rows.
query
field
report
records
A piece of information related to a single person or thing; also known sometimes as columns.
table
query
form
field
A field or set of fields with values that are unique throughout a table.
primary key
foreign key
database
record
The properties of a field describe the characteristics and behavior of data added to that field.
database
data type
field
record
An organized collection of structured information, or data, typically stored electronically in a computer system.
database
record
primary key
foreign key
In a database, the rows are also known as
fields
records
tables
forms
What is a database?
A collection of books
A collection of information stored electronically.
A purse with a base
All of the above
What is the purpose of a primary key?
To uniquely identify the record
To take telephone numbers and lock then
It will ensure that values are entered twice
How would you define a Query?
Created to see tables better
Allow you to retrieve data from tables
The wizard allows you to go step by step
