WorksheetsYear 8 Database Exam
Total questions: 30
Worksheet time: 23mins
A _________ is a computerized filing system that is used to organize and maintain a collection of information for future use.
Query
Report
Database
Spreadsheet
A Primary Key is a code that uniquely identifies a _____________ in a Database.
Record
Field
Text
Number
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
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
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
Which of these options is the best to use for a primary key?
Number
Currency
Short Text
Autonumber
To delete or rename a field in Microsoft Access, the first thing to do is _________
Right click on the field
Delete the field
Double Click on the field
Open the field
Which view can be used to enter data into the database?
Design View
Record View
Field View
Form View
What view is shown in this image?
Form View
Report View
What view is shown in this image?
Form View
Report View
What view is shown in this image?
Form View
Report View
What view is shown in this image?
Form View
Report View
Forms, queries, and reports are created based on the data in the _________
Forms
Tables
Reports
Spreadsheets
The command for "Less than and equal to" is...
<>
<=
>=
=
The command for "More than and equal to" is...
<
<=
>=
>
Click ___________ to show the results of a query
Execute
Show
Run
Results
Which of the following is an old method of a database?
Address Book
Filing Cabinet
Fax Machine
Typewriter
Access offers different views of objects. Which view do you use to edit a table?
Datasheet View
Design View
Table View
Print View
Of the 4 Database Objects, which one does NOT include a wizard?
Tables
Forms
Queries
Reports
In database , we can
Add the record
Delete the record
Amend the record
All the above
A small graphical representation of an organization or theme.
Theme
Logo
Form
