Wednesday, May 26, 2010

Day 7


Today we just played catch up on all of our labs, and cases and places in Access. We also went over lab 3 in chapter 2 because Dr. Jackson saw that there was some confusion on linking tables. He told us that chap 3 was just reinterating what we had been doing unknowingly in the previous chapter 1 & 2.

Tuesday, May 25, 2010

Day 6


Today in Access we learned about creating queryies. Queries are simply questions, the answers to which are in the database. Access are just databases created for departmental use. I did not know it at the time, but on my previous job i was using Access in the program SAP i used to enter payroll, and order supplies. We also learned to add fields to the design grid, use numbers in the criterion, to use comparision and compound criteria. I thought i was going to like Access, but...NOT! i am not very happy right now.

Monday, May 24, 2010

Day 5


Today we started Access chapter 1. We discussed that Access is a database. It is used to create, add, change, delete, sort, retrieve, create forms and reports. Inside the database which the repository, it is made up of a table with columns and rows. The table has to have unique design. It has to have atleast one primary key (it must be unique, only identifible by one person. Can link the tables together by the primary key. The record is the data put into the table(rows) are left to right and the columns (field) are vertical. The in class assignment was pretty cool. Access is interesting and fun so far. We will see what tomorrow will bring.

Thursday, May 20, 2010

Day 4


Today we went into detail on Excel chap. 3. Went deeper into what-if analysis, charting and workin with large worksheets. Dr. Jackson gave us a quiz on Excel asking us to calculate a 30 year mortgage monthly payment. Everyone was struggling with it, so he gave us until Saturday to finish. Im so confused and frustrated..MY BRAIN HURTS!!!!! but i refuse to give up...i will figure it out somehow...i hope.

Wednesday, May 19, 2010

Day 3


Today we worked on Excel Chapter 3 Lab 2 in class. The dealt with what-if-analysis, charting and working with large worksheets. This is a little bit more difficult than the previous chapters. Im having a problem with an assignment called Britney's Music Emporium Weekly Payroll Report. Im stuck on the what-if-analysis and I am not happy.

Tuesday, May 18, 2010

Day 2


Today, we worked on Excel Chapter 2. In Chap 2, we discussed the custom formula. We learned that when using the custom formula you must first select the cell and enter the equal sign, cell reference, use the order of operations and fill handle. We also discussed how to stack words, and how to use the average, max and min functions.

Day 1


I missed the 1st day of summer school @ hssu. I dont have any notes to enter, and the instructor Dr. Jackson wont excuse my absence (with a Dr.s statement). Im not happy.