click below
click below
Normal Size Small Size show me how
Digibytes
The Digibytes found in Chapter 11
Term | Definition |
---|---|
Database File Format | Access 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 the database. |
Deleting a Record | Once a record is deleted, the deletion cannot be undone. The only way to reproduce the record is to reenter the data. |
Record ID | Remember that you deleted Record 1, Landscape Architecture, in Activity 6, page 366. In Step 5, the 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 chooses which table to base a query on. |
Sorting in a Query | Data in a query can be sorted in the same way that you sort records in a database table. |
Sort Descending | By clicking the Ascending button, you can choose to sort by 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 that 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 search engine to locate a site where you can download a trial 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 tables 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. |