click below
click below
Normal Size Small Size show me how
Chapter 11 DigiByte
Question | Answer |
---|---|
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. |