4 Weekends Microsoft Access Training Course in Vienna
Event Information
About this Event
4 Weekends Microsoft Access Training course is being delivered from January 16, 2021 - February 7, 2021for 16 Hours over 4 weekends, 8 sessions, 2 sessions per weekend, 2 hours per session.
- All Published Ticket Prices are in US Dollars
- The course will be taught in English language
4 Weekends Microsoft Access Training Course Schedule
- January 16, 2021 - February 7, 2021 US Pacific time
- 4 Weekends | 2 Hours on Saturdays, 2 Hours on Sundays every weekend US Pacific time
- 7:30 AM - 9:30 AM US Pacific time each of those days
- Please click here to add your city name and check your local date and time for the first session to be held on January 16, 2021 at 7:30 AM US Pacific Time.
Features and Benefits
- 16 Hours, 8 sessions, 4 weekends of total Instructor-led and guided training
- Training material, instructor handouts and access to useful resources on the cloud provided
- Practical Hands-on Lab exercises provided
- Actual code and scripts provided
- Real-life Scenarios
Course Objectives
- Understand how to design advanced queries, forms and reports
- Learn how to save all data in one place
- Learn how Access can work with Other Microsoft Office programs
- Learn how to extract the information required
- Knowledge about the structure and advantages of a database.
- Build a database with a good relational structure.
- How to create basic to advanced reports and design Access databases.
Course Prerequisites
Basic Computer skills
Who can take this course?
Those aspiring to learn Microsoft Access.
Course Outline
1. Database Fundamentals
- RDBMS concepts
- Database Design Principles
- Introduction to MS-Access
- Creating Database in MS-Access
- MS-Access Objects - Introductions
- Tables
- Forms
- Queries
- Reports
- Macros
- Modules
2. Database Constraints (Primary Key, Foreign Key) SQL - Structured Query Language
- SQL Commands
- Data types
3. Data Definition Language
- Create Table Command
- Alter Table Command
- Drop Table Command
4. Data Manipulation Language
- Select Command
- Insert Command
- Update Command
- Delete Command
5. Filter Clause
- WHERE Clause
- GROUP BY Clause
- Having Clause
- Order by Clause
6. Operators
- Arithmetic Operators
- Comparison operators
- Logical Operators
7. Range Operators
- IN/NOT IN
- Between
Set Operators
- Union
- Union All
- Intersect
8. SQL Functions
- Aggregate Function
- Date Function
- String Function
9. Joins
- Simple Join
- Equi Join
- Non equi Join
- Self Join
- Inner Join
- Outer Join
- Left Outer Join
- Right Outer Join
10. Queries
- Simple Queries
- Sub queries
- Nested Queries
- Correlated Sub Query
11. Search Expressions
- Like
- with Nulls
12. FORMS
- FORM Controls
- TextBox, Combobox, CheckBox, Option Button, ListBox, Labels, Command Buttons etc.
- Form Events
- Design Forms
- Sub Forms
- SQL commands using in VBA modules
- Linked Table,
- Import Text File, Excel File, CSV File
- Export Data to Excel File, Text File,
- Connecting to Excel
- Consolidate Excel Files to Access Database
- Automation Project