Chapter Demonstrable Skills
After completing the Access Chapter 8 portion of the Access unit, students will be able to:
Demonstrable Skill | Learning Activities & Informal Assessments |
Formal Assessments (excluding Exams) |
---|---|---|
Import data from Microsoft Excel workbooks. |
|
|
Import data from CSV and text files. |
|
|
Export data to Microsoft Excel workbooks. |
|
|
Share data with other Microsoft Access databases. |
|
|
Export report data to other file formats. |
|
|
Chapter Notes
Importing an Excel worksheet
If you have data in an Excel worksheet and wish to work on that data in Access, you can do so by importing the Excel worksheet into Access using the External Data ribbon [1].
Importing data from text files
There are two main types of text files that can be imported using the External Data ribbon [1]:
- CSV files, which use a comma to separate the values in each column.
- Fixed length TXT files, where each column is of a specific fixed length.
References
- A. Poatsy, K. Mulberry, C. Krebs, L. Hogan, A. Rutledge, and E. Cameron, Exploring Microsoft Office 2013, 1st ed., vol. 2. Upper Saddle River, NJ: Pearson Education, 2013.