How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask John Your Own Question
John
John, Engineer
Category: Homework
Satisfied Customers: 798
Experience:  Bachelors Degree
27270878
Type Your Homework Question Here...
John is online now
A new question is answered every 9 seconds

Use the Access database you created in Week 3: Customer Service

This answer was rated:

Use the Access database you created in Week 3: Customer Service Database
2. Output 3 queries using SQL code and not the standard access view:

A query on all contacts in the customers table showing first name, last name, address, e-mail address and three additional fields from the table.
An update query that changes one or more customer records but not all records.
A delete query that removes one or more customer records but not all records.
3. Using SQL commands, add a new field called Birthday to the Customers table. Populate some of the fields with data.
4. Report on Customers in Database showing Names, State, and Phone Numbers.
5. Create a report showing contact name and birthdays. Do not show records without a birthday.
6. Analyze the data populated in the Database to show referential integrity. This includes a statement showing what the
affected tables in each dataset are and how they are impacted in the case of an addition of data or a deletion of data.
7. All data and screen shots should be included in a Word document with a brief explanation of the actions you performed.

hi

thanks for your question

I am John
i will help you to do this

 

can you post the Week 3 project to www.wikisend.com

post the Download link or file id

Customer: replied 3 years ago.

1. Use the Access database you created in Week 3: Customer Service Database
2. Output 3 queries using SQL code and not the standard access view:



  • A query on all contacts in the customers table showing first name, last name, address, e-mail address and three additional fields from the table.

  • An update query that changes one or more customer records but not all records.

  • A delete query that removes one or more customer records but not all records.


3. Using SQL commands, add a new field called Birthday to the Customers table. Populate some of the fields with data.
4. Report on Customers in Database showing Names, State, and Phone Numbers.
5. Create a report showing contact name and birthdays. Do not show records without a birthday.
6. Analyze the data populated in the Database to show referential integrity. This includes a statement showing what the
affected tables in each dataset are and how they are impacted in the case of an addition of data or a deletion of data.
7. All data and screen shots should be included in a Word document with a brief explanation of the actions you performed.

Customer: replied 3 years ago.

http://wikisend.com/download/670606/Lang,Keith Assignment Week 03 10-21-13.doc


 


Lang,Keith Assignment Week 03 10-21-13.doc


 


 


Here is the link to my week 3 assignment

hi

ok i will reply soon
Customer: replied 3 years ago.

Sounds good.

hi

ok then
hi

if you have the Access database, please send it . then i can work on it
Customer: replied 3 years ago.

We got a free down load from the school. You might have to get the free download from Microsoft. The week three assignment was done by another person from the site.

hi

do you have the file
Customer: replied 3 years ago.

http://office.microsoft.com/en-us/try/

Customer: replied 3 years ago.

Here is a video that the instructor put together for the assingment


 


https://drive.google.com/file/d/0B6VJOAsHXEroeWo2MVdreFdTSm8/edit?usp=sharing

hi
ok let me check this


I have to recreate the db again
then only i can do the queries
THIS ANSWER IS LOCKED!

You need to spend $3 to view this post. Add Funds to your account and buy credits.
John and 2 other Homework Specialists are ready to help you