ACCESS problems...Don't want to fail my class..*fingers crossed*

I am doing a cert. III in business admin that finishes on MOnday 9 May 2005. I have 3 days to do a mammoth business trip assignment, AND pass a test on Access. The school is a little dodgy and didn't make me do that practical assignment - they gave me multiple choice q's and written q's to take home.

PLEASE HELP!!! I need to pass this course - and we never use Access at work.

Q1. What is wrong with this formula?
=Iff([Product]=Home,1,0)
I'm sure there's more wrong with it than the 'Iff' - that's meant to be 'IIf' isn't it? I've only ever used formulas in Excel..

Q2. What result will the 'Is Null' expression return?

Q3. What is the difference between a Combo Box and a List Box?

Q4. Why is the purpose of the Paste Append function?

Q5. Which formula is correct?
a. =[Qty]*[Price]+[Freight]
b. =[(Qty)*(Price)+(Freight)]
c. =([Qty]*[Price])+[Freight]
d. =[(Qty)*(Price)]+(Freight)

???

Q6. A chart can be placed on:
a. Table view only
b. A form or Report view
c. A Query or Table view only
d. A Report view only

Please answer any of these questions you can - the last one I can trial by error later tonight.

Thanks in advance.

_________________________


#2 Today, 01:56 PM
Newman
Québécois Join Date: Aug 2002
Location: Montréal
Posts: 1,111

You won't get answers from anyone here with that kind of questions. I might help you solve it, but won't give you any answers.
Q1: You are right about the Iff being a typo. There is an error in that formula, and you should be able to find it since it would have gave you the same error in Excel.
Q2: This is a simple English question. If I ask you "Is something NULL?" What would you say? Well, if you ask your computer, it'll give you about the same answer.
Q3: Open a form and put a listbox and a combo box on it. You'll have your answer right in front of you. A child could answer that question.
Q4: "Paste ", "Append" and "Function ". Search for these three word in a dictionary and it will tell you the answer.
Q5: For this question, you just have to try it and you'll see if the answer is good. Actualy, you might try it in Excel and get the same answer.
Q6: As you said, you can try it and find out where it works and where it does not.

To be honest with you, I just don't understand how you got these questions. They are so easy. This ain't an Access test. This is a logical test. You should have been able to answer many of these even without knowing what was Access at all.

Good luck and, please, don't rely on someone else to provide you answers. All you need is to take a break, a deep breath and read the questions slowly.
__________________
The trouble with most folks isn't so much their ignorance, as knowing so many things that ain't so. - Josh Billings

Newman
View Public Profile
Send a private message to Newman
Find all posts by Newman
Add Newman to Your Buddy List

#3 Today, 03:00 PM
NinjaGaijin
Registered User Join Date: May 2005
Posts: 2

Thank You!

--------------------------------------------------------------------------------

Quote:
Originally Posted by Newman
Q1: You are right about the Iff being a typo. There is an error in that formula, and you should be able to find it since it would have gave you the same error in Excel.
Q2: This is a simple English question. If I ask you "Is something NULL?" What would you say? Well, if you ask your computer, it'll give you about the same answer.
Q5: For this question, you just have to try it and you'll see if the answer is good. Actualy, you might try it in Excel and get the same answer.

Good luck and, please, don't rely on someone else to provide you answers. All you need is to take a break, a deep breath and read the questions slowly.


Thank you for your help...
What you have provided is excellent help even without answers.
I just wish I had time to take a break ;(

re: iff([Product]=Home,1,0) -
iif(Product = Home,1,0) .. was there another error? You said there was only one more. I removed the brackets + added spaces..not asking for answer only if I need to look deeper. I come up with 'undefined' in the 'shift+f3' formula error dialog box...the formula appears to be fine but it doesn't like my labels of collumns/cells I guess..

In what view can I add formulas in Access?

re: Qty/Price/Freight formula, I got this one to work: =(Qty*Price)+(Freight)
However there are no brackets involved, I couldn't get them to work - what do the brackets do in Access? (I am only using Excel, I have Access at home but I am at work)

re: IsNull, I have been scanning the forums for a definition, and it appears to be for when a cell is blank/empty..without even a '0' in it. Would this mean that IsNull would result in a blank cell or a pre-defined value that is created when using 'IsNull'?


I hope these questions are more appropriate. Honestlythank you so much for tutoring me a little..I just need a little guiding to the right place.

 

If your getting this particular cert will indicate to an employeer that you have some skill with Access then you need to be able to do the work yourself.