Closed

Access Homework

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.

Element #

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)

City (text)

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.

Skills: Microsoft Access

See more: create table following fields settings, wizard form design, microsoft phone number, microsoft number, microsoft access data entry form, id cards design, how to create a data entry form in access, how to create a data entry form, how design conference, form wizard design, do your homework for you, do homework for you, data entry form in access, customer data entry form, create data entry form access, billing microsoft, access data entry form, access database data entry form, how data entry works, myname

About the Employer:
( 0 reviews ) Baltimore, United States

Project ID: #697649

13 freelancers are bidding on average $87 for this job

PerfectSquare

Please see the PM

$30 USD in 1 day
(15 Reviews)
3.4
apuchades

Hi I'm interesting for your project. Regards, Toni

$30 USD in 3 days
(0 Reviews)
0.0
Harunkhan

Hi, I have to interest your work. I'm able to complete your work. Thanks Harun

$50 USD in 10 days
(0 Reviews)
0.0
zulfi3377

I can easily do this project. and I'm ready to do this.

$32 USD in 2 days
(0 Reviews)
0.0
ivansouza

I can do you project. Best regards, Ivan

$200 USD in 15 days
(0 Reviews)
0.0
manoj22184

Hi, I am interested to work on this project . Please check your PMB. Thanks, Manoj.

$30 USD in 2 days
(0 Reviews)
0.0
ta3k

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.

$30 USD in 1 day
(0 Reviews)
0.0
Ahmedn1

Please Check PM

$30 USD in 1 day
(1 Review)
2.0
info2010

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

$175 USD in 5 days
(0 Reviews)
0.0
vrj

THIS SEEMS TO BE MY ACADEMIC PROJECTS AND I CAN CREATE FORM IN JAVA sWING.

$100 USD in 7 days
(0 Reviews)
0.0
billfan88

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 More

$200 USD in 2 days
(0 Reviews)
0.0
diptism

Our team has excellent skills in all MS Office [login to view URL] have industrial experience [login to view URL] are sure we will be able to deliver your project within given time [login to view URL] are also sure that the final product will exceed More

$150 USD in 17 days
(0 Reviews)
0.0
taoajayi

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.

$80 USD in 3 days
(1 Review)
0.0