EASY ACCESS problems...PLz HELP ASAP! Don't want to fail my class..*fingers crossed*

[NinjaGaijin]

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.

 

[Newman]

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.

 

[NinjaGaijin]

Thank You!

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.

 

[aleb]

=iif([Product]=Home,1,0)
if you leave the formula like this in access it would be automatically turned into
=iif([Product]=[Home],1,0)
as it will assume that HOME is a name of a field.
Correct spelling would be
=iff([Product]='Home',1,0)


"re: Qty/Price/Freight formula, I got this one to work: =(Qty*Price)+(Freight)"

again if you leave the formula like you showed it would be turned into

=([Qty]*[Price])+([Freight])
in fact the parantheses in this case is a redundancy because math says first multiply then add unless (!) there are parentheses.

=[Qty]*[Price]+[Freight] is a correct answer

 

[NinjaGaijin]

Thanking you

Thanks so much for that, I was really worried. So much stress over some brackets

Before I checked again if anyone had replied I went down to the IT section at my work and asked around, and someone found this cool tutorial on basics:

http://www.functionx.com/access/Lesson09.htm

But it was a huge relief to see you'd checked my 'iif' question. I will pass with no problems now! I would have actually learnt it if I was going use access at work or if I had more than 3 days to finish my course. The trainer didn't even give me the training manual!!! SO THANK YOU!!!!!!!!!!!!!!!!!!!!!!!

I'd probably have to say I think Russians play more exciting ice hockey too..