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. 

Tutorial 2- Absolute Cell Reference

Microsoft Excel is a very useful application software. Excel has many tools that save businesses time and money. One of those many tools is functions. Functions allow users to copy formulas so that they do not have to recreate a formula in a different cell. The ability to copy formulas saves a business so much time to do other productive task. 

Absolute Cell Reference is a cell that you do not want changed as a formula is copied. An example of an Absolute Cell Reference is when the user wants to calculate a 6.5% tax on every transaction they will record on your spreadsheet. To create an Absolute Cell Reference the user will need to use dollar signs before the cell letter and number. For example the user needs to type $B$6 to make the cell absolute in the function.

Here is an image below:





Now that you have a grasp of what is Absolute Cell Reference watch this video and follow along for further comprehension of Absolute Cell Reference.

 

http://www.youtube.com/watch?v=EmYkBsnrvn4


Special Thanks:

http://office.microsoft.com/en-us/excel-help/get-to-know-excel-enter-formulas-RZ006107930.aspx?section=13 for the absolute cell reference definition.

Image was created by Joel Acevedo for Public Use.

http://www.youtube.com/watch?v=EmYkBsnrvn4 For video use.