NPAccess2013_T08_PPT

new perspectives on microsoft access 2013 8

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Document XP XP (Cont.) New Perspectives on Microsoft Access 2013 8 Exporting an Access Query to an HTML Document XP XP (Cont.) • 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 New Perspectives on Microsoft Access 2013 9 Importing a CSV File as an Access Table XP XP (Cont.) • 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 positions – This is a common format for representing data in a table and is used by spreadsheet applications such as Excel as well as database applications New Perspectives on Microsoft Access 2013 10 Importing a CSV File as an Access Table XP XP (Cont.) New Perspectives on Microsoft Access 2013 11 Importing a CSV File as an Access Table XP XP (Cont.) New Perspectives on Microsoft Access 2013 12 Importing a CSV File as an Access Table XP XP (Cont.) New Perspectives on Microsoft Access 2013 13 Importing a CSV File as an Access Table XP XP (Cont.) Analyzing a Table with the Table Analyzer – – The Table Analyzer analyzes a single table and, if necessary, splits it into two or more tables that are in third normal form The Table Analyzer also looks for redundant data in the table and removes redundant fields from the table and then places them in new tables New Perspectives on Microsoft Access 2013 14 Importing a table from an Access Database • XP XP You can import tables, queries, reports, and other Access database objects New Perspectives on Microsoft Access 2013 15 Importing a table from an Access Database XP XP (Co...
View Full Document

This note was uploaded on 01/21/2014 for the course MISM 253 taught by Professor Huang during the Spring '14 term at Mustang Hs.

Ask a homework question - tutors are online