WorksheetsAccess
Total questions: 18
Worksheet time: 9mins
A database is used to
Calculate figures
Store data in a logical order
Layout pages attractively
Present material using animations and graphics
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 postcode 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
A postcode is usually written in the same format e.g. LLNN NLL (L=letter, N=number). The most suitable type of validation to use in this instance would be
Input Mask
Required Field
Range Check
None
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
To display the data from a query in a professional format you could use a
Table
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
