MS Access Table and Queries Series 1
4.8 (5 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
37 students enrolled

MS Access Table and Queries Series 1

Know Tables and Queries
4.8 (5 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
37 students enrolled
Created by ajay parmar
Last updated 2/2019
English
English [Auto-generated]
Current price: $13.99 Original price: $19.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 9.5 hours on-demand video
  • 1 article
  • 9 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • You will be able to store the information in access tables
  • you will know the tables and different types of queries as well. Basically this course will easy your work when you deal with millions of rows.
  • Complex information can be retrieved using select queries and data can be manages very well using action queries like update,append,delete, cross tab etc.
Requirements
  • This session is for beginers so nothing really is required. Basic knowledge of Excel will help you in dealing with ms access easily however not mandatory.
Description
  • This course is talking about MS ACCESS TABLES and QUERIES in detail. Program is for those students who want to learn ms access and take their knowledge to new heights.

  • What are the Tables- Their use, how to design them.

  • Why we use the Tables- Import and Export the data from external sources like text file, excel file, csv files and other sources like ms access itself.

  • Use of saving import and export steps 

  • Validation and rules concept while designing the Tables - in depth discussion

  • Select query with so many different examples including the SQL statement of same

  • Update - Delete- Append- cross tab- Make Table - update - drop query - all action and select queries are discussed with examples

  • Use of operators like in , not in, <>, wild characters (*,?) , between,> ,< signs

  • How to use query wizard to find out unmatched records or duplicate records .

  • How to use Group option in queries.

  • Use of Sub- queries.

  • Project discussion in the end so that what we have learn can be easily understood .How it works in real life.

  • I am available for any type of query or doubt if you have. All the best.

Who this course is for:
  • Students who want to learn MS Access - one of the powerful databases Microsoft had produced ever.
Course content
Expand 12 lectures 09:16:29
+ Introduction to ACCESS Tables and Queries
12 lectures 09:16:28
Introduction to TABLES Import Export
01:16:04
Introduction to TABLES Appending
51:49
Introduction to TABLES Formatting and Validations
57:32
Introduction to Select Query
01:31:19
Introduction to Delete Query
53:04
Introduction to Append Query
46:47
Introduction to Make table and Update Query
45:32
Cross Tab query and Useful Query Wizard
38:32
Group Feature and Union ,Union All and DROP Query
01:01:59

one of the best query when it comes to giving the control to user in getting the output by putting different different inputs is the parameter query. We are educating ourselves on parameter query and also using it in the project.

Preview 26:16

Dear Student, you may have a look at my other wonderful series as well.

Preview 00:55