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 Steve Herrod Your Own Question
Steve Herrod
Steve Herrod, Masters Degree
Category: Homework
Satisfied Customers: 3310
Experience:  BA (Hons) & MA Qualifications
65126503
Type Your Homework Question Here...
Steve Herrod is online now
A new question is answered every 9 seconds

This MS Access database assignment has the following parts:1. a

This answer was rated:

This MS Access database assignment has the following parts:

1. a simple database table to hold vendor contact information;
2. a simple database form that can be used to enter data into the database table;
3. a simple database report that can used to present the data as information; and
4. a separate MS Word document answering questions about the database.

All aspects of the assignment will be evaluated according to the following criteria and overall professional, business-like appearance. This would include clear readability and formatting for both screen and print-based output.
Requirement
Points Allocated Comments
• Launch MS Access and open a Blank Access database.
• Save the new database with the following name:
“Student’s First Initial Last Name Vendor”
Example: JSmith Vendor 0.25
Create a table with all the following fields and settings:
A. Vendor ID (autonumber)
B. Company Name (text)
C. Contact’s First Name (text)
D. Contact’s Last Name (text)
E. Billing Address (text) (this is the street address)
F. City (text)
G. State (text—limited to 2 characters)
H. Zip Code (text—limited to 5 characters)
I. Phone number
J. YTD Orders (currency)
K. Preferred Vendor (Yes/No) 1.0 The Vendor ID field must be set as the primary key (*). If the Vendor ID is not the primary key, 0.5 points will be deducted. If you have properly set the Vendor ID field as the primary key, it will be numbered automatically (Auto Number).
• Name the table as follows:
Vendor Table 0.25

Steve Herrod :

Hi, I'll be happy to help with this - can you let me know the full details of the assignment?

Customer:

Please take a look at the attachment.

Steve Herrod :

got it - when do you need this by?

Customer:

by sunday Morning

Steve Herrod :

no problem - should be ready later today

Customer:

great!!!! Thanks

Steve Herrod :

you're welcome

Steve Herrod :

will send it through when ready

Customer:

this the other part

Steve Herrod :

ok

Steve Herrod :

no problem

Customer:

Thx

Steve Herrod :

welcome!

Steve Herrod :

This is the Word document

Steve Herrod :

This is the Access file

Steve Herrod :

and this is the Presentation file - https://www.box.com/shared/4cueqk1wnuley30hj6jl

Steve Herrod :

Cheers

Steve Herrod :

Steve

Steve Herrod :

Let me know if you were able to download them ok

Customer:

i wasnt ablt ot open the vender one

Steve Herrod :

ok - what version of Access are you using?

Customer:

07

Steve Herrod :

Ok, will convert it and put the new link here

Steve Herrod :

one seond

Customer:

Thank you so much

Steve Herrod :

can you try this version?

Steve Herrod :

if that doesn't open try this one

Steve Herrod :

Cheers

Steve Herrod :

Steve

Customer:

thanks much

Steve Herrod :

no problem

Steve Herrod :

let me know if you need anything at all

Steve Herrod and other Homework Specialists are ready to help you
Customer: replied 3 years ago.

Steve,


Thanks so much for your help. I need to see if you can assist me with my research paper

Attachment: 2013-10-02_173342_research_paper_requirements_1.doc

Hi,

I would definitely be able to help with that - did you have a topic in mind and when would it be due?

It would need to be asked as a new question but let me know the details first.

Cheers

Steve
Customer: replied 3 years ago.

  1. Identity Theft or Biometrics (in terms of ethical and privacy issues)

Ok, that is no problem - when would it be due?

Cheers

Steve
Customer: replied 3 years ago.

sunday

Ok, perfect - can have with you for Sunday.

Can you ask a new question and put 'For Steve Herrod only - IT Research Paper' in the subject?

Cheers

Steve

Related Homework Questions