Tutorialspoint

#May Motivation Use code MAY10 for extra 10% off

Learn Access Tables and Queries

person icon Thomas Fragale

3.9

Learn Access Tables and Queries

Learn how to create and maintain tables and queries in Microsoft Access

updated on icon Updated on May, 2024

language icon Language - English

person icon Thomas Fragale

English [CC]

category icon Office Productivity,Microsoft,Microsoft Access

Lectures -3

Duration -1.5 hours

3.9

price-loader

30-days Money-Back Guarantee

Training 5 or more people ?

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
Learn Access Tables and Queries

Curriculum

Check out the detailed breakdown of what’s inside the course

Full Course
2 Lectures
  • play icon Preview 01:03 01:03
  • play icon Full Course 01:57:09 01:57:09

Instructor Details

Thomas Fragale

Thomas Fragale


Course Certificate

Use your certificate to make a career change or to advance in your current career.

sample Tutorialspoint certificate

Our students work
with the Best

Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
Annual Membership

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
Online Certifications

Talk to us

1800-202-0515