Tutorial 3- A how to step by step process of importing an Excel spreadsheet into Access

Databases are great tools and one of its best attributes is the ability to import external data. I have great news for you today as I will show you a step by step procedure on how to import an excel spreadsheet into Microsoft Office Access 2007. Before we began our step by step lesson I will explain first what this means to import an external data. Importing an Excel spreadsheet into Access is gathering data from an Excel file and entering the data into Access without retyping huge amounts of data. This process save you lots of time and allows you to use an excellent program.

Step 1: After Access has been opened press the "External Data" tab.

Step 2: In the import section of the ribbon press the "Excel" button.

            Step 3: Press the "Browse" button when the "Get External Data-Excel Spreadsheet" window opens.

Press the box to view the image

            Step 4: Select the file you will like to open and press "Open." ***Note: Know where you have your file saved.

            Step 5: Press the "OK" button after you file has opened.

            Step 6:  Make sure that if you have a headings column you check the box that acknowledges headings then press "Next."

           

            Step 7: In the "Field Options" box choose each field and select its data type. IE: Text, Then press "Next"

 Press the box to view the image

           Step 8: When selecting your primary key you have the option to choose the key yourself or let Access choose the key for you.

            Step 9: Press "Next" and then press "Finish" and finally press "Close."

            Now that you have successfully imported a file into Access look at your data and see if the formatting is correct. Access will allow you to change things that you might have mistakenly done. After your file has been imported and the formatting is correct let the fun begin and improve your work speed.

Acknowledgements: 

Pictures have been created by Joel Acevedo for public use. 

Database Project

I learned how to create and what are databases during this project. I use my employers’ database in my job everyday as an end user. However I never knew exactly what I was working with until I started this project. I realized this when I started to create forms and began to enter the data for the new members. I recognize some similar attributes of what we were creating with this project and what I am currently using at work.  The ability to have read only users and automated numbers are those attributes that caught my attention and made me realize what databases do for business and end users.

                Things that I would like to enhance about databases are the ability to change views from a tab instead of a drop down menu and having easier ways to add headers and footers. Having tabs instead of drop down menu makes a multiple button pressing step into a single press. This improves an employee’s speed and will allow the employees to work on other things. Adding headers and footers are difficult in databases because you have to add a text box instead of just tabbing in the section and start typing. This new ability will also increase work speed. Databases are great tools for companies with large amounts of data because they improve work speed, however; work speed can still be improved.

Acknowledgement:

Picture was created by Joel Acevedo for public use

Presentation Project-World Vision

The logical flow and sequence of the presentation is made to grab a person’s attention at the beginning and inform them about world vision. Then to let people know what is going to kids around the world. After accomplishing these tasks the presentation is build to paint a picture in people’s mind of how would they feel if their kids were in those situations. Finally we ask the audience to help a child with sponsorship. I could have improved the presentation by adding voice over during the presentation. However I did not have the equipment or money to make this happen.

The presentation answers the question of who is World Vision so that the audience does not feel that World Vision is a fraudulent organization. Then the presentation places a question to the audience that makes them feel like everyone in this world should have food to eat. The question gets the audience to understand that not everyone lives in countries like United States where people have food to eat and they need to help. The presentation then makes a statement that not everyone gets an education. Afterwards the statement is supported by a video of places in Africa without schools and water wells for kids.   

The presentation is straightforward without error or exaggerated statements and making each slide easy to read by creating spaces between lines. There is not a narrator throughout the presentation which makes this presentation a brain teaser to make people think about what is happening in the world so that they can change it.

Web 2.0 is very intriguing tools and they are still complicated tools for me to use. I learned many things while doing this project. For example how to add a YouTube file to a page and how to synchronize them to other slides. Webs 2.0 are great tools because they allow people to gather information throughout the world so that they can make a bigger impression on people. Impressions are the keys to a business success because it is not what you think about your company but what others think about it.

 I will learn more about Web 2.0 because when making a presentation to a company I can use many tools. The ability to use videos and with other tools combine gives me the freedom to be creative. I also enjoy the satisfaction of not having to carry around a USB drive because there have been times in my life where I could not find my USB drive and it had ruined my presentation. Web 2.0 gives me the power to always be prepared for my presentations.

Here is my presentation and hope you enjoy and now let the show begin.


http://portal.sliderocket.com/AOUII/Presentation-World-Vision


Let us united the world!!!