|
Access 308 continues our advanced Access
database development with VBA programming.
This class focuses on importing and exporting
data. We'll learn about the different types of importing and exporting,
and what it's used for. You will see how to export tables to another
Access database, how to export query data to Microsoft Excel, and how to
use the OfficeLink button to export data to both Excel and Word.
We don't stop there. That's just the easy stuff.
Next, we'll learn about comma delimited and
fixed-width text files. How to create an import/export specification;
how to create a macro to export text automatically using the
TransferText action. We'll then learn about a similar TransferSpreadsheet macro action.
You will then learn how to import data from
another Access database; how to append imported records to an existing
table; how to link to tables in another database; how to link to an
existing Excel spreadsheet; how to link to a Named Range in Excel; and
how to link to a text file.
Finally, I'll show you a neat trick - how to take
a name like "Joe Smith" and split it into two fields "Joe" and "Smith."
ACCESS 308
Lesson 1.
- Working with External Data
- ODBC (Open DataBase Connectivity)
- Importing & Exporting Data
- Linking v. Importing
- Examples
Lesson 2.
- Exporting to another Access database
- Creating a Blank Sales Rep database
- Exporting Customer Table
- Exporting to an Excel Spreadsheet file
- Creating a query to limit our data
- Exporting the query data to Excel
- Using the OfficeLink button
- Analyze It with Microsoft Excel
- Publish It with Microsoft Word
Lesson 3.
- EXport Text: Comma Delimited
- Export Text: Fixed Width
- Create EXport Specification
- Create a Macro to Export Text
- TransferText Action
- Create a Macro to Export to Excel
- TransferSpreadsheet Action
Lesson 4.
- Import From Another Database
- Appending Records To Existing Table
- Matching Field Names (Append Query)
- Creating Values For Unmatched Fields
- Import From an Excel Spreadsheet
- Import Wizard
Lesson 5.
- Importing Delimited Text File
- Importing Fixed Width Text File
- Fields That Are Directly Adjacent
- Linking To Tables in Another Database
- Linking To A Spreadsheet
- Linking To A Named Range in Excel
- Linking To A Text File
Lesson 6.
- Splitting Single Name Field into Two
- INSTR Function
- LEFT and RIGHT Functions
- LEN Function
|
