Learning SQL: a step by step guide using Access
This book is a brief, hands-on tutorial covering the basics of using SQL, as well as using the Access database engine and SQL. An introduction to beginning SQL tasks is accomplished in this book. A series of exercises at the end of each chapter takes these newly leaned SQL skills and puts them to work. While learning about SQL, readers will also gain insight on how the basics are used by professional Access programmers.
What people are saying - Write a review
We haven't found any reviews in the usual places.
Getting Started with SQL in Access 21
Beginning SQL Commands in Access 33
13 other sections not shown
Other editions - View all
4th St Access SQL ACCT aggregate functions ALTER TABLE attribute Brenda Cartesian product Chapter clause column aliases Computer Science constraint correlated subquery COSC COSC COSC cose count Course table course_number CREATE TABLE data type delete Display Elainie Empl Employee table ENGL equi-join example EXISTS following output following query foreign key gr.grade gr.student_number grade Grade_report table Hillary Hindi inline view INNER JOIN inner query INSERT Jake Joe Smith Lujack Mala Sinha MATH middle query NOT..IN null values number of rows outer join outer query POLITICS OF CUBA POLY primary key produces the following referential integrity relational database result set rows of output s.class s.stno salary SELECT sname shown in Figure Smith SQL function SQL in Access SQL query SQL view stno string student names student numbers Student table student_number student.mdb Sumon Bagui synonym table alias table called temporary table Third Normal Form tuple type the following UNION