NEW
Font size
WorksheetsAccess Tables and Forms
Total questions: 16
Worksheet time: 8mins
A ______ is a way of organizing information by type. Think of the ______ name as a question and every cell within that field as a response to that question.
Field
Form
Query
Database
The software that we would use to create a database is
Microsoft Publisher
Microsoft Excel
Microsoft Word
Microsoft Access
In a database, data is stored in
Tables
Forms
Reports
Queries
Which of the following would be used to uniquely identify a record?
Validation
Data type
Primary key
Field size
The best data type to choose for a zip code would be
Number
Text
Date/Time
Currency
The best data type to choose for date of birth would be
Number
Text
Date/Time
Currency
A ‘required field’ is a form of
Validation
Verification
Data Entry
Data Output
The best data type to choose for a phone number would be
Number
Text
Date/Time
Currency
To find a particular set of data in a database you would use a
Table
Form
Query
Report
Besides entering data directly into the table, you could use a
Field
Form
Query
Report
In a database, a "form" allows you to...
Create a query
Enter data and edit it in a simple form that consists of the fields from a table
Nick wants Access to assign an ID number to each record. What is this called?
Data Type
auto numbering
Properties
Text
What is design view?
The function we use to set up a table in a database.
The place where we type in all the information.
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
What is a complete row of data within a table?
Table
Field
Record
Query
To sort from the smallest to the largest (from A to Z and 0 to 9)
Ascending
Descending
Advanced Sort/Filter
