NPAccess2013_T08_PPT

NPAccess2013_T08_PPT - XP XP Tutorial 8 Sharing Integrating...

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

View Full Document Right Arrow Icon
XP Microsoft Access 2013 ® ® Tutorial 8 Sharing, Integrating and Analyzing Data
Background image of page 1

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

View Full Document Right Arrow Icon
XP Objectives Session 8.1 Export an Access query to an HTML document and view the document Import a CSV file as an Access table Use the Table Analyzer Import a table from another Access database Import and export XML files Save and run import and export specifications New Perspectives on Microsoft Access 2013 2
Background image of page 2
XP Objectives (Cont.) Session 8.2 Create a tabbed form using a tab control Understand the difference between importing, embedding, and linking external objects Embed a chart in a form Create and use an application part Export a PDF file Link data from an Excel workbook New Perspectives on Microsoft Access 2013 3
Background image of page 3

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

View Full Document Right Arrow Icon
XP Sharing, Integrating and Analyzing Data Case - Chatham Community Health Services Creating Custom Reports for Chatham Community Health Services User wants other employees to have access to the Clinic database and share data among the different programs employees use User would also like to be able to analyze the data in the database Tasks include: Importing, exporting, linking, and embedding data Creating application parts Explore the charting features New Perspectives on Microsoft Access 2013 4
Background image of page 4
XP Sharing, Integrating and Analyzing Data (Cont.) New Perspectives on Microsoft Access 2013 5
Background image of page 5

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

View Full Document Right Arrow Icon
XP New Perspectives on Microsoft Access 2013 6 Sharing, Integrating and Analyzing Data (Cont.)
Background image of page 6
XP Exporting an Access Query to an HTML Document New Perspectives on Microsoft Access 2013 7
Background image of page 7

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

View Full Document Right Arrow Icon
XP Exporting an Access Query to an HTML Document (Cont.) New Perspectives on Microsoft Access 2013 8
Background image of page 8
XP Exporting an Access Query to an HTML Document (Cont.) New Perspectives on Microsoft Access 2013 9 Viewing an HTML Document Using Internet Explorer You can view the HTML document that you created using any web browser Right-click Crosstab in the file list to open the shortcut menu Click Open with Click the name of your web browser, such as Internet Explorer Click the OK button (if necessary). Internet Explorer starts and opens the Crosstab web page
Background image of page 9

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

View Full Document Right Arrow Icon
XP Importing a CSV File as an Access Table (Cont.) New Perspectives on Microsoft Access 2013 10 A CSV (comma-separated values) file is a text file in which commas separate values, and each line is a record containing the same number of values in the same
Background image of page 10
Image of page 11
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

Page1 / 48

NPAccess2013_T08_PPT - XP XP Tutorial 8 Sharing Integrating...

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

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