NEW
Font size
WorksheetsIntro to Microsoft Access
Total questions: 25
Worksheet time: 13mins
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
Is it OK to have a database of unrelated data?
Yes
No
Why does data inside a database need to be organized?
So the data is neat and tidy
So data integrity can be maintained
So the data can be searched from the Internet
So the data can be found when needed
A store tracks customers and their orders in a database. Which table would NOT be part of this database?
Customers table
Orders table
Reviews table
Inventory table
A store tracks customers and their orders in a database. What can be created to store this collection of related data?
Database Management System
Database
Table
Record
You discover many errors in a database table. What has been lost?
Data Integrity
Database Management System
Fields and Records
Primary Key
Which of the following is an easy way to enter and browse data in a large database?
Forms
Tables
Spreadsheets
Records
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 tools does Access have to help manage large amounts of data?
Foreign key
Sorting and filtering
A relationship
Report Design View
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 is filtering?
To find a specific item in the table.
A relationship
Changing which records are displayed on the screen.
Sorting
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
Filters can be used on query results.
True
False
Queries can only use data from one table at a time.
True
False
