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.
Bu iş için 13 freelancer ortalamada $87 teklif veriyor
Hi, I have to interest your work. I'm able to complete your work. Thanks Harun
I can easily do this project. and I'm ready to do this.
Hi, I am interested to work on this project . Please check your PMB. Thanks, Manoj.
a perfect job can be done in your project and I would like work with you in this. I'm available and ready to start right away. Best regards.
i want to tell you that i can make this project with access with visual basic 6 and ms access as application with setup and can do with ms access only
THIS SEEMS TO BE MY ACADEMIC PROJECTS AND I CAN CREATE FORM IN JAVA sWING.
hi I have ten years experience on MS Access. I have done serven Access DB for client in 2009 also I have five years in MS Access 2003 and Access 2007 I am sure I can do it well. Let us start now. look f Daha Fazla
Our team has excellent skills in all MS Office [url removed, login to view] have industrial experience [url removed, login to view] are sure we will be able to deliver your project within given time [url removed, login to view] are also sure that the final product will exceed Daha Fazla
Hello, I have extensive experience in Access (over 8 years) and I can certainly do this project. Please check your PM for more details. Thanks.