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
A 6ya expert can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
The service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
Tips for a great answer:
May 12, 2014 | Microsoft Database Software A5K-02817 SQL...
on Oct 05, 2010 | Computers & Internet
on Aug 10, 2010 | Computers & Internet
Jul 15, 2013 | Computers & Internet
Oct 19, 2008 | Microsoft MS SQL SERVER (810-01567-3-1)...
Nov 14, 2007 | Computers & Internet
Oct 17, 2017 | Microsoft SQL Server Standard Edition for...
274 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: