Microsoft+Access

 Ø  open Microsoft office access 2007  Ø  click on “Blank database”  Ø  on the right side of the screen you should see a place to name the database  Ø  after you name it hit create  Ø  after you create the database, click on the “external data” tab  Ø  Click on text file if you’re importing a text file or excel if you’re importing an excel file etc,  Ø  Then you click browse in order to find the file  Ø  Click ok  Ø   If the database that you’re importing contains headings, then check the box that says “First Row Contains Column Headings”  Ø  Click next  Ø  Select each column separately and make sure that the data type is on the “text” option, if it isn’t, then scroll down and select the text option  Ø  Click next  Ø  Select the box “no primary key”  Ø  Click next  Ø  Click finish  Ø  Click close <span style="FONT-SIZE: 12pt; LINE-HEIGHT: 115%; FONT-FAMILY: Wingdings; mso-fareast-font-family: Wingdings; mso-bidi-font-family: Wingdings"> Ø  Now you’ve imported the file <span style="FONT-SIZE: 12pt; LINE-HEIGHT: 115%; FONT-FAMILY: Wingdings; mso-fareast-font-family: Wingdings; mso-bidi-font-family: Wingdings"> Ø  To view it, double click on “item numbers” on the left hand side <span style="FONT-SIZE: 12pt; LINE-HEIGHT: 115%; FONT-FAMILY: Wingdings; mso-fareast-font-family: Wingdings; mso-bidi-font-family: Wingdings"> Ø  Click on the “create” tab <span style="FONT-SIZE: 12pt; LINE-HEIGHT: 115%; FONT-FAMILY: Wingdings; mso-fareast-font-family: Wingdings; mso-bidi-font-family: Wingdings"> Ø  Select “query design” in “other” <span style="FONT-SIZE: 12pt; LINE-HEIGHT: 115%; FONT-FAMILY: Wingdings; mso-fareast-font-family: Wingdings; mso-bidi-font-family: Wingdings"> Ø  Click add <span style="FONT-SIZE: 12pt; LINE-HEIGHT: 115%; FONT-FAMILY: Wingdings; mso-fareast-font-family: Wingdings; mso-bidi-font-family: Wingdings"> Ø  Click close <span style="FONT-SIZE: 12pt; LINE-HEIGHT: 115%; FONT-FAMILY: Wingdings; mso-fareast-font-family: Wingdings; mso-bidi-font-family: Wingdings"> Ø  From the item numbers box select the fields that you need by double clicking on them <span style="FONT-SIZE: 12pt; LINE-HEIGHT: 115%; FONT-FAMILY: Wingdings; mso-fareast-font-family: Wingdings; mso-bidi-font-family: Wingdings"> Ø  If you want a specific criteria in a certain field you type: like “criteria” in the designated field. For example if you want to see all the sociology classes offered at TCC you would write in the criteria row, under the courses column like “SOC*” The asterix is to say that we need all the sociology classes regardless of their number. <span style="FONT-SIZE: 12pt; LINE-HEIGHT: 115%; FONT-FAMILY: Wingdings; mso-fareast-font-family: Wingdings; mso-bidi-font-family: Wingdings"> Ø  If you want to group items in fields, you click on the “design” tab and select “totals” in “show / hide” <span style="FONT-SIZE: 12pt; LINE-HEIGHT: 115%; FONT-FAMILY: Wingdings; mso-fareast-font-family: Wingdings; mso-bidi-font-family: Wingdings"> Ø  After you design your query, in order to view it, you click on “view” on the left hand side, and you select “Datasheet View” <span style="FONT-SIZE: 12pt; LINE-HEIGHT: 115%; FONT-FAMILY: Wingdings; mso-fareast-font-family: Wingdings; mso-bidi-font-family: Wingdings"> Ø  To save the query, you close it and say “yes” when it asks you whether you want to save it, and then choose and name for it.
 * __ Microsoft access 2007 __**
 * __ Create a database on Microsoft access 2007 __**
 * __ Import external data on Microsoft access 2007 __**
 * __ Create a new query on Microsoft access 2007 __**

**__ Create a chart from a query: __** <span style="FONT-SIZE: 12pt; LINE-HEIGHT: 115%; FONT-FAMILY: Wingdings; mso-fareast-font-family: Wingdings; mso-bidi-font-family: Wingdings"> Ø  after you’ve created a query and you have it opened click on the “create” tab and select in the “forms” section the “pivot charts” option. <span style="FONT-SIZE: 12pt; LINE-HEIGHT: 115%; FONT-FAMILY: Wingdings; mso-fareast-font-family: Wingdings; mso-bidi-font-family: Wingdings"> Ø  Once you click on it you get an empty chart. <span style="FONT-SIZE: 12pt; LINE-HEIGHT: 115%; FONT-FAMILY: Wingdings; mso-fareast-font-family: Wingdings; mso-bidi-font-family: Wingdings"> Ø  You can select what type of chart you want in the “type” section by clicking on “change chart type.” However, if you’re satisfied with the default chart type you can proceed to the next step. <span style="FONT-SIZE: 12pt; LINE-HEIGHT: 115%; FONT-FAMILY: Wingdings; mso-fareast-font-family: Wingdings; mso-bidi-font-family: Wingdings"> Ø  To get the data that you need, write click anywhere in the chart and select the “field list” option. <span style="FONT-SIZE: 12pt; LINE-HEIGHT: 115%; FONT-FAMILY: Wingdings; mso-fareast-font-family: Wingdings; mso-bidi-font-family: Wingdings"> Ø  A little box pops up on the right side of the screen. <span style="FONT-SIZE: 12pt; LINE-HEIGHT: 115%; FONT-FAMILY: Wingdings; mso-fareast-font-family: Wingdings; mso-bidi-font-family: Wingdings"> Ø  In that box, you will find all the data sections that are in the query that you selected. <span style="FONT-SIZE: 12pt; LINE-HEIGHT: 115%; FONT-FAMILY: Wingdings; mso-fareast-font-family: Wingdings; mso-bidi-font-family: Wingdings"> Ø  If you’re trying to graph/chart something that is dependent on another factor(example if you’re trying to make a chart of how many students eat ice cream each hour), you drag the hour factor from the little box to the square below the chart that says “drag category fields here.” And then drag the data fields (which in the example would be the number of students who eat ice cream ) to the box that is on top of the chart and that says “ drag data fields here.” <span style="FONT-SIZE: 12pt; LINE-HEIGHT: 115%; FONT-FAMILY: Wingdings; mso-fareast-font-family: Wingdings; mso-bidi-font-family: Wingdings"> Ø  After you put in your data, you can now proceed to put legends(titles) on the chart <span style="FONT-SIZE: 12pt; LINE-HEIGHT: 115%; FONT-FAMILY: Wingdings; mso-fareast-font-family: Wingdings; mso-bidi-font-family: Wingdings"> Ø  In the example that I gave, the legend on the bottom of the chart would have to be Hours, and then legend on top of the chart would have to be number of ice cream eaten by each student. <span style="FONT-SIZE: 12pt; LINE-HEIGHT: 115%; FONT-FAMILY: Wingdings; mso-fareast-font-family: Wingdings; mso-bidi-font-family: Wingdings"> Ø  In order to do that, click on the legend that you want to change, then click on the “design” tab. <span style="FONT-SIZE: 12pt; LINE-HEIGHT: 115%; FONT-FAMILY: Wingdings; mso-fareast-font-family: Wingdings; mso-bidi-font-family: Wingdings"> Ø  In the “tools” section, click on the “property sheet” option, then select “format”, in the bottom of the box, there is a field that says “captions”; that is where you want to type “Hours”, or whatever other legend you wish to type. <span style="FONT-SIZE: 12pt; LINE-HEIGHT: 115%; FONT-FAMILY: Wingdings; mso-fareast-font-family: Wingdings; mso-bidi-font-family: Wingdings"> Ø  Follow the same procedure to change any legend you want. <span style="FONT-SIZE: 12pt; LINE-HEIGHT: 115%; FONT-FAMILY: Wingdings; mso-fareast-font-family: Wingdings; mso-bidi-font-family: Wingdings"> Ø  After you’ve changed the legends, and you’re satisfied with the chart, now you can go ahead and save your chart. <span style="FONT-SIZE: 12pt; LINE-HEIGHT: 115%; FONT-FAMILY: Wingdings; mso-fareast-font-family: Wingdings; mso-bidi-font-family: Wingdings"> Ø  To do that just click save. When they ask you to give a name for the chart, give it a name that would make sense for future use.