Database Basics
Quiz yourself by thinking what should be in
each of the black spaces below before clicking
on it to display the answer.
Help!
|
|
||||
|---|---|---|---|---|---|
| Best fit: | Another way of resizing a column is to change it to best fit, which automatically resizes the
column to the best width for the data contained in the column (AC 16).
🗑
|
||||
| Compacting: | Compacting a database rearranges how the dat
abase is stored on the disk and optimizes
the performance of the database (AC 21).
🗑
|
||||
| Database: | A database is a collection of objects (AC 4).
🗑
|
||||
| Database Management system (DBMS): | A DBMS allows you to store, retrieve, analyze, and print
information (AC3).
🗑
|
||||
| Datasheet: | In a datasheet, the table displays its data in rows and columns (AC 8).
🗑
|
||||
| Datasheet selector: | You can also select all of the records and fields in a table by clicking the datasheet
selector (AC 11).
🗑
|
||||
| Datasheet view: | In Datasheet view, the table displays its data
in rows and columns in a datasheet (AC 8).
🗑
|
||||
| Field: | Each record is made up of one or more fields (AC 8).
🗑
|
||||
| Field name: | To identify the fields, each field has a field name (AC 8).
🗑
|
||||
| Field selector: | A field selector appears at the top of each
column in a table and contains the field name
(AC 11).
🗑
|
||||
| Field value: | The data entered into a field is called a field value (AC 8).
🗑
|
||||
| Navigation Pane: | When you open an existing database, the
Navigation Pane opens on the left side of the
screen (AC 5).
🗑
|
||||
| Record: | A record is a complete set of data (AC 8).
🗑
|
||||
| Record Selector: | A record selector appears to the left of the first field for each record (AC 11).
🗑
|
Review the information in the table. When you are ready to quiz yourself you can hide individual columns or the entire table. Then you can click on the empty cells to reveal the answer. Try to recall what will be displayed before clicking the empty cell.
To hide a column, click on the column name.
To hide the entire table, click on the "Hide All" button.
You may also shuffle the rows of the table by clicking on the "Shuffle" button.
Or sort by any of the columns using the down arrow next to any column heading.
If you know all the data on any row, you can temporarily remove it by tapping the trash can to the right of the row.
To hide a column, click on the column name.
To hide the entire table, click on the "Hide All" button.
You may also shuffle the rows of the table by clicking on the "Shuffle" button.
Or sort by any of the columns using the down arrow next to any column heading.
If you know all the data on any row, you can temporarily remove it by tapping the trash can to the right of the row.
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.
Normal Size Small Size show me how
Normal Size Small Size show me how
Created by:
eva_rutiri
Popular Computers sets