| A | B |
|---|
| Table | a collection of information, or data, arranged in columns and rows |
| Record | all of the information about one person or event |
| Field | information contained within each record. |
| Data Type | the kind of information you display in a field |
| Primary Key | a unique number that is created when a new record is added to a database |
| Relational Database | links tables through a common field, such as a customer number or product number |
| Sort | To change the order of your information |
| Filter/Query | can limit the records you see to only the data you want. |
| Criteria | values or conditions that you can choose for your filter. |
| Filter by Selection | displays all of the records that match a specific value |
| Filter by Form | This method uses a form that allows you to enter two or more criteria at one time.l |
| Form | arranges the data from a table in a way that makes it easy for anyone to enter data. |
| Wizard | a feature that helps you through the series of steps needed to create a helpful tool such as a form. |
| Report | is a printable summary of the information in your database. |
| E-Commerce | the buying and selling of products and services over the Internet |
| Brick and Mortar | Businesses that do not sell goods and services on their Websites. They do all of their business in physical locations. |
| Click and mortar | Businesses that exist both on the Internet and in the real world. |
| Click and order | Businesses that do not have any physical stores. They exist only on the Internet. |
| Banner Ad | an easy to see, eye catching graphic advertisement that takes you to another Web site when you click it. |
| Pop up Ad | A small Web page containing an advertisement |
| Click-through | refers to the number of customers who click an advertisement to move from one Web site to another. |
| Aware | Alert |
| Database | a collection of files that are organized in a logical way. |
| What is the difference between a table and a database | Excel creates spreadsheets and Access creates databases. Both are good ways to organize information, bur if you have hundreds or thousands of records, it would take a long time to find information using a spreadsheet |
| Besides proofreading, what steps can be taken to reduce the number of data-entry errors | You should double-check your entries before moving on to the next record. Have someone else proofread your work. |
| What would be the best way to sort your records if you wanted to make sure your very first customers receive their orders? | ascending order which sorts the oldest date to the most recent. |
