Course package
A02
Development and Implementation of an Access Database («A02»)
In this modular, six-day intensive seminar, our experienced trainers will teach you both the theory of relational databases and their implementation in Microsoft Access using several examples.
Vendor code
A03, A04, Digicomp A05
Duration
6 days
Price
3'600.–
Course documents
Digital Digicomp courseware
Course facts
- Designing, building and implementing Access databases
1 The Relational Database Model
- Definitions and Structure
- Normal shapes
- Database modeling
2 Tables
- Creating Tables
- Import/Link Tables
- Customizing Tables
3 Table connections
- Defining Links
- Setting Relationships
4 What else to know
- Migrating Data
- Access to database servers (MySQL, MS SQL server, etc.)
- Publish Data
5 Queries
- Single and multi-table queries
- Filter/Sort
- Calculations (horizontal/vertical)
- Cross tables
- SQL queries
6 Reports Forms
- Simple Reports
- Grouped Reports
- Main and subreports
- Mail Merge
- Diagrams
7 Forms
- The simple form
- The main with subform
- The split form
- The navigation form
8 Automate Operations
- Makros versus Module (VBA)
- The Simple Macro
- The Group Macro
- The Autoexec macro
- Macro conditions and filters
- Create and customize VBA code with wizards
9 Database security
- Backup Methods
- Multi-user access
10 The finishing touch
- The Startup Options
- Custom Ribbons
- Publish and package the database
PowerUsers and developers who need to build Microsoft Access databases and want to acquire the necessary knowledge in the shortest possible time
Good Windows (7, 8.x, or 10) and Office basics are required for this course.