Microsoft Office Questions? Ask a IT Expert for Support ASAP
Upload the requirements and I will let you know if I can do it.....
Ok, I am at work at the moment. Can I upload it this afternoon? Will you be able to check it out? Are you familiar with access?
Ok, I got off work extremely late and didn't get a lunch. Here is the link for my project # XXXXX Now the professor said this is the easiest one and takes no time to complete. In our class, for access we had 4 projects. Projects 10 and 12 go together and projects 11 & 13 go together. So I will upload my project that I did for # XXXXX and provide my professors comments. I fixed basically everything except NF2? He said we must fix any errors to complete the next assignment or he will deduct even more points. Let me know what you think
here is #13 http://wikisend.com/download/482918/Scan_Pic0003.jpg
Access 2010: Chapter 2 Project 13 Lab 3
Office 2010: Access: Chapter 2 Project 13 Lab 3
1. Project 13: Query the Philamar Training Database - Pages AC 135
2. You must correct any errors in your Philamar Training Database before using it again.
3. Complete and submit via Blackboard : All Queries - Entire Database
Here is feedback for #11
You have four tables you are only supposed to have two you need to preform and NF2 and NF3 to ensure the tables are properly aligned and then fix the quires, reports ETC.
http://wikisend.com/download/361754/DoylePhilamarTrainingProjcet11.accdb Here is link to #11
If you can please, please help me asap I would greatly appreciate it!!! Again $20 tip and $18 questions :) Thanks and hope to hear from you soon
Hello? Please help as I am overwhelmed. I thought you would have been back online soon. I am willing to work with you. Please let me know when you're online and ready to help me. I appreciate it! I really do and will tip you very well
Hello, I just revisited this today and saw everything you have posted. I'm sorry, usually I get an e-mail when a customer updates a question, and for whatever reason, I didn't get one for this question. I had been waiting on that e-mail to come through to let me know that you had uploaded the requirements. Do you still need assistance? I can have this to you by this afternoon if you still want it. Again, I apologize, I would have acted on this sooner had I gotten notification.
Yes! Please, I really appreciate it! I was extremely worried. I was confused, b/c this isn't like you. I knew something was wrong. Anyways, I REALLY APPRECIATE IT! I'm currently working on HTML projects and the projects listed above is what I need help with. This is why I am overwhelmed. THANK YOU! Oh and don't forget to look at 11 for the feedback he provided. He stated it had to be corrected for 13 to be right. Thanks!
Not a problem.
Again, really sorry about this. For whatever reason, I didn't get any e-mails when you posted on this and I had assumed you got it taken care of. I'm going to work on it right now for you, so I'll be in this chat while I'm working
Hey, what's up?
Ok, not a problem. Thank You!
I'm pretty good with Access and this doesn't appear to be a problem. I'm going to review everything right now and get to work
I am working on my HTML project now, which is really time consuming. Thank You!
Great. well don't sweat this one, i got it
I'm not sure what is meant by "NF2" and "NF3". Can I have the specs for the original database that this is based upon?
Yes, one sec. He attached a document that explains it. Hold on...
ok.....I found this online.......
This is the same as yours except with 2 tables.....report and query is the same
i remember this stuff now
Let me know if you need anything else. I think thats everything.
you got it
Hey, just wanna let you know it's done
just wanna clean up the formatting for presentation, gimme another 20 min
Not a problem. Thank you!
Please review and let me know
This is project 13 correct? I dont have the book with me this second. Also, did you fix #11?
I only see one access doc. Just wanna make sure
U there? Where you able to fix the changes for only #11? (see professor comments). I have to submit the correct changes to him for project 11 seperately
13 looks good, I will submit and see what he says
Ok, so only questions I have is #13 looks good, however, the professor stated this to class :Name Column Name and Field Names have spaces (fix or I will deduct major points).
I can fix the spaces, I think lol. But should I adjust the excel worksheet and access projects columns to "best fit" size? I think he's paticular about that, not sure? Let me know your opinion. Sorry if I am not making sense. Oh, and only thing I am waiting on is project 11 (what you corrected). If you can send me the link for that one, thanks
Hey bud, are you busy? I thought you would be back on to check and ensure everything was fine. please let me know when you're back on. I can't submit my project until you send #11. As soon as you send it, etc.. I will accept answer and you can enjoy your evening. Thanks!
hang on, lemme catch up
Here is 11....2 tables, 2 queries
now what are you talking about with the spaces though?
I thought i already had adjusted everything in the database to best fit, but you might want to double check the excel sheet
That doesn't really make much sense to me at all
your original project 11 isn't formatted like that....and there are a lot of fields that have spaces???
there are 12 different fields that have spaces in them
I'm not sure how long i'll be up tonight....i really wish you would have put these requirements in from the beginning
listen, i'll check back here at 9pm, okay?
I'll check back here at 9pm EST.....we'll discuss
Ok, just got home. sorry, give me literally like 2 mins
See how much he takes off for this. I followed step by step in book. The rest of the class got about the same. He said any feedback he provides for any access projects, to keep in mind when doing future ones. See below
Project 10:Comments : Feed Back was given in the email. Errors in Project: Report: -3 Spelling Client Form -6 Not graded this assignment Quires: -0 Tables: ---Business Analyst:-6 Table Name Column Name and Field Names have spaces ----Client: -2 Did not reduce the Text Field Size
Project 11: You have four tables you are only supposed to have two you need to preform and NF2 and NF3 to ensure the tables are properly aligned and then fix the quires, reports ETC.
All my other projects in word, etc.. got 100%, not access
Ohhhh, the table names shouldn't have spaces
well that's different
So should I keep the same or change them?
i can do it for you if you like, VERY easy fix
In reality, this doesn't matter AT ALL
Hey i am trying to download #11, but when I save and then try and open, it states not there and some errors?
I know, but my professor is anal and will deduct anything for whatever reason he can think og
what kind of errors?
Says file does not exsist
and says or do not have read access to the file
ok, let me try that one
i don't quite understand the comments he made
for project 10
So # XXXXX has a client table, client query, client status report, trainer table right? Everything is good
? So 13, do I need to delete the spaces for the names only? sorry im all over the place
I'm working on the spaces on 13
gimme a minute
you can do the spaces on 11
but what you sent in 13 is what he wants right?
i mean 11
as far as the content of it goes, ya
ya, 2 tables in the proper format
ok so good then.... from his comments, do I remove spaces only on the field names for text and not currency, or all of them?
not sure what you mean?
from my understanding, there should be no spaces in any table/query/report names or in column headers
let me know when your done with 13, thanks
Don't mind the name, I just forgot to change the filename to 13, you can fix that
I got it :) let me check to ensure it goes through before you get ogg
*off, sorry. I cant type tonight
Got it, looks good. I'll let you know what my grade is. Its way past due but I'll arguee that with him lol
Can you do me 1 quick favor, this is my project 12 and I wanted to see if you can quickly skim through it and see if anything big stands out to you: http://wikisend.com/download/583506/DoyleCamashalyProject12.accdb
i notice spaces lol
lol I forgot
the math is wrong for ch2q11
it joins the numbers instead of adding them
but if you hit ok twice it takes it to the sheet? I dunno, my class mate and I paired up. It is easy to fix
well, if i enter 50 and 50, it should return 100
but instead it returns 5050
crap, how do you fix it, is it easy?
honestly, i'm not really sure
hang on, lemme look it up real quick
oh, it's just a matter of re-doing the query
so wait, you are supposed to enter the 2 amounts when you click on the query???
I dunno, hold on
do i enter that
you had some weird formatting in there that was wrong
but any way, everything else looks fine there
i'm out for the night
sorry, you must think i am an idiot, long day. Where do I put that at?
on ch2q11, open into design view and copy and paste what i typed above into the top of the 5th column
Or you can leave it the way it already is and remove the spaces in [Amount Due] and [Current Due]
in the field section?
it wont let me, it has drop downs to choose from
just highlight whats in there and delete it
you'll be able to paste just fine
hold on, think i got it lol, wow
it says i have entered an operand without an operator
ok it worked but on the sheet it removed the 5th column.
if you paste "Paid: [AmountPaid]+[CurrentDue]" it works perfectly
Ok bud. I really appreciate it! I will accept answer and add your much deserved tip. I hope you will be on/off throughout this week. If you want more $ and good feedback :) I think he has extra credit stuff? so up to you. later
My Professor hasn't graded all the projects yet. Here is feedback for #11, (im confused)?
Grade : 46 out of 50
Comments : Report: -4 Column Header does not have spaces
lol ok. Hey, I e-mailed my professor and he replied with the following:
When you look at a report you have the report formatted in Column's so the Column Header is the item at the top tell me what is in the report.
That would be the Column Header or Heading for each column what you have are spelling mistakes that is why you need to have spaces between the words.
For the Table, When you are in the datasheet view you have Columns once again. These Column Headings are also know as Field names in the Design View of the Table.
So when you are looking at either view the Column Name and Field Names may not have spaces because of the way the SQL language works when running a query. Spaces cause the query to run slower.
I hope this helps.
So, what would you do with the other projects?