I need help with Microsoft Access?

Question

I'm having quite a difficult time with this lab for Microsoft Access. Can someone tell me if this is really all that difficult? I think I am over thinking it a bit! Here is the steps for the lab, tell me what you think. If someone would like the opportunity to help me once a week over the phone with labs for cash incentive please feel free to leave an email! Thanks.
1. Open the ECO Clothesline database and then open the Customer table in Design view.
2. Add a Lookup fi eld, Customer Type, to the Customer table. The fi eld should appear after the
Postal Code field. The field will contain data on the type of customer. The customer types are SAL
(Salons, Studios, Fitness Clubs), SPG (Sporting Goods), and WMN (Women’s Wear). Save these
changes to the structure.
3. Using a query, change all the entries in the Customer Type column to WMN. Save the query as
Customer Type Update Query.
4. Open the Customer table and make the following changes. You can use either the Find button or
Filter By Selection to locate the records to change:
a. Change the customer type for customers CY12, FN19, LB20, RD03, TT21, and TW56 to SAL.
b. Change the customer type for customer WS34 to SPG.
c. Change the name of customer LB20 to Le Beauty Salon & Spa.
5. Change the alternate background color on the datasheet to white and remove the vertical gridlines.
Save the changes to the layout of the table.
6. Create the following validation rules for the Customer table and save the changes.
a. Specify the legal values SAL, SPT, and WMN for the Customer Type fi eld. Include validation text.
b. Assign a default value of WMN to the Customer Type fi eld.
c. Ensure that any letters entered in the Customer Number fi eld appear as uppercase.
d. Make Customer Name a required fi eld.
7. Open the Customer table and use Filter By Form to fi nd all records where the customer is located
in Lowton and has a customer type of WMN, and then delete these records.
8. ECO Clothesline has signed up a sporting goods store, Ralph’s (Customer Number RA21) and
needs to add the record to the Customer table. Ralph’s is at 72 Main in Lowton, TN 37084. Terry
Sinson is the sales rep assigned to the account. To date, Ralph’s has not been billed nor does the
company owe for any services. Create a split form for the Customer table and use this split form to
add the record. Save the split form as Customer Split Form.
9. Specify referential integrity between the Sales Rep table (the one table) and the Customer table
(the many table). Cascade the update but not the delete.
10. Add the Customer Type field to the Customer Balance Report. The fi eld should follow the
Customer Name fi eld. Save the changes to the report.

I already did steps one and two. I'm having trouble with step 3, do they want me to use the customer table or create a brand new query?

Once again thanks to anyone that can help me.

Answer 1

You asked:



>>do they want me to use the customer table or create a brand new query?<<



They want you to create an update query that will make some changes to the customer table. This query should change all of the entries in the "Customer Type" column to WMN. You stated above that you currently have SAL, SPG and WMN entries in this column. Well per what you've written here, your update query is to change all of the entries to only WMN.

Answer 2

get entry to and Excel are very diverse from note and Powerpoint. you heavily isn't able to fake understanding the thanks to apply them. If the job calls for someone who's as a lot as p.c. immediately, you may not be qualified. it really is a sturdy component of recognize earlier you get employed and lose credibility (and likely your job) interior of a really short era of time. even if, you may truthfully enable them recognize your modern-day MS workplace adventure and your ability in note and Powerpoint. Then state that you're keen to study the different 2 as immediately as accessible. some employers (like typical autos) grant MS workplace suites for as low as $10 for his or her workers use AT abode. it really is which will practice utilising it and shop up with what's used on the job. (it really is MS way of creating efficient that each and each man or woman else keeps paying by the nostril some thing else of the time.) besides, the corporate you're staring at would also be keen to employ you on your different skills if you're keen to take classes and are a short learner. you may seem on-line and are available across a direction accessible that begins quickly (or immediately) and is as complete as accessible in as short a time as accessible. (extra on that decrease than.) Then be prepared by technique of rehearsing some thing to assert at the same time as this comes up in the interview. as an party, state certainly (and succinctly) that you at the instantaneous are not attentive to get entry to and Excel, yet you're a short learner, are have checked into and are keen to take a direction (call it specially) to convey you as a lot as p.c. as immediately as accessible. State that you've self belief your different skills would make this jointly helpful employment and that you got here to the interview hoping to have the prospect to educate that. i have protected a link for Microsoft workplace's personal loose on-line self-coaching website. you would possibly want to also want to seem up paid facilities earlier the following day, so that you'll communicate with those if requested. bear in mind that in the experience that they outright state that you at the instantaneous are not qualified for that position, you possibly can ask in the experience that they have got yet another position that could want to more desirable in good structure your skills, and to shop you in recommendations in the destiny. Even a referral to a unique organization or a coaching on a job more desirable ideal is a efficient commodity lately. and that i do desire you may get the job.

Answer 3

:0