Homework Assistance

Question

Thanks to everyone for your help, I appreciate it.  I tried to delete this post, but for some reason, its not letting me.

10
11
12
13
14

Answer 1

I guess I should apologize for the tone of my message.

But I don't see anything to apologize for in the content of my message.

Your question 10 says:

10

Create a new query in Design view based on both tables. Add the Scholarship Name, First Name, Last Name, and Amount fields (in that order). In the first empty column, create a new field named<br>Donation that will display the donation amount when the Board of Trustees of the college donates an amount equal to 25 percent of each scholarship (that is, multiply<br> Amount by 0.25). Save the query as Foundation Donation Query.

Have you created a new Query in Design view?

Have you added the Scholarship Name etc. fields?

Have you typed

Donation: [Amount] * 0.25

in a vacant Field cell to create a new field?

If so, and it didn't work, what exactly DID you put into the query, and what did it do?

Answer 2

I'm guessing you put this in the CRITERIA row of the grid? That's the problem if so!

Open the query grid.

In the very top row - the Field row - find a vacant cell.

Type

MatchingDonation: [Amount] * .25

The text to the left of the colon will be the new fieldname (it's best not to include blanks in fieldnames, though you may be able to get away with it).

In question 11 note that you usually cannot use a calculated field in a further calculation - recapitulate the expression instead.

Note also that new Access users for some reason REALLY overuse the LIKE operator: LIKE is used only in criteria, and only when you want to use wildcards for partial matches. For instance, a criterion of

LIKE "Jo*" 

will find Johansen, Jones, Joseki and other names starting with Jo;

LIKE "*se"

will find Jesse, Milanese, and other names ending with se. If you're not using wildcards there's no benefit to using the LIKE operator!

Answer 3

I understand what you are saying.  I am just stuck on 10 and 11.  How am I supposed to give you an indication that I have worked on it.  I'm not some stupid 18-year-old, I'm an adult.  It DOES tell me what to do, but when I 'run' it, its not working, so I thought I would ask for help.  I don't need anymore of your snotty comments.

 

 

I understand your frustration but I do think you should not have posted the bit about "snotty comments" as this is a tight-knit bunch and John is a well respected member of this forum.  What he states is quite accurate and we here, as do most forums, frown on people posting what is perceived as being an attempt to get people to do their homework for them.

 

Let me point you to a post where I answered someone's homework problem for them and I posted the reason why I did so that others who have a similar need can follow the way they did it.

http://social.msdn.microsoft.com/Forums/en-US/accessdev/thread/68ce6770-034e-4312-b018-2c34d5b80f72

 

What John was getting at was that you need to ask specific questions about what problem you are having, not posting the questions you were asked in your homework.  Post what you have tried, where you currently are, and then specific questions about your problem.

Answer 4

Hi All, I too am trying to do this homework problem (Except my field name must be Board Donations). I'm using Access 2013. I added all the field names, and now when I try to add the 5th column and this is where I'm stuck.

I tried:

* Typing Board Donation and get error "The expression you entered contains invalid syntax"

* Typing exaclty what's listed above and get 

The result!!! Thank you so much!!!

You can see your screen. You know the structure of your tables.

I cannot, and I do not.

Whatever you typed - and you didn't tell us what you typed - contains invalid syntax. That means that there was something wrong with what you typed. Fix it and you should be cool.

One hint: if you have fieldnames containing blanks (or any other nonalphanumeric character) you must enclose the fieldname in [square brackets].

Answer 5

Posting your homework questions without any indication how - or even that - you have tried to solve them will cretainly NOT get you any help from the volunteers here. The questions as written literally TELL you what to do; have you... umm... tried to do them?

We will be glad to help you understand things, resolve confusion, and so on; but the purpose of this forum is NOT to do your homework for you.