Chapter 11 DigiByte
Quiz yourself by thinking what should be in
each of the black spaces below before clicking
on it to display the answer.
Help!
|
|
||||
|---|---|---|---|---|---|
| Database File Format | Acess database files have the file extension .mdb.
🗑
|
||||
| Primary Key | The primary key must be a field that contains information that is unique to each record. For example, a social security number field could be used as a primary key, because the entries in the field will be unique to each person listed in a database.
🗑
|
||||
| Deleting a Record | Once a record is deleted, the deletion cannot be undone. The only way to reproduce the is to reenter the data.
🗑
|
||||
| Record ID | Remember that you deleted Record 1 Landscape Architect, in Activity 6, page 366. In step 5, the database interprets the entry as Record 8 because it is the next entry after the existing seven records. The record ID is 9.
🗑
|
||||
| Queries and Tables | If a database contains more than one table, you must choose which table to base a query on.
🗑
|
||||
| Sorting in a Query | Data in a query can be sorted the same way that you sort records in a database table.
🗑
|
||||
| Sort Descending | By clicking the Ascending button you can choose to sort descending.
🗑
|
||||
| Use View | As you make changes to your report, it is important that you view the changes as you go. Use the View Button to switch between Print Preview and Design View so you can see the changes.
🗑
|
||||
| Business Forms | Access databases can be used for many types of business forms
🗑
|
||||
| WinZip | WinZip is a program that opens files that have been compressed or zipped. You can obtain a free evaluation copy of WinZip on the internet. Use a search engine to locate a site where you can download a trail version of WinZip.
🗑
|
||||
| Formatting Reports | Format the text in Access reports in styles and colors that make the report easy to read.
🗑
|
||||
| Web Page | Creating a Web Page from the data in your database table is an easy way to display database information on the internet
🗑
|
||||
| To Redo a Step | If you need to redo a step, click the back button.
🗑
|
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:
anaesmith
Popular Fitness sets