Access 2007-2019
Access 2000-2003
Access Seminars
TechHelp Support
Tips & Tricks
Access Forum
Course Index
Topic Glossary
Insider Circle
 
Home   Courses   Seminars   Templates   Help   TechHelp   Forums   Contact   Join   Order   Logon  
 
 
Access SQL Seminar Part 1
By Richard Rost   Richard Rost on Twitter Richard Rost on LinkedIn Email Richard Rost   10 years ago

This seminar will teach you the basics of the SQL programming language. You will learn how to construct SELECT queries, filter and sort your results, and use basic SQL commands and operators.

This seminar was developed to teach you how to use the SQL language to enhance your Access databases. As I create more and more advanced Access seminars, I see that it's VITAL for my students to have a firm grasp of the SQL language. Knowing just a little bit of SQL can help you tremendously. You can use SQL to enhance your forms and reports. You can create dynamic SQL statements to change list and combo box data on the fly. Plus, you can reduce the clutter in your database by getting rid of "saved" queries.

This seminar has several goals. You will:

1. Learn about SQL and what it is
2. Discover why you should learn to program in SQL
3. Create basic SQL SELECT statements
4. Learn the FROM, WHERE, and ORDER BY clauses
5. Use the SQL operators and keywords such as AND, OR, and IS NULL
6. Work with the LIKE command and wildcard characters
7. Learn the IN, DISTINCT, DISTINCTROW, and other commands
8. Build a list box with a dynamic SQL sort
7. Create a form with a dynamic SQL RowSource

Access SQL 1 lesson 2 time index 12min Upload Images   Link 
Eric Michalek 
4 years ago
Access SQL 1, lesson 2, time index 12min, narration starts with that semi colon at the end and then video will not let me go past that spot.  Is it my computer connection or is there a glitch? Read More...
Add a Reply
If one has a long SELECT statement with a number o Upload Images   Link 
Richard Wilson 
5 years ago
If one has a long SELECT statement with a number of fields in it, does the use of "DISTINCT" at the outset make it the functional equivalent of DISTINCTROW?  If so, how does one use DISTINCT when there is a long select clause.  In my situation, I have a query that makes a"FullName" and it is at the first of the SELECT clause which also has address information lots of other stuff.  I only want DISTINCT to apply to FullName.  I tried and it doesn't.  How should I fix it?  I note the SELECT clauses in the video all just contain one field. Read More...
Add a Reply
Phone list Upload Images   Link 
Anonymous 
5 years ago
How do you handle a phone list if you have a separate but related table for PhoneT and related to another TypeT which includes such things as "office," "home," "cell," "fax" etc?


Reply from Alex Hedley: Read More...
Add a Reply
Recordsets Upload Images   Link 
Mohamed Salim 
5 years ago
Hello Mr Richard.
I've learned Access from scratch, thanks to you. I was wondering if I can do with SQL the same thing with ADO Recordset function. I really want to focus on one thing and master it rather than distract myself with different options. So is having a full understanding of SQL is enough to have a full control on my recordset?, or I should also know about Recordsets option?? Read More...
Add a Reply
vba Upload Images   Link 
Robert Maddox 
6 years ago
Issue Need Advice-
I can run the simple VBA of Customer List Form (#6) on my Windows 8.1Pro + Acces MSO 365, however when I try & run same on my Windows 7 Pro +Access 2007 Laptop it will not run. Any suggestions as to the issue? Read More...
Add a Reply
Questions Upload Images   Link 
Anonymous 
6 years ago
Hi Richard, just 2 quick questions: 1)For the LIKE keyword, why would you not put '' around the [FirstLetter] Parameter piece, when you concatenate it with '*'? 2)Why does the * and # symbols from Access use the same symbol (!) in other SQL servers? Thank you very much for your help. Read More...
Add a Reply
Few questions Upload Images   Link 
Joe Beniacar 
6 years ago
Hi Richard, I have a few questions about this lesson: 1)Is a CrossTab Query like a Pivot Table (in Excel)? 2)If you had multiple Tables in your query, would you have to specify the "TABLE.fieldname" in the WHERE condition too? 3)For Operator Precedence, why doesn't NOT evaluate before AND/OR? - Isn't it kind of like a Comparison Operator, in that it also applies to just 1 field - while AND/OR applies across multiple conditions to multiple fields at the end? Thank you very much for your help. Read More...
Add a Reply
Multiple Tables Upload Images   Link 
Joe Beniacar 
6 years ago
Hi Richard, if you have multiple Tables and want to select the "*" from one of them, would you say: SELECT Table.* ?


Reply from Alex Hedley:

Indeed, you can choose the Fields by putting their Table name in front. Read More...
Add a Reply
Listbox Query Upload Images   Link 
Tom Dlugosh 
6 years ago
I created a customer form and added a list box to show the customer representatives associated with that customer. Works great! I then added a list box to show the ship to addresses associated with the same customer. It doesn't work! The Ship to addresses show up in different customers, sometimes the one with a customer ID 1 digit higher, sometimes 2 digits higher and occasionally anywhere in the ship to table. The SELECT statements are located in the list box properties and are identical in their format. What am I missing here? Read More...
Add a Reply
List Box Column Width Upload Images   Link 
Grant R 
7 years ago
I noticed that my column widths were a little too small after I made my CustomerListF. Is there a way to get back in to edit the column widths? I've tried poking around with little success.
Add a Reply

Show Older Comments...
View in Table Format

Start a NEW Conversation
 
Only students may post right now. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.
 
Subscribe
 

You may want to read these articles from the 599CD News:

7/27/2021Quick Queries #5
7/27/2021Loop Thru Fields in Table
7/26/2021First Monday
7/25/2021Missing Months
7/24/2021Center Vertically
7/23/2021DCount
7/22/2021Buy Access
7/21/202164-Bit Access
7/20/2021Relationships
7/18/2021Splash Screen
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Account Login
Online Theater
Downloads
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Email Richard
Mailing Address
Phone Number
Fax Number
Course Survey
Blog RSS Feed    Twitter

YouTube Channel    LinkedIn
Keywords: access sql structured query language  Page Tag: whatsnew  PermaLink