Font size
WorksheetsAccess Intro 8/9
Total questions: 17
Worksheet time: 8mins
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
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
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
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
To sort from the smallest to the largest (from A to Z and 0 to 9)
Ascending
Descending
Advanced Sort/Filter
Tick the Functions of a Database
Updating
Sorting
Editing
Playing
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
Access can import a table of data from Excel.
True
False
When you close a new table, it asks you for what
name of the file
where to save it
nothing
