WorksheetsMicrosoft Access - GPS
Total questions: 25
Worksheet time: 8mins
What software do you use to make databases?
Access
Excel
PowerPoint
Word
In your database, information is stored in the ...
Table
Report
Query
Form
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
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
These store information in records and fields.
Tables
Forms
Queries
Reports
These sort, filter, and summarize data.
Tables
Forms
Queries
Reports
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 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
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 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.
