Friday, April 10, 2009

Microsoft Acces

What is Microsoft Access?

Microsoft Access is a relational database program for Windows that provides information organization and reporting tools. Relational databases store records of information in separate tables and allow you to connect data by linking related fields, such as connecting an invoice to a customer table via a Customer ID. Microsoft Access provides a comprehensive set of tools that enable you to enter, update, display, search and report on stored information.

Building the Database in MS Access


Open MS Access. A box will pop up giving you options. Choose the radio button next to "Blank Access Database." Click "OK."


Save your database. A file box will pop up asking you for a file name. Make sure you are saving your database in the location you wish, such as "My Documents."


Type your file name, and click "Create." You will now see your database window open within the Access program.

Creating a Table Within Your Access Database


Create a table for your data. The easiest way is to choose "Create Table in Design View." You will see this within your database window. Double-click on this choice to open.


Define the fields you need for your data. Think of the information you need in your database. Are you creating a mailing list? Then the first field you need to define would be "Name." Type "Name" under the field name column.


Tab over to the Data Type column. Most data you will be entering will be text. That should be the default you are seeing. If so, and you do not want to change it, tab over to Description column. Type a description of the field, such as "Customer's name."

Push the tab key again to return to the Field Name column. Type the name of the next field you need. If you are making a mailing list, then the next field you would need would be "Street Address." Tab over and continue creating your table in the same way until all the fields you need are included. If making a mailing list, then possible fields would be Name, Street Address, City, State and Zip Code. You may also want to add fields such as "Phone Number."


Choose a Primary Key for your table. This is for the search function of the program. This can be a customer number or the customer name. It's usually the first field in the table. Click on "Customer Name" in the Field Name column. You should see an arrow to the left of the row. Look at the toolbar at the top of the screen. Find an icon of a yellow key. Click that picture. You have just made "Customer Name" your primary key.


Save your table. Your table will automatically ask you to save when you close it. Click on the "X" on the top right of your table. When you are asked if you want to save the table, say "Yes". A box will come up asking you to name your table. Name your table, and click "OK."

Adding Data to Your Access Database

Open your table and enter data. You will now be back at your main Access screen where you will see your database window open. You will see your table in this window listed by name. Now you can start entering data. To open your table, double-click on its icon.

Enter your data. Starting at "Customer Name," begin entering the data from your current mailing list. After the entry in each column, tab over until you have entered all of the information for that person. As you complete each row, another row will automatically be added below the selected row.

Finish working, and close the program. To finish working in the table, click the "X" on the right side of the table. It will automatically save. To close the database window, click "X" on the right side of the database window. To close the program, click "X" on the upper right of the screen. Your database is finished. You can add more data to the table whenever it's needed. You can also go back to design view and add more fields if needed.

Welcome To My WebQuest

What is a WebQuest?

A WebQuest is an inquiry-oriented lesson format in which most or all the information that learners work with comes from the web. The model was developed by Bernie Dodge at San Diego State University in February, 1995 with early input from SDSU/Pacific Bell Fellow Tom March, the Educational Technology staff at San Diego Unified School District, and waves of participants each summer at the Teach the Teachers Consortium.

Since those beginning days, tens of thousands of teachers have embraced WebQuests as a way to make good use of the internet while engaging their students in the kinds of thinking that the 21st century requires. The model has spread around the world, with special enthusiasm in Brazil, Spain, China, Australia and Holland.

Don't forget to visit my webquest!!

My JouRnEy..

Daisypath Anniversary Years PicDaisypath Anniversary Years Ticker