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 Omer Your Own Question

Omer
Omer, Information Systems Manager
Category: Computer
Satisfied Customers: 309
Experience:  MCSE Certified , Degree in CMIS Computer information Systems, 7 years of work in the IT Field
37817776
Type Your Computer Question Here...
Omer is online now
A new question is answered every 9 seconds

I have an assignment to do and I need help with MS Access creating

Resolved Question:

I have an assignment to do and I need help with MS Access creating a database. I'll appreciate it if anyone can help me. I did the database and I need help to create relationships and to create a query I have the database n everything.

The database can be obtained here:

http://www.webdownloads.us/week_7_lab_database.mdb
Submitted: 3 years ago.
Category: Computer
Expert:  Omer replied 3 years ago.

Omer Mushahwar :

Hi I am one of the Experts here on Just Answer.com

Omer Mushahwar :

What is it that you need help with exactly?

Customer :

2. Create one-to-many relationships between the employee table and the password, installed software, and department tables. Use the primary keys in each table to create the required relationships.

3. Add five records to the employee table. Employee numbers must be in the range from 1 to 5. This will allow the records in the employee table to be related to the data contained in the other tables.

4. Create a query that displays each employee's first name, last name and password.

Customer :

Thats what I need to do.

Omer Mushahwar :

was there a 1

Customer :

Yea but I completed it would you want to see 1?

Omer Mushahwar :

or is that what you did with creating the database

Customer :

Yes.

Omer Mushahwar :

Ok the first issue i saw was you were trying to hit tblemployees when your table is named tblemployee

Customer :

Oh what do you mean by that?

Omer Mushahwar :

your queries didnt work because the name of your table wasnt tblemployees

Customer :

Add to a table to the database called tblEmployee. The table will include the following fields: First Name (text), Last Name (text), Middle Name (text), Hire Date (date), Department Number (number) and Employee Number (auto number). The primary key will be the Employee Number field.

Customer :

That was number 1.

Omer Mushahwar :

it was table employee just looking at the database now

Customer :

Oh.

Customer :

So I named it incorrectly?

Omer Mushahwar :

this will take some time

Customer :

Okay.

Omer Mushahwar :

hi yes

Omer Mushahwar :

thatws all

Omer Mushahwar :

thats the one error i saw in the creation

Omer Mushahwar :

so far

Omer Mushahwar :

still looking through it

Customer :

Okay thank you for the issue.

Omer Mushahwar :

can you type in all of 1. so I can see it

Omer Mushahwar :

thanks

Customer :

1. Add to a table to the database called tblEmployee. The table will include the following fields: First Name (text), Last Name (text), Middle Name (text), Hire Date (date), Department Number (number) and Employee Number (auto number). The primary key will be the Employee Number field.

Omer Mushahwar :

thanks

Customer :

You're welcome.

Omer Mushahwar :

Did you create all these tables

Omer Mushahwar :

or just the employee one

Customer :

The employee one. The teacher told us to use this database.

Omer Mushahwar :

ok

Customer :

Is everything okay with the rest of the tables?

Omer Mushahwar :

So far looking through some stuff one second

Customer :

Okay.

Omer Mushahwar :

Just finished number 2 going through the questions shouldnt take too much longer

Omer Mushahwar :

Are there any specific Employees your suppose to add to the table?

Customer :

No.

Omer Mushahwar :

Ok

Customer :

Btw is this chatting thing a new thing to JustAnswer? I've never seen it before or used it.

Omer Mushahwar :

Yeah

Omer Mushahwar :

its been added over the last month or two

Omer Mushahwar :

it was in beta testing for a little while

Customer :

Its a lot easier than waiting for a reply.

Omer Mushahwar :

Yeah its a lot easier on this end too

Omer Mushahwar :

makes interaction a lot better

Customer :

Yes it does.

Omer Mushahwar :

you should be able to download the file here

Omer Mushahwar :

and it should contain everything you need

Omer Mushahwar :

If its an issue with the table being named Employees instead of Employee let me know

Omer Mushahwar :

I can adjust it and fix whatever

Customer :

Can you rename the data to something else like Week 7 Lab or something?

Customer :

database*

Omer Mushahwar :

You mean just rename the file?

Customer :

Yea.

Omer Mushahwar :

You should be able to simply do that by write clicking the file and renaming it

Omer Mushahwar :

The contents of the file arent affected by the name of it

Customer :

Oh yea nvm I did that. Thank you so much!

Omer Mushahwar :

Your welcome


Omer, Information Systems Manager
Category: Computer
Satisfied Customers: 309
Experience: MCSE Certified , Degree in CMIS Computer information Systems, 7 years of work in the IT Field
Omer and 6 other Computer Specialists are ready to help you
Customer: replied 3 years ago.
I was wondering if you know a lot about Visual Basic programming because tomorrow I need to do homework with questinos and was wondering if you can help me tomorrow which I'll ask a new question to you so you can gt paid. That'll help me.
Expert:  Omer replied 3 years ago.

While I do know some visual Basic programming I am not yet a verified expert in the program fields on the Just Answer.com site and therefore cannot answer the questions.

 

However when you do post it another one of our great experts I am sure will be able to help you just as quickly

JustAnswer in the News:

 
 
 
Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.
 
 
 

What Customers are Saying:

 
 
 
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer New York
< Last | Next >
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer New York
  • I am very happy with my very fast response. Eric is very knowledgeable in the subject area. Thank you! RP Austin, TX
  • Hi John, Thank you for your expertise and, more important, for your kindness because they make me, almost, look forward to my next computer problem. After the next problem comes, I'll be delighted to correspond again with you. I'm told that I excel at programing. But system administration has never been one of my talents. So it's great to have an expert to rely on when the computer decides to stump me. God bless, Bill Bill M. Schenectady, New York
  • The Expert answered my Mac question and was patient. He answered in a thorough and timely manner, keeping the response on a level that could understand. Thank you! Frank Canada
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C. Freshfield, Liverpool, UK
  • This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!! Alex Los Angeles, CA
  • Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult. GP Hesperia, CA
 
 
 

Meet The Experts:

 
 
 
  • Andy

    Computer Consultant

    Satisfied Customers:

    5311
    11yr exp, Comp Engg, Internet expert, Web developer, SEO
< Last | Next >
  • http://ww2.justanswer.com/uploads/EN/Engineer1010/2012-6-9_132423_jaj12a.64x64.jpg Andy's Avatar

    Andy

    Computer Consultant

    Satisfied Customers:

    5311
    11yr exp, Comp Engg, Internet expert, Web developer, SEO
  • http://ww2.justanswer.com/uploads/BA/barrenrock/2011-10-19_215925_JamesJAFinal.64x64.jpg James's Avatar

    James

    Sr. Computer Support Expert

    Satisfied Customers:

    8376
    20 years of experience building, fixing and servicing PCs and operating systems.
  • http://ww2.justanswer.com/uploads/zeyank/2009-09-26_154244_P8110079.png Ryan H.'s Avatar

    Ryan H.

    Computer Support Specialist

    Satisfied Customers:

    1741
    A+ Certified Technician - 10 Years experience working with all types of computer systems.
  • http://ww2.justanswer.com/uploads/JA/jadedangel57/2011-11-8_193134_janenewsm.64x64.jpg Jane Lefler's Avatar

    Jane Lefler

    Sr Prog Analyst / Technician

    Satisfied Customers:

    0
    Computer Programmer / Technician/ Consultant 16+ years
  • http://ww2.justanswer.com/uploads/RO/robmpreston/2013-9-23_233814_mijiFZm.64x64.jpg RPI Solutions's Avatar

    RPI Solutions

    Support Specialist

    Satisfied Customers:

    3476
    5+ Years in IT, BS in Computer Science
  • http://ww2.justanswer.com/uploads/BA/barunrath/2012-7-5_201954_Profilepic2.64x64.jpg B. Rath's Avatar

    B. Rath

    Computer Support Specialist

    Satisfied Customers:

    8671
    Certified Computer/Networking Support Specialist.
  • http://ww2.justanswer.com/uploads/FS/fszcze/2012-6-18_181848_500test.64x64.jpg Frederick S.'s Avatar

    Frederick S.

    Computer Specialist

    Satisfied Customers:

    7240
    Computer technician and founder of a home PC repair company.