title
Please take a moment to fill out this form. We will get back to you as soon as possible.
All fields marked with an asterisk (*) are mandatory.
Relational Databases Using MS Access SQL
Course Description
Overview
This course is designed to teach students how to master the syntax and usage of Structured Query Language (SQL) with MS Access.Objectives
- Query Access Database Information using Structured Query Language
- Code sophisticated query operations such as join, grouping subselect and union
- Update data with insert, update and delete commands
- Create tables, views and indexes
- Explain Database constraints Referential Integrity and Not Null
Audience
- Programmers
- Data processing users
- IT Professionals that need a grasp of SQL with Access
Prerequisites
- Familiarity with a Windows Operating System version 98 or higher.
- Knowledge of using and implementing actions in MS Office desktop applications
Topics
- Benefits of DBMS
- Terminology
- Data Formats
- Column Types
- Select, From Where, Order by
- Where statement operators
- Not equal conditions
- IN
- Create
- Insert
- Update, Delete
- Null processing
- Copying data from one table to another
- LIKE, Arithmetic operations, format numbers
- Labels
- Round, format dates
- Year Month and Day functions
- Datediff and dateadd functions
- Common format symbols
- Between
- Mid
- Concatenation, Constants in selects, ucase, lcase
- Nesting functions
- Arithmetic operations in update statements
- Selecting information from 2 or more tables
- Selecting information from 1 table based on value in 2nd table
- Alias processing
- Where conditions with the join predicate
- Three table join
- Count, min, max, min, sum
- Avg
- Group by
- Order by and Group by ,
- Where statement and group by
- Having,
- Difference between Having and Where
- Combining 2 select statements
- Order by
- Union all
- Consistency of column types
- Union 2 selects from 2 different tables with different column names
- Simple subselect
- Complex subselect
- Immediate If statement,
- Inner Join statement
- Right Join, Left Join
- Handling Many-to-Many relationships
- IIF substituted for Group by
- Indexes
- Referential Integrity
- Security
- Alter
- Normalization
- Identity fields
- Stored Procedures
- Triggers
- Views
Related Courses
-
Microsoft 365 Access: Part 1
VS-mos6008- Duration: 1 Day
- Delivery Format: Classroom Training, Online Training
- Price: 295.00 USD
-
Microsoft 365 Access: Part 2
VS-mos6009- Duration: 1 Day
- Delivery Format: Classroom Training, Online Training
- Price: 295.00 USD
Self-Paced Training Info
Learn at your own pace with anytime, anywhere training
- Same in-demand topics as instructor-led public and private classes.
- Standalone learning or supplemental reinforcement.
- e-Learning content varies by course and technology.
- View the Self-Paced version of this outline and what is included in the SPVC course.
- Learn more about e-Learning
Course Added To Shopping Cart
bla
bla
bla
bla
bla
bla
Self-Paced Training Terms & Conditions
Exam Terms & Conditions
Sorry, there are no classes that meet your criteria.
Please contact us to schedule a class.
STOP! Before You Leave
Save 0% on this course!
Take advantage of our online-only offer & save 0% on any course !
Promo Code skip0 will be applied to your registration
Purchase Information
title
Please take a moment to fill out this form. We will get back to you as soon as possible.
All fields marked with an asterisk (*) are mandatory.