2006-06-28 05:18:14 · 3 answers · asked by M V 1 in Computers & Internet ➔ Software
The SQL used by MS Access by default is called TransactSQL (sometimes shortened to t-SQL)
SQL is an ANSI (American National Standards Institute) standard computer language for accessing and manipulating database systems. SQL statements are used to retrieve and update data in a database. SQL works with database programs like MS Access, DB2, Informix, MS SQL Server, Oracle, Sybase, etc.
Unfortunately, there are many different versions of the SQL language, but to be in compliance with the ANSI standard, they must support the same major keywords in a similar manner (such as SELECT, UPDATE, DELETE, INSERT, WHERE, and others).
Note: Most of the SQL database programs also have their own proprietary extensions in addition to the SQL standard!
2006-06-28 05:31:16 · answer #1 · answered by jdbolton5 2 · 0⤊ 0⤋
Microsoft SQL Server...usually with VBA.
2006-06-28 05:21:38 · answer #2 · answered by Kaia 7 · 0⤊ 0⤋
i think SQL, i did that in uni, can be easy, but can be really hard. loads of money in that field although its boring.
2006-06-28 05:22:08 · answer #3 · answered by shamz 3 · 0⤊ 0⤋