Question about Microsoft SQL Server Standard Edition for PC
Hi I have recently started experimenting queries in Access and I have learned a lot of useful functions that improved my sql abilities. I have an MS Sql Server at work and I have heard that you can make queries using Access, which will make my life a lot easier. Does anyone have information on how to do that?
Access has each own queries wizard enable you to make your own sql statement. for example:
Your table name is Customer
Customer table contains the ff fields:
1.) First Name
2.) Last Name
at the Queries statement: SELECT * FROM Customer
Meaning * stand for fields while Customer stand for table
Try to visit very resourceful website for the beginner's http://www.w3schools.com/sql/default.asp
Hope you will make my solution's helpful for you.
Posted on Nov 02, 2007
Are you familiar with "Linking" tables in Access? In Access: File --> Get External Data --> Link Tables. This will bring up a dialog box which allows you to browse to your SQL server and select the table you want.
Posted on Aug 23, 2007
Tips for a great answer:
Aug 23, 2018 | Online Computers & Internet
on Aug 10, 2010 | Computers & Internet
May 12, 2014 | Microsoft Database Software A5K-02817 SQL...
May 06, 2014 | Microsoft Database Software A5K-02817 SQL...
Jun 22, 2010 | Microsoft SQL Server 2005 Enterprise...
Nov 14, 2007 | Computers & Internet
Aug 30, 2007 | Microsoft SQL Server 2000 Standard Edition...
289 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: