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.
Although tables store all of your data, the other three objects—forms, queries, and reports—offer you ways to work with it. Each of these objects interacts with the records stored in your database's tables. This course allows you to unleash these objects and use your relational database efficiently.
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|
|Section 3: Running a Select Query|
Running a Select Query
|Section 4: The Query Design Window|
The Query Design WindowPreview
|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: Creating Forms using Wizard|
Creating Forms using Wizard
|Section 11: Working with Form Layout View|
Working with Form Layout View
|Section 12: Using Design view|
Using Design view
|Section 13: Introducing Sub Forms|
Introducing Sub Forms
|Section 14: Properties of Different Controls & Forms|
Properties of Different Controls & Forms
|Section 15: Using Controls in Forms (Command Button, Labels, TextBox, ComboBox, Etc.)|
Using Controls in Forms (Command Button, Labels, TextBox, ComboBox, Etc.)
|Section 16: Creating Reports using Wizard|
Creating Reports using Wizard
|Section 17: Working with Report Layout View|
Working with Report Layout View
|Section 18: Using Design view to create simple reports|
Using Design view to create simple reportsPreview
|Section 19: Including Subtotals, Headers and Footers|
Including Subtotals, Headers and Footers
|Section 20: Additional Material|
|Section 21: Exercise|
|Section 22: Course Conclusion|
|Section 23: Mock Test|
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.