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 3
By Richard Rost   Richard Rost on Twitter Richard Rost on LinkedIn Email Richard Rost   10 years ago

This two-hour long seminar on Microsoft Access SQL picks up where PART 2 left off. You will learn how to manipulate the structure of your databases using simple SQL commands. You'll be able to build and modify tables, queries, indexes, relationships, and much more. These techniques are especially powerful for developers who have to support remote, back-end database files.

1. Learn how to create a modify a Table
2. Discover the different Access SQL Data Types
3. Create Indexes for your tables
4. Connect to external databases using SQL
5. Construct a CONSTRAINT clause
6. Work with table relationships
7. Learn the differences between ANSI-89 and ANSI-92 SQL
8. Set up Referential Integrity between your tables
9. Create stored views and procedures
10. Learn about Access database security via SQL

Click here for more information on the ACCESS SQL SEMINAR, PART 3.

Constraint Check Not Working Upload Images   Link 
Joe Hood 
5 months ago
Going through Lesson 8 Cannot get the following statement to work to add a validation rule to CreditLimit field.

FistName TEXT (20),
LastName TEXT (20),
Richard Rost
5 months ago
Yeah, that should work. I just tried it myself and it doesn't want to work for me either. I'm wondering if there's either a bug in the new versions of Access that nobody has caught yet (doubtful) or Microsoft changed it somehow. Let me do a little research. A quick Google search shows nothing. Unfortunately, this is one of those things I almost never use personally. If I'm going to create a table, I'll use a Recordset. :)
Richard Rost
5 months ago
OK. I think I found the reason. Hang on while I test it. I like to be sure before I explain.
Add a Reply
SQL Server Upload Images   Link 
Kenny Nelson 
6 years ago
I am very interested in the SQL Server class you mentioned.  Can you give an estimated time when that will be ready?

Reply from Alex Hedley:

There's a small snippet on SQL Server in Expert 24. Read More...
Add a Reply
MySQL Form Upload Images   Link 
Kenny Nelson 
6 years ago
I LOVE THE MYSQL FORM!  What a great idea!  I am actually using it to create a VBA code library.  I added a description field to my MySQLT where I can put a key phrase such as Error Handling, and I store my error handling routine in the MySQL field.  Whenever I need some code, I know right where to find it without having to start from scratch!
Add a Reply
Is the create delete tmp table the appropriate way Upload Images   Link 
Tom Dlugosh 
6 years ago
Is the create/delete tmp table the appropriate way to copy records, manipulate some of the fields and copy the revised data back into the original table as new data or is there an easier way?

Reply from Alex Hedley:
Add a Reply
Upload Images   Link 
Zied Ben Afia 
7 years ago
Hi Richard !
is any DAO seminar coming soon?
If yes please let us know when exactly
Add a Reply
Indexes Upload Images   Link 
8 years ago
Thank you Richard for the tip on Composite Keys.  That will do the trick!!

I just have not reviewed all of the Tip videos yet.

Add a Reply
Indexes Upload Images   Link 
Bradley Biles 
8 years ago
Hi Richard,

I know this is probably way past the time from when you created this seminar, but on the topic of Constraints when two fields are involved, my current project will have this situation and will be a required by the Nevada Gaming Commission.  We cannot have to gaming machines that have the same Model Number and the same Serial Number.  This Constraint is perfect for my InventoryT table & entry form to stay in compliance and double check the manufacturer. Read More...
Add a Reply
SQL Server Seminar Upload Images   Link 
8 years ago
Count me in too...
Add a Reply
SQL Server Seminar Upload Images   Link 
Lone Vistoft 
8 years ago
You say in this seminar,  that there will soon be a SQL Server seminar. Are you able to provide information on when this will happen?
Kind regards Lone

Reply from Richard Rost:
Add a Reply
Alter table affects data Upload Images   Link 
Mubeezi Micah 
9 years ago
Dear Richard,

Strange but true!

I just noticed something at Time Index 5:20 in Video 4.
If i write an SQL command to say ALTER TABLE TempT ALTER COLUMN MiddleName CHAR(50).
It alters the table as expected. But it also alters the existing data! Read More...
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.

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/22/2021Buy Access
7/21/202164-Bit Access
7/18/2021Splash Screen

Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Account Login
Online Theater
Lost Password
Student Databases
Change Email
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Customer Support
Web Site Tour
Consulting Services
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Video Tutorials
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Terms of Sale
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