SQL with Microsoft Access 2016 Lesson 4 - Select query

Channel:
Australia Magic Monk
Subscribers:
65,900
Published on ● Video Link: https://www.youtube.com/watch?v=IFr4jvt_ZZc


Duration: 6:23
157,306 views
921

In this video you learn about the select query - how to select specific rows / columns from a table. We also talk about using different comparison operators, such as larger than / smaller than or equal to.
Download the file below, unzip the files, then import the table to your database.
http://magicmonktutorials.com/access/lesson4.zip



Other Videos By Magic Monk


2016-03-10Queuing lesson 2 - Construct a timeplot
2016-03-10Queuing lesson 1 - Types of queues, definitions
2016-03-09SQL with Microsoft Access 2016 Lesson 12 - Having, Update
2016-03-07SQL with Microsoft Access 2016 Lesson 11 - Joining tables
2016-03-07SQL with Microsoft Access 2016 Lesson 10 - Group By, Max, Min, Average
2016-03-07SQL with Microsoft Access 2016 Lesson 9 - Arithmetical operators, functions
2016-03-07SQL with Microsoft Access 2016 Lesson 8 - Sorting
2016-03-06SQL with Microsoft Access 2016 Lesson 7 - Subqueries
2016-03-06SQL with Microsoft Access 2016 Lesson 6 - In, Between, Brackets
2016-03-06SQL with Microsoft Access 2016 Lesson 5 - AND, OR, LIKE
2016-03-06SQL with Microsoft Access 2016 Lesson 4 - Select query
2016-03-06Samsung Galaxy S5 phone case doesn't fit
2016-03-05SQL with Microsoft Access 2016 lesson 3 - Alter Table
2016-03-05SQL with Microsoft Access 2016 lesson 2 - Inserting records
2016-03-05SQL with Microsoft Access 2016 lesson 1 - Create table
2016-03-04Installing Office We'll be done in just a moment
2016-03-04Automatic configuration of the current version of Microsoft Access has failed
2016-03-04Income lesson 4 - Working overtime
2016-03-03Income lesson 3 - Commission and royalties
2016-03-03Income Lesson 2 - Wages and Allowances
2016-03-03Income Lesson 1 - Salary


Tags:
SQL select query tutorial