MIS 336: Access day 3

In class today, we were given time to make up work for the access week. Doing this was very beneficial for me. It gave me the opportunity to review procedures that I need to know for the upcoming quiz over access. After todays class, i feel well prepared for the quiz tomorrow.

MIS 336 Access day 2

Today in class we are learning about queries. A query is what allows you to determine what columns you want to choose. It is defined in the book as a question presented in a way that access can process it. Queries allow you to create certain reports. Also, we learned how to join two tables together. In the query, there is a design view and a datasheet view that we can refer to. After you join the tables, then you can create a query. In order to make this possible, you must show a relationship between the tables using the primary key. A rule of normalization that we learned tonight is that is topic should have it own table. There should be a table category for first name, and one for last name. They two shouldn't be in the same column. It uses sequel language behind the screen to carry out and execute the question. We learned that http://www.w3schools.com/ allows us to learn more on sequel language. We were able to set certain criteria to find out specific information for certain clients in a database that we created. A wildcard is a symbol that represents any collection of charcters. The question mark is also a wildcard that represents an individual character. The parameter allows you to inout how you want the criteria. The comparison operators that we learned in this class were (<,>,>=,<= and NOT). AND and Or are considered the compoun criteria

Week 2:Access day one

Today in class, we were introduced to Access. We learned that Access is used to create, edit, update data in a database. The term database describes a collection of data organized in a manner that allows access,retrieval and use of that data. We learned that the primary key is the unique identifier. The rows in Access are called records, and the columns are called fields. While entering in data in the columns, we learned how to view the data in design view and in datasheet view. In the design view is where you create the structure od your datasheet. You can also change the data type in this area. We were also able to learn how to insert a form and a report of the data that we entered.

MIS 336 Week1: Excel day one

The first day of class to my understanding was full of work and completing in class projects. While in class the first day, we learn how to insert data into certain cells. The most important thing that was taught the first day was learning how to format cells. This included the backgroung color, and how to insert a graph. We also learned the basics of the status bar, which has several differnt views.

MIS class 4

In this class we started of talking about how you can freeze certain columns. You can freeze certain columns by going tothe view pane on the toolbar and go to freeze pane. We also discovered how you can use the NOW formula, that gives you the date and time that is on your computer system. The What-If analysis was also introduced. It allows you to make assumptions, and it includes greater-than and less-than formulas. By right clicking onthe cell and going to format cells and clicking on alignment, you can change the direction of your words. Three types of cell referneces were introduced in this chapter of excel. Absolute cell reference, mixed reference, and relative cell reference are the three. The if statements are introduced as well. In order to use them, use must know the logic of the statement, and the comparison operators (=,<,>,<>,>=,<=). The first part of an if statement is the logical test, then you also must know the value (true or false). A nested if function is if the if statement includes yet another if function.

Class 3: Working on Excel labs

Today in class, we were given time to work on our labs and other course work. While doing my course work today,k i learned how to create and input a bar graph. I was also able to create a spreadsheet today off of little information in a cases and places assignment in chapter two. it required me to input formulas on my own, without much guidance. This actually helped me become more confident in doing them on my own. This cases and places was about different products like candy, cookie dough, flower bulbs and etc during a fundraiser. A new equation that I had to enter was (cost per unit/1-margin). This required me to use order of operations.

Class 2: Functions, Formulas, Formatting and Web Queries

This chapter introduces how we are suppossed to use the order of operations while doing arithmetic in excel. During class I learned that pressing alt + enter, it allows me to stack my words inside one cell. Today in class, we made the spreadsheet for the Silver dollar Stock Club. While doing this, we used the fill handle tool to reach the initial cost for the entire column. It automatically multiplies two columns. It copies the previous equation used. The '=' sign must come first in your equation before you can trigger your formula. We also discussed how using Autosum, automatically sums up the total for an entire column. When an assignment uses 'highest', it really means MAX. We learned how to use the Merge and Center key, which centers the row that you choose. We also used the Cell Styles selection, which allows you to fromat a specific heading. To add some style to the spreadsheet, we learned how to use the fill button (which changes the background color). In this chapter we were also taught how to center a column by using the alignment feature, how to chnage the format of the date, by clicking on date, then more selections.