WorksheetsDatabase (1)
Total questions: 55
Worksheet time: 27mins
database
MS Access
spreadsheet
MS Excel
wordprocessor
MS Word
presentation
MS Powerpoint
How can you locate data in a database?
create a table
use queries
Analyze the information
Queries are request for (a) .
To help with locating and sorting data, users should consider what __________ they need.
criteria
standards
columns and rows
To modify or delete data in a database, you can remove it manually or run a delete query ________
As long as the data to be deleted is connected to other data.
Anytime
As long as the data to be deleted is not tied to any other data
Never
The accuracy and consistency of data in a database is called data (a) .
What should be used to display and maintain records in a table?
Relationships
Forms
Queries
Tables
What is the main use for reports?
To access data from a database to manipulate it or retrieve it.
To compile information for printing.
To enter, edit, or display data from a table.
To summarize data.
What is a database?
A systematic collection of data.
A random collection of data.
A spreadsheet workbook.
Information about clients and students.
What is a query used for in a database?
Delete data.
Edit data.
Filter data.
Extract and analyse data.
What could happen if a data type is changed in an existing table?
Data will be duplicated.
Data will be saved.
Data could be lost.
Data will be stored in a different database.
What property is used to automatically enter a specific field value for new records?
Random Value.
Auto Value.
None of the following.
Default value.
Name an appropriate data type for a field containing decimal values.
Text
Number
Calculated
Date/Time
What is an important fact when creating fields in a database?
None of the following.
Each field in a table should contain several types of data.
Each field in a table should contain only one type of data.
Each cell is unique.
1. What is a database?
A data structure that improves search operations in a table.
A program for creating online forms.
A set of instructions used when retrieving data from a table.
A structured collection of records or data.
2. What is the difference between data and information?
Data is always numerical while information is always text.
Data is generated by an application while information is generated manually.
Data is presented as formatted text while information is presented as plain text.
Data is raw facts while information is data processed in some way.
3. How is a database organised?
A database contains forms and reports stored in tables.
A database contains indexes and criteria stored in tables.
A database contains reports and fields stored in tables.
A database contains fields and records stored in tables.
4. Which of the following is a common use of large-scale databases?
Storing and accessing bank account records.
Storing and accessing bookmarks in a Web browser.
Storing and accessing contacts in a mobile phone.
Storing and accessing videos on a hard drive.
5. What is important when designing a database?
A form should enter data into multiple tables.
A query should only fetch data from a single table.
A report should contain records based on a single data type.
A table should contain data related to a single subject type.
6. Which of the following is important when creating fields in a database?
Each field in a table should contain a primary key.
Each field in a table should contain only one type of data.
Each field in a table should use the same data type.
Each field in a table should use the same field size.
7. Which of the following is an appropriate data type for a field containing decimal values?
AutoNumber
Number
Short Text
Memo
8. What property is used to automatically enter a specific field value for new records?
Caption
Default value
Field size
Format
9. What is used when there is a need to uniquely identify each record in a table?
A default value.
A filter.
A primary key.
A validation rule.
11. Which could happen if a data type is changed in an existing table?
Data could be lost.
Fields could be removed.
Records could be hidden.
Tables could be locked.
10. What could be used to find and sort records faster?
A form.
A primary key.
A validation rule.
An index.
12. What is the main purpose of relating data between tables in a database?
To enable faster data searches.
To minimise duplication of data.
To optimise filtering of records.
To prevent the need for using queries.
13. What is created by matching a unique field in a table with a field in another table?
A query
A relationship
An index.
A data type
14. Why is it important to maintain the integrity of relationships between tables?
Because it prevents related data from being changed or deleted.
Because it stops creation of duplicate data.
Because it will make searches in the related tables faster.
Because it reduces the need to index related tables.
What is a database?
A software package used to store information
Something that has a list
A spreadsheet
A table of data
Which software program do we use to create a database
Microsoft Excel
Microsoft Word
Microsoft Access
Microsoft Publisher
Who might use a database?
School
Police
Employer
All of the above
In school, what kind of data might be stored in a database?
Favourite colour
Emergency contact details
Favourite food
Your mobile phone number
What is an advanage of a database?
You can input information
Its different to Excel
It saves files
Can search through and find information quickly
What is a unique identifying field called?
Field
Primary Key
Record
Query
Short text, date, long text and number are all examples of what?
Data types
Headings
Fields
Records
A column in a database is better known as a...
Record
Query
Field
Form
A row in a database is better known as
Record
Query
Field
Form
True or false - it is important to check our literacy (spelling, capital letters, etc) when inputting data into a database
True
False
A query is used to
Sort the database in alphabetical order
Search the database
Delete records
Create a form
If we are running a query and looking for all records with a date before 1999, we type what into the criteria?
>1999
>01/01/1999
<01/01/1999
<1999
Which of the following would you use to display the data from a query in a professional format?
Table
Form
Query
Report
In a TABLE, a row is known as a...
Information
Column
Data
Record
The best data type to choose for date of birth would be
Number
Date/Time
Text
Currency
Which of the following would be used to uniquely identify a record?
Validation
Data type
Primary key
Field size
We can use (a) to answer, perform calculations, combine data from different tables, add, modify or delete data.
Which of the following is an example of a field?
TimesPlayed
004
Holidays
The number of fields in this table is ____
1
5
8
9
The number of records in this table is _______
8
9
5
40
