graphic2
graphic1

Hello, Microsoft Excel

3. Try it: Review the Spreadsheet

Go to the Documents Folder.

Open a File: Movies by Year.xls.

 

What Do You See? The Crosstab Table opened in Microsoft Excel. The Labels are in Row 1.

 

What Else Do You See? This spreadsheet does not include any formulas or formatting-just numbers and text.

 

Are We There, Yet? Yes, the goal was to get data out of Access and into Excel. That worked. Now you can use an impressive array of Data Tools in Excel to analyze that exported information.

 

When you are ready, Close the spreadsheet and return to Microsoft Access.

Exam 77-424: Microsoft Access 2013
1.0 Create and Manage a Database
1.5 Print and Export a Database: Export to Alternate Formats (Excel)

Microsoft Excel