Learn Access Tables and Queries
Learn how to create and maintain tables and queries in Microsoft Access
Office Productivity,Microsoft,Microsoft Access
Lectures -3
Duration -1.5 hours
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
Course Description
Microsoft Access is the database management system that is included with the Microsoft Office Suite or Office 365. It is a program that helps you manage a large amount of data even better than Microsoft Excel can. Many People don’t know how to use Access, and may even be afraid of it. This webinar will really show you the ins and outs of using Microsoft Access Tables and Queries.
Even though Excel gives you some great ways to handle your data, with Access you will be able to handle large amounts of data. If you handle large amounts of data, this webinar will help you tremendously.
Topics:
- 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
- Basic Queries
- Prompting the user for the criteria
- Calculated field queries
- Totals query
- Using Multiple tables in a query
- Viewing the SQL code
- Query wizards
- Subqueries
- Append, Make Table, Update, and Delete queries
- Showing a certain number of records in a query
Goals
What will you learn in this course:
- Learn Access Tables
- Learn Access Queries
Curriculum
Check out the detailed breakdown of what’s inside the course
Full Course
2 Lectures
- Preview 01:03 01:03
- Full Course 01:57:09 01:57:09
Instructor Details
Thomas Fragale
Microsoft Certified TrainerCourse Certificate
Use your certificate to make a career change or to advance in your current career.
Our students work
with the Best
Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe nowOnline Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now