Course
A04
Analysing and Reporting with Microsoft Access («A04»)
In this two-day Microsoft Access course, you will learn how to analyse existing databases and present the results in an appealing way. Using examples, you will learn that there are almost no limits to the possibilities in Access.
Vendor code
A04
Duration
2 days
Price
1'300.–
Course documents
Digital Digicomp courseware
Course facts
- Creating valuable evaluations from existing databases using targeted queries
- Working with Access reports
1 Introduction
- What's important about relational databases
- Working out the data base
2 Queries
- Single and multi-table queries
- Filter/Sort
- Calculations (horizontal/vertical)
- Cross tables
- SQL queries
3 Reports
- Simple Reports
- Grouped Reports
- Main and subreports
- Mail Merge
- Charts
Component of the following courses
This course is intended for PowerUsers and developers who need to build Microsoft Access databases and want to acquire the necessary knowledge in the shortest possible time.
Good Windows and Office basics are required for this course.