Office 2007 Integration

Office 2007 Integration - but dont Access very well But...

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

View Full Document Right Arrow Icon
Click to edit Master subtitle style 4/8/11 Office 2007 Integration BUS 311
Background image of page 1

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

View Full DocumentRight Arrow Icon
4/8/11 Importing Limitations You only import single Excel worksheets, not entire workbooks. You can import 255 columns of data into a table in Access.
Background image of page 2
4/8/11 Prepare Data 1. Add headings to all columns, because they'll make your data easier to use in Access 2. Remove any unwanted or blank rows or columns from the worksheet. You
Background image of page 3

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

View Full DocumentRight Arrow Icon
4/8/11 Verify Imports ALWAYS Verify Import worked correctly Blank Columns in Excel are named
Background image of page 4
4/8/11 Why Excel For Reporting Statistical Analysis is not a strength of Access Financial statement analysis is often more efficient to use Excel Comfort level Many business professionals know Excel
Background image of page 5

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

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

Unformatted text preview: but dont Access very well But still need centralized storage and ability to constantly be working with most up-to-4/8/11 In-Class Activity For budgeting purposes, each department (MIS, Finance, Marketing, etc.) wants to know how many students in their respective majors owe money and what the aggregated total outstanding balance is. 1. Build a query to return all records in the students table for the Fall 2010 semester, but only return records where students have an outstanding balance for the Fall 2010 term. 2. Create a Table in Excel linked to this query (sort by major, format the table, create a...
View Full Document

This note was uploaded on 04/08/2011 for the course BUS 311 taught by Professor Reardon,j during the Spring '08 term at University of Hawaii, Manoa.

Page1 / 6

Office 2007 Integration - but dont Access very well But...

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

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