In this course, you'll learn how to create tables, insert records, alter tables, and use various types of queries and joins in Microsoft Access. You'll also learn about functions, arithmetic operators, sorting, and much more. By the end of the course, you'll have a strong foundation in SQL and Microsoft Access, and you'll be ready to take your skills to the next level. No prior experience is required - just a willingness to learn!
Course overview
Welcome to SQL with Microsoft Access for Beginners! This course is designed to provide you with a solid foundation in SQL (Structured Query Language) using Microsoft Access. By the end of this course, you will be proficient in creating tables, inserting records, querying data, utilizing SQL commands, and understanding the basic concepts of SQL within the Microsoft Access environment.
13 Lessons-
SQL with Microsoft Access for Beginners-3 Ways in creating calculated field 118:45 min
-
Create table17:25 min
-
Inserting records10:16 min
-
Alter Table12:29 min
-
Select Query45 min
-
AND, OR, LIKE1:30 min
-
In, Between, Brackets1 hr
-
Subqueries59 min
-
Sorting70 min
-
Arithmetical operators, functions45 min
-
Group By, Max, Min, Average19:51 min
-
Joining tables59 min
-
Having, Update1:30 min
Prince Armstrong
Login To Leave Review
- Price
GH₵2,000.00
GH₵3,000.00 - Instructor Prince Armstrong
- Duration 30 days
- Category Database
- Curriculum 1
- Lectures 13
- Enrolled 4
Students Feedback
Tina