What is the name of the place where all the information in a database is stored?
- A table.
- A form.
- A field.
- A cell.
What is meant by a "database record"?
- All the information about one person (or item) in a database.
- A way of storing information so that it can be retrieved later.
- A report produced by a database showing certain information.
- The type of information that a certain database can store.
Which one of these icons could you use to sort a database table into alphabetical order?
-
This picture shows part of a large database table of DVDs. How could we sort the table so that the cheapest DVD came first and the most expensive last?
- Click in the "Price" column, then click the
icon. - Click the
icon, then type "Show cheapest". - Scroll the table until the cheapest DVD appears at the top of the screen.
- Highlight the "Price" column, then press "Home" twice.
- Click in the "Price" column, then click the
In this database table, one section is higlighted in red. What is the name given to the highlighted section?
- A record.
- A slice.
- A column.
- A primary key.
The following picture shows part of a large database table of DVDs. If we wanted to filter the database so that only DVDs by "Columbia/Tri-Star" were shown, we should:
- Click on "Columbia/Tri-Star", then click on
- Click on
, type "Columbia/Tri-Star", then click "OK". - Click on each DVD by "Columbia/Tri-Star" and drag them into another file.
- Highlight all DVDs by "Columbi/Tri-Star", then click
- Click on "Columbia/Tri-Star", then click on
This picture shows a form used to enter information into a database table of DVDs. What does the highlighted icon do?
- Moves to the next record in the database.
- Plays some music.
- Moves the database table to the right of the screen.
- Switches between the database form and the table.
Which one of the following answers is NOT true?
- A database table can store a maximum of 65,536 records.
- A database can have one or more tables.
- A database table can easily be deleted.
- A database can be used to store information about people, such as their names, their dates of birth, and pictures of them.
Which of the following answers is NOT true?
- Formulas can be used in databases to perform calculations, such as totals and averages.
- Databases are a fast and effiecient way of storing and finding large amounts of information.
- It is very fast and easy to find the information that you are looking for in a database.
- Database software can be difficult to use, and people need to be trained to use it properly.
This picture shows part of a large database table of DVDs. Which of the following is likely to be the data type of the "Studio" field?
- Text.
- Date/Time.
- Number.
- AutoNumber.
