Description
Curriculum
Instructor
Ultimate Microsoft Access Training – Create & Maintain Access Tables, Access Queries!!
Topics covered in this course:
- Tour of the Access screen
- Using Design view to create a table
- The Lookup Wizard
- Importing tables from other data sources
- Linking tables to other data sources
- Exporting data from Access into other data types
- Creating table relationships
- Database tools
- Sorting and Filtering a table
- Calculated field queries
- Using Multiple tables in a query
- Viewing the SQL code
- Query wizards
- Append, Make Table, Update, and Delete queries
Some exceptional benefits associated with this course enrolment are:
- Quality course material on MS
- Lifetime access to the course
- Instant & free course updates
- Access to all Questions & Answers initiated by other students as well
- Personalized support from the instructor’s end on any issue related to the course
- Few free lectures for a quick overview
It’s time for you to grab the opportunity and make the most out of this course.
Enroll today!!
Curriculum
- 1 Section
- 20 Lessons
- 3 Hours
Expand all sectionsCollapse all sections
- Access Tables & Queries20
- 2.1Access Tables and Queries – 1 – Tour of the screen11 Minutes
- 2.2Access Tables and Queries – 2 – Using Design view to create and edit tables45 Minutes
- 2.3Access Tables and Queries – 3 – Using the lookup wizard9 Minutes
- 2.4Access Tables and Queries – 4 – Importing data from Other Data Sources into Access18 Minutes
- 2.5Access Tables and Queries – 5 – Linking Tables from Other data Sources into Access10 Minutes
- 2.6Access Tables and Queries – 6 – Exporting data from Access to other data types3 Minutes
- 2.7Access Tables and Queries – 7 – Creating and Managing Table Relationships10 Minutes
- 2.8Access Tables and Queries – 8 – Database Tools4 Minutes
- 2.9Access Tables and Queries – 9 – Sort and Filter a Table5 Minutes
- 2.10Access Tables and Queries – 10 – Basic Queries22 Minutes
- 2.11Access Tables and Queries – 11 – Prompting the user for the criteria4 Minutes
- 2.12Access Tables and Queries – 12 – Creating Calculated Fields in a Query10 Minutes
- 2.13Access Tables and Queries – 13 -Creating Totals Queries8 Minutes
- 2.14Access Tables and Queries – 14 – Multiple table Queries12 Minutes
- 2.15Access Tables and Queries – 15 – Viewing the SQL code for an Access Query6 Minutes
- 2.16Access Tables and Queries – 16 – Using the Query Wizards9 Minutes
- 2.17Access Tables and Queries – 17 – Creating Subqueries3 Minutes
- 2.18Access Tables and Queries – 18 – Creating Make Table, Append, Update and Delete Queries19 Minutes
- 2.19Access Tables and Queries – 19 – Displaying a certain number of records2 Minutes
- 2.20Exercise Materials2 Minutes
Tom Fragale
0 Students14 Courses
I am a Microsoft Certified Trainer with over 35 years of professional IT experience, and my passion is teaching people how to get the most out of their computer.
Courses you might be interested in
The ability to study each potential buyer and respond immediately and appropriately to their verbal and physical cues. In this course, you” go through the history of psychology in...
-
15 Lessons
₹449.00
Discover The Hidden Secrets Of Beating Anxiety! On Completion of this course, you’ll be able to: Discover How To Banish Worry & Live An Anxiety Free Life! Learn How...
-
10 Lessons
₹599.00
Secrets They NEVER Taught You In School Or Life! On Completion of this course, you’ll be: Talking In A Way That Your Children Will Listen & Change! Knowing The...
-
13 Lessons
₹599.00
Using the Power of Social Media to Attract a Crowd of Loyal Customers. On Completion of this course, you’ll be: In no longer need to “run an ad” and...
-
39 Lessons
₹449.00