Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
Data is better protected and maintained when it can be shared using a database instead of creating new iterations of the same data stored in new files for every new application. This course enables database users to explore the powerful features of queries.
At the end of the course, participants would learn/use/acquire the following techniques/knowledge:
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Course Introduction|
|Section 2: Select query|
Select query Part 1Preview
Select query Part 2Preview
|Section 3: Running a Select Query|
Running a Select Query
|Section 4: The Query Design Window|
The Query Design Window
|Section 5: Adding fields to a query, Display/Suppress the display of a field|
Adding fields to a query, Display/Suppress the display of a field
|Section 6: Removing fields from a query|
Removing fields from a query
|Section 7: Specifying sub string searches using wild Card Characters|
Specifying sub string searches using wild Card Characters
|Section 8: Working with Conditions - BETWEEN, AND, OR, NOT, NULL|
Working with Conditions - BETWEEN, AND, OR, NOT, NULL
|Section 9: Calculated fields|
|Section 10: Multiple Table Queries|
Multiple Table Queries
|Section 11: Joining Tables for a query|
Joining Tables for a query Part 1
Joining Tables for a query Part 2
|Section 12: Join Properties - Inner and Outer Joins|
Join Properties - Inner and Outer Joins
|Section 13: Make Table Query|
Make Table Query
|Section 14: Append Query|
|Section 15: Delete Query|
|Section 16: Update Query|
|Section 17: Additional Material|
|Section 18: Exercise|
|Section 19: Mock Test|
|Section 20: Course Conclusion|
Bonus Lecture on Data Management Challenges in Access - Demystified
GreyCampus is a leading provider of certification training solutions for professionals globally. We offer a personalized, interactive and engaging learning experience for professionals across sectors to help them clear the certification exams of their choice quickly and easily.
Our online learning portal uses a highly advanced, analytics-driven technology platform to deliver courses that are highly personalized, adapt to your learning needs and constantly provide feedback to help you achieve your objectives. Each eLearning program is independently hosted on a Cloud platform that guarantees 99.99% availability anywhere in the world 24×7.