Are you the person who wants to create an Access database from scratch? Then you will learn how to set up the correct tables and to relate them. You'll also learn how to build complex queries, input forms and interface screens, and complex reprts. An introduction on automatization with macros wil be included as well.

Creating a database

• What is a relational database: repeating the concepts
• Normalizing a database: why and how?
• Simplified normalization: splitting repeating fields, splitting functional and transitive dependencies
• The field types down to the bone: default values, checking the input, defining a fill-in mask, etc. field properties
• Defining Fill Values
• Working with an index on one or more fields
• The different types of relationships (11, 1N, NN, types of joins)
• Understanding and Using Referential Integrity
• Optimize tables with action queries

Working with external data

• Link tables to external data sources from Excel, Access, or other
• Importing tables from external data sources
• Collecting data via email

Advanced Forms

• Create an interface form
• Adding buttons to a form
• Determine and change the layout of a form
• Working with Main and Subforms
• Use conditional formatting in forms
• Use of lists, option groups, checkboxes, etc. on a form
• Changing the common form properties to influence the layout and behavior of a form

Advanced Reports

• Grouping and sorting in a report and its sections
• Adding calculations to existing reports
• Customizing the report properties

Automate using macros

• Know when to use macros; Understanding the event concept
• Creating Macros
• Learn how to create frequently used macros
• Assigning macros to buttons and events