WorksheetsMS Access Databases
Total questions: 40
Worksheet time: 47mins
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
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
A table is divided into __________________
field and form
fields and records
datasheet and design
record and form
Which of these options is the best to use for a primary key?
Number
Currency
Short Text
Autonumber
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
Microsoft Excel uses columns while Microsoft Access uses _________
Fields
Records
Tables
Movement
Records and Fields make up a database _______________
System
Record
Primary Key
Security
Which of the following is an old method of a database?
Address Book
Filing Cabinet
Fax Machine
Typewriter
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
Records in a table can be updated any time.
True
False
Access offers different views of objects. Which view do you use to edit a table?
Datasheet View
Design View
Table View
Print View
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
Why are reports created in access databases?
They are produced to analyse and print queries or tables for presenting
Just to print
To collect more information
_________ allow their users to enter, access and analyze their data quickly and easily.
Reports
Databases
SmartArt
A store needs to keep track of suppliers and inventory. What software can be used to create the database, tables, fields and records?
Database
Database Management Software
Data Integrity
Forms
A database contains a Customer table. What would be stored in a record of the Customer table?
Information about one customer
Information about all the customers
Information about one order
Information about every order
You discover many errors in a database table. What has been lost?
Data Integrity
Database Management System
Fields and Records
Primary Key
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.
What is a database table?
An organized collection of related data.
A column in a table that stores a piece of data for a record.
Stores all the information for one item in a table.
Stores information about one specific kind of item in a database.
What is a database record?
Stores information about one specific kind of item in a database.
Stores all the information for one item in a table.
An organized collection of related data.
A column in a table that stores a piece of data for a record.
4. What is a database field?
Stores all the information for one item in a table.
Stores information about one specific kind of item in a database.
An organized collection of related data.
A column in a table that stores a piece of data for a record.
What is a database form?
A column in a table that stores a piece of data for a record.
Stores information about one specific kind of item in a database.
Forms are a way to view and browse information in a database.
An organized collection of related data.
What is data integrity?
Maintaining and assuring accuracy and consistency of data in a database.
Stores all the information for one item in a table.
Stores information about one specific kind of item in a database.
Forms are a way to view and browse information in a database.
What is ascending order?
Moving down the alphabet from Z to A.
To find a specific item in the table.
Moving up the alphabet from A to Z
sorting
What is descending order?
Moving up the alphabet from A to Z.
Sorting
To find a specific item in the table.
Moving down the alphabet from Z to A.
What view should you use to adjust and format a report?
Print Preview
Report Design View
A primary key field from one table appears in a second table. What is the field in the second table called?
A primary key
A foreign key
A relationship key
A linked key
Does Microsoft Access need to be told about relationships between tables?
No, relationships are automatically detected
No, relationships are not supported
Yes, relationships need to be defined.
Yes, only when the fields have different names.
You cannot change the order of fields on a report.
True
False
A query for a report can come from multiple tables.
True
False
