Microsoft Access Advanced
Training Objectives
You would like to create a new Database for the company? Do you have to edit and manage existing Databases? If yes, then this Seminar is the correct one for you. Participants will achieve to understand complex databases and be able to design new ones. You will learn advance techniques needed to create Tables, Query, Forms and Reports. In addition we will show you how the usage of Macros can automate your database tasks.
Course Prerequisites
Basic knowledge in Microsoft Access
Course Description
- How do I plan and design a new Database?
- The Database design: normalization of Databases
- The field data types and definitions in Tables
- Primary key and Indexes
- Relationships with Tables - enforce referential Integrity
- Different Link Types
- Advanced Form designs with sub forms (one-to-many, many-to-many relationship)
- Usage of Command buttons in Forms (Create Start form)
- Complex Queries with Relations
- Evaluations, Calculations and Groups in Queries
- Creating and designing Reports
- Automation with Macros
- Tips and Tricks
Upcoming Classes and Price
Duration
2 days
Price per Student
378,00 € plus VAT
(Price incl. 19% VAT.: 449,82 €)
On site training
For your customized - on site training we tailor the course to your needs by adapting the schedule, meeting place and applications to fit with your particular agenda. For fast problem solving you can also schedule individual time with one of our instructors (training on the job).
You could not find the class you need? Please contact us directly. We are happy to further assist you.
Keywords for this seminar
Access, Microsoft, Office, Office 2007, database, development