473,320 Members | 1,926 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

complete NOOB hope someone can point me in the right direction

I have been programming access databases for 8 years.
Well today I find out that I need to know SQL.
HUH LOL

well I don't have a clue as to how people even enter data into
a sql database or how to manipulate or retrieve data.

Can someone please recommend a book to get me started?

thank you very much for any and all help with this.
Apr 20 '07 #1
2 1332
sparks (js******@swbell.net) writes:
I have been programming access databases for 8 years.
Well today I find out that I need to know SQL.
HUH LOL

well I don't have a clue as to how people even enter data into
a sql database or how to manipulate or retrieve data.

Can someone please recommend a book to get me started?

thank you very much for any and all help with this.
Isn't Access an SQL database? Or since you post in this newsgroup,
you specifically mean SQL Server databases?

SQL Server is a server application that accepts data from clients. Clients
can be implemented in a multitude of ways, both as Windows applications
and web applications. You can write applictions in .Net, in Perl, in VB6,
in Java, in about every language. You can even use Access - this appears
in fact to be a common solution.

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Apr 20 '07 #2
Erland Sommarskog wrote:
Isn't Access an SQL database?
http://en.wikipedia.org/wiki/Microsoft_Access#Features

One of the benefits of Access from a programmer's perspective is its
relative compatibility with SQL (structured query language) —queries may
be viewed and edited as SQL statements, and SQL statements can be used
directly in Macros and VBA Modules to manipulate Access tables. In this
case, "relatively compatible" means that SQL for Access contains many
quirks, and as a result, it has been dubbed "Bill's SQL" by industry
insiders. Users may mix and use both VBA and "Macros" for programming
forms and logic and offers object-oriented possibilities.
Apr 22 '07 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Dave Williams | last post by:
First off...total noob to VB. So far have learned a lot in 1.5 days and feel fairly comfortable at throwing screens up. However, I want to start writing forms that revolve around an access...
8
by: administrata | last post by:
I'm programming Car Salesman Program. It's been "3 days" learning python... But, i got problem Write a Car Salesman program where the user enters the base price of a car. The program should...
4
by: Steve Horsley | last post by:
I am trying to start two threads to do some time consuming work. This is my first stab at threading, and it isn't working as I expect. Instead of the threads starting when I call start(), they seem...
4
by: John Osborne | last post by:
I'm a beginner at this programming thing (C# and VB/VB.Net) but I have been given a task that I don't even knwo how to start to accomplish. I'm not asking anyone to write the code or anything,...
4
by: Mason Barge | last post by:
I'm learning how to build a website. So far I've gotten pretty good with HTML, CSS, and Paint Shop Pro, and I'm currenly learning the basics of Javascript. I'm hoping, eventually, to build and...
4
by: Hexman | last post by:
Code below ---- I've asked a similar question on this forum earlier. This is a slightly different situation. Previous Question ---- I'm trying to save some specific web pages to disk as...
4
by: Buzby | last post by:
I want a drop down date selection box on a form in the format of Mon 18 June 2007, that will go say 400 days in advance from the current date. Can anyone point me in the right direction as I...
17
by: henry | last post by:
Folks Here's a skeleton, generic HTML page, call it "index.php". You'll see a bit of php code in the middle: <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.