posted at 01/26/11 - 04:52 PM

Intermediate SQL is now available!

To enroll in Intermediate SQL, click the "Enroll in my Low Cost SQL Courses" link above.

Next, scroll to the bottom and click "Intermediate SQL".

Cecelia

posted at 11/11/10 - 10:34 AM

Intermediate SQL is now available!

To enroll in Intermediate SQL, click the "Enroll in my Low Cost SQL Courses" link above.

Next, scroll to the bottom and click "Intermediate SQL".

Cecelia

posted at 11/03/10 - 08:54 PM

Intermediate SQL is now available!

To enroll in Intermediate SQL, click the "Enroll in my Low Cost SQL Courses" link above.

Next, scroll to the bottom and click "Intermediate SQL".

Cecelia

posted at 10/20/10 - 10:21 AM

Hello Readers

I am excited to share the news of the release of Intermediate SQL.

Intermediate SQL will be released on Tuesday, October 26th, 2010.

To register for the course, simply click the "Take my Low Cost SQL Course" link above.

Next click the "Computers and Technology" link.

Finally, click the “Database Management” link to view the "Intermediate SQL" course.

I look forward to seeing many of my former students from Introduction to SQL.

Happy querying!

Cecelia

posted at 10/24/09 - 02:28 AM

On October 17th 2009 I attended my first book signing at Barnes and Noble in St. Petersburg, Florida. The signing featured local authors in the Tampa Bay area of Florida. There were a total of five authors in attendance. I was fortunate to get to know Rudy Rudisill who published a marriage enrichment book, Robert Emery who published a novel (In The Realm of Eden), Richard and Diana Daffner who published a relationship book and Kim Costello who published a children’s book. My book entitled SQL for Microsoft Access 2nd edition represented the computer field.

I had such a wonderful time at the signing. I met lots of interesting people and reconnected with many old friends and family.

I am especially grateful to my publisher Jones and Bartlett who put me in contact with Lindsay Ruggiero the Associate Marketing Manager at Jones and Bartlett. Lindsay Ruggiero went out of her way to ensure that I was prepared for the signing.

I’d also like to thank Barnes and Noble and Ann Dosen the Community Relations Manager at Barnes and Noble for inviting me to this book signing.

I am looking forward to my next Book Signing!

posted at 09/15/09 - 04:41 PM

Hello Readers

If you will be in the Tampa Bay area of Florida around October 17, 2009, I would love to meet you in person.

I will be doing a book signing for "SQL for Microsoft Access 2nd edition" Saturday, October 17th 3:00pm- 5:00pm at Barnes and Noble located at 2501 Tyrone Blvd. N. St Petersburg, FL 33710.

Contact Ann Dosen, Community Relations Manager, for details at 727-384-5200

Cecelia

posted at 09/15/09 - 04:37 PM

Hello Readers

If you will be in the Tampa Bay area of Florida around October 17, 2009, I would love to meet you in person.

I will be doing a book signing for "SQL for Microsoft Access 2nd edition" Saturday, October 17th 3:00pm- 5:00pm at Barnes and Noble located at 2501 Tyrone Blvd. N. St Petersburg, FL 33710.

Contact Ann Dosen, Community Relations Manager, for details at 727-384-5200

Cecelia

posted at 09/15/09 - 04:29 PM

Many who use SQL wonder how to find the interface within Microsoft Access that executes SQL script.

Following are instructions on how to locate this interface (SQL: View): in Microsoft Access 2007

1. After launching Microsoft Access, either select "more" to open an existing database or click "Blank Database" to create a New database. If you are creating a new database, type a name (any name is fine) for your database in the “File Name” box. Next, click the “Create” button.

Note: If you are selecting an existing database (i.e the downloaded course database), browse (locate where you saved the database on your computer) for the database after you click "more".

2. Once Access opens, Click “Create” from the menu running across the top of the screen.

3. Next, Click the “Query Design” button.

4. You'll see a “Show Table” dialog box. Click close on this dialog box without selecting any tables.

5. Select the “SQL View” or “SQL” button near the top left of the screen.

6. Use the "SQL View" or “SQL” button to select “SQL View”. (Click the down arrow located on this button to locate “SQL View”).

7. Type your SQL commands in this view (SQL View).

To run a command, click the "Run" button.