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