Create a customer database to allow you to conduct mailings in the future. Customers will put their business cards into a jar in hopes of winning promotional items. Their business cards will give you their name, the company they work for, and all the other information you need to set up your database. This project will closely parallel the one in the text.
Create a table with all the following fields and settings:
Customer ID (autonumber)
Company Name (text)
First Name (text)
Last Name (text)
Billing Address (text) (this is the street address)
State (text—limited to 2 characters)
Zip Code (text—limited to 5 characters)
Phone Number (text)
YTD Orders (currency)
Customer Since (date)
Preferred Customer (Logical, based on Orders exceeding $10,000)
Save the table as "Customers."
Build a data-entry form similar to the one in unit H. Be sure that your entry form uses the "Customers" table for input. Include all the fields of your "Customers" table. Design the format of the data-entry form any way you choose, but do format it. Save the form.
Enter data for at least 10 customers, using the data-entry form. Use the form instead of using the table so you can make sure it works.
Sort your database table by the customer's last name.
Create and save a query that pulls all the company names from the company name field. (Include only the company names in the query). Sort them alphabetically in ascending order. (Hint: be sure the sort criteria is are included in the query. Please see the posting in the ACCESS conference to see how to do it. Note: The ACCESS Query Wizard may lead you to sort the result set after it has been retrieved. However, that is not the way I want you to implement the sort; the query itself should do the sort before returning the result set. Again, please see the posting in the ACCESS conference to see the correct way to add the sort into your query.) Save the query. Save the ACCESS file with your name (e.g. [url removed, login to view]). .
Note: Do not set a password for your database.