Microsoft Access Basics
Training Objectives
How do I manage my Data? Everywhere are numerous types of Data; Addresses, Numbers, Projects etc… Microsoft Access provides you with many possibilities to handle the flood of data. In this Seminar you will learn the correct handling with your databases. You will create your own Database and learn more about the individual Objects as; Tables, Query, Forms and Reports.
Course Prerequisites
PC and Windows Basics
Basics in Microsoft Excel or comparable programs
Course Description
- Basics and considerations needed for creating a Database
- MS Access application window
- Creating Tables
- Data types in Access Tables (Text, Number, Date/Time etc…)
- Working with Tables (Data entry, sort, delete and filter)
- Exporting data to Excel
- Create Forms and using multiple designs
- Entering data to Forms and editing the field properties
- Create Reports and multiple report designs
- Print Reports
- Create and Edit Query
- Using different Criteria (Text, Numbers, from - to, blank fields, Yes/No etc…)
- Create calculations in Query
- Links in Query
- Basics for usage of multiple Tables
- 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, Excel, Microsoft, Office, Office 2007, database