ITM309-Spring2011-Assignment4-Access-Tas

ITM309-Spring2011-Assignment4-Access-Tas - Make sure that...

Info iconThis preview shows pages 1–5. Sign up to view the full content.

View Full Document Right Arrow Icon
Importing Excel Data into Access For ITM 309 Assignment #4:Task one Step One: Download the excel sheet from Angel, and create the new Access Database as directed in the assignment instructions. Step Two: Choose External Data Excel A dialog box will open:
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Step Three: Then hit “Browse”, and Choose the teleworks excel file, then click “Open” Then hit “OK” Step Four: The Import Spreadsheet Wizard will appear:
Background image of page 2
Step Five: Choose the Excel worksheet that you wish to import, then click “Next” Step Six: Make sure that “First Row Contains Column Headings” is checked, then click “Next” Step Seven:
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 4
Background image of page 5
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Make sure that In a New Table is selected, then click Next Step Eight: Select Choose My Own Primary Key, then click Next Step Nine: Click Finish, then OK Step Ten: Uncheck save import steps and then click close A New Table will be created. Step Eleven: Repeat Steps 1-10 for all tables in the Teleworks spreadsheet. Step Twelve: Create the relationships as described in the Assignment Instructions. Make sure that you enforce referential integrity on all relationships. When you have completed the relationships, they should look like this....
View Full Document

Page1 / 5

ITM309-Spring2011-Assignment4-Access-Tas - Make sure that...

This preview shows document pages 1 - 5. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online