Kapalı

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.

Beceriler: Microsoft Access

Daha fazlasını görün: 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, microsoft access for business, mdb, jar, create similar access, cards billing

İşveren Hakkında:
( 0 değerlendirme ) Baltimore, United States

Proje NO: #697649

13 freelancers are bidding on average $87 for this job

PerfectSquare

Please see the PM

1 gün içinde 30$ USD
(15 Değerlendirme)
3.4
apuchades

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

in 3 gün içinde30$ USD
(0 Değerlendirme)
0.0
Harunkhan

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

in 10 gün içinde50$ USD
(0 Değerlendirme)
0.0
zulfi3377

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

in 2 gün içinde32$ USD
(0 Değerlendirme)
0.0
ivansouza

I can do you project. Best regards, Ivan

in 15 gün içinde200$ USD
(0 Değerlendirme)
0.0
manoj22184

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

in 2 gün içinde30$ USD
(0 Değerlendirme)
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.

1 gün içinde 30$ USD
(0 Değerlendirme)
0.0
Ahmedn1

Please Check PM

1 gün içinde 30$ USD
(1 Değerlendirme)
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

in 5 gün içinde175$ USD
(0 Değerlendirme)
0.0
vrj

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

in 7 gün içinde100$ USD
(0 Değerlendirme)
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 Daha fazlası

in 2 gün içinde200$ USD
(0 Değerlendirme)
0.0
diptism

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 fazlası

in 17 gün içinde150$ USD
(0 Değerlendirme)
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.

in 3 gün içinde80$ USD
(1 Değerlendirme)
0.0