Access Vocabulary
Help!
|
|
||||
|---|---|---|---|---|---|
| What is a database? | A database is a collection of related information.
🗑
|
||||
| What is a record? | A record is a table row.
🗑
|
||||
| What is a field? | A field is a table column.
🗑
|
||||
| What does a table record contain? | A table record contains all the information about one individual, item, or subject.
🗑
|
||||
| What are the database objects? | Tables, queries, forms and reports are the database objects.
🗑
|
||||
| What is a relational database? | In a relational database, tables have the same fields and are linked together.
🗑
|
||||
| How do you navigate a database? | You navigate database objects by using Objects bar on the left side of the Database window.
🗑
|
||||
| What do you perform when you want to view, extract or analyze data in your database? | You perform a query.
🗑
|
||||
| What do you use to enter or display data in a database? | You use a form.
🗑
|
||||
| What do you create when you want to print a query or a table? | You create a report.
🗑
|
||||
| What are the most common views you'll use? | The most common views you'll use are the Design View and the Datasheet View.
🗑
|
||||
| What prefix do all table names use? | All table names use the prefix "tbl".
🗑
|
||||
| What do you modify using Design View? | You use this view to modify
🗑
|
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:
Alice Change
Popular Computers sets