Download - DMDW 1. Student Presentation - Access 2007
![Page 1: DMDW 1. Student Presentation - Access 2007](https://reader035.vdocuments.us/reader035/viewer/2022081514/555059bbb4c905ae3f8b4d71/html5/thumbnails/1.jpg)
12.04.2023 1SRH Heidelberg
by Matthias Kocher, Sebastian Mohr and Sebastian Hohenadel
How to integrate a data file in Microsoft Access
![Page 2: DMDW 1. Student Presentation - Access 2007](https://reader035.vdocuments.us/reader035/viewer/2022081514/555059bbb4c905ae3f8b4d71/html5/thumbnails/2.jpg)
12.04.2023 2SRH Heidelberg
IntroductionTaskToolsProblems and SolutionsSmall tutorialLive Demo
Content
![Page 3: DMDW 1. Student Presentation - Access 2007](https://reader035.vdocuments.us/reader035/viewer/2022081514/555059bbb4c905ae3f8b4d71/html5/thumbnails/3.jpg)
12.04.2023 3SRH Heidelberg
Matthias Kocher, 1989, Bachelor of Science, future Master of Science
Sebastian Mohr, 1983, Bachelor of Science, future Master of Science
Sebastian Hohenadel, 1984, Bachelor of Science, future Master of Science
Introduction
![Page 4: DMDW 1. Student Presentation - Access 2007](https://reader035.vdocuments.us/reader035/viewer/2022081514/555059bbb4c905ae3f8b4d71/html5/thumbnails/4.jpg)
12.04.2023 4SRH Heidelberg
Integration of an ExcelSheet in a database format
Task
![Page 5: DMDW 1. Student Presentation - Access 2007](https://reader035.vdocuments.us/reader035/viewer/2022081514/555059bbb4c905ae3f8b4d71/html5/thumbnails/5.jpg)
12.04.2023 5SRH Heidelberg
Microsoft Access 2007Microsoft Access 2010Microsoft Excel 2007Microsoft Excel 2010
Tools
![Page 6: DMDW 1. Student Presentation - Access 2007](https://reader035.vdocuments.us/reader035/viewer/2022081514/555059bbb4c905ae3f8b4d71/html5/thumbnails/6.jpg)
12.04.2023 6SRH Heidelberg
Several import errors - source has no column heading - empty space
Format errors - Date / Time
Problems
![Page 7: DMDW 1. Student Presentation - Access 2007](https://reader035.vdocuments.us/reader035/viewer/2022081514/555059bbb4c905ae3f8b4d71/html5/thumbnails/7.jpg)
12.04.2023 7SRH Heidelberg
Manual correction
Usage of Microsoft Access 2010
Solutions
![Page 8: DMDW 1. Student Presentation - Access 2007](https://reader035.vdocuments.us/reader035/viewer/2022081514/555059bbb4c905ae3f8b4d71/html5/thumbnails/8.jpg)
12.04.2023 8SRH Heidelberg
![Page 9: DMDW 1. Student Presentation - Access 2007](https://reader035.vdocuments.us/reader035/viewer/2022081514/555059bbb4c905ae3f8b4d71/html5/thumbnails/9.jpg)
12.04.2023 9SRH Heidelberg
![Page 10: DMDW 1. Student Presentation - Access 2007](https://reader035.vdocuments.us/reader035/viewer/2022081514/555059bbb4c905ae3f8b4d71/html5/thumbnails/10.jpg)
12.04.2023 10SRH Heidelberg
![Page 11: DMDW 1. Student Presentation - Access 2007](https://reader035.vdocuments.us/reader035/viewer/2022081514/555059bbb4c905ae3f8b4d71/html5/thumbnails/11.jpg)
12.04.2023 11SRH Heidelberg
![Page 12: DMDW 1. Student Presentation - Access 2007](https://reader035.vdocuments.us/reader035/viewer/2022081514/555059bbb4c905ae3f8b4d71/html5/thumbnails/12.jpg)
12.04.2023 12SRH Heidelberg
![Page 13: DMDW 1. Student Presentation - Access 2007](https://reader035.vdocuments.us/reader035/viewer/2022081514/555059bbb4c905ae3f8b4d71/html5/thumbnails/13.jpg)
12.04.2023 13SRH Heidelberg
![Page 14: DMDW 1. Student Presentation - Access 2007](https://reader035.vdocuments.us/reader035/viewer/2022081514/555059bbb4c905ae3f8b4d71/html5/thumbnails/14.jpg)
12.04.2023 14SRH Heidelberg
![Page 15: DMDW 1. Student Presentation - Access 2007](https://reader035.vdocuments.us/reader035/viewer/2022081514/555059bbb4c905ae3f8b4d71/html5/thumbnails/15.jpg)
12.04.2023 15SRH Heidelberg
![Page 16: DMDW 1. Student Presentation - Access 2007](https://reader035.vdocuments.us/reader035/viewer/2022081514/555059bbb4c905ae3f8b4d71/html5/thumbnails/16.jpg)
12.04.2023 16SRH Heidelberg
![Page 17: DMDW 1. Student Presentation - Access 2007](https://reader035.vdocuments.us/reader035/viewer/2022081514/555059bbb4c905ae3f8b4d71/html5/thumbnails/17.jpg)
12.04.2023 17SRH Heidelberg
![Page 18: DMDW 1. Student Presentation - Access 2007](https://reader035.vdocuments.us/reader035/viewer/2022081514/555059bbb4c905ae3f8b4d71/html5/thumbnails/18.jpg)
12.04.2023 18SRH Heidelberg
Enjoy the show
Live Demonstration