What is Microsoft Access?

Microsoft Access is part of Microsoft Office. It is a competent database system for personal use
and small workgroups of as many as 25 users. Access also works adequately as a database backend
for low traffic database-driven web sites.
If you have Microsoft Access 97 or higher, you can enter SQL commands directly in Access.
Copy lyric2k.mdb (Access 2000 or higher) or lyric97.mdb (Access 97) from the CD-ROM. You
may need to un-check the file’s read-only property. Launch it in Access, and convert it if necessary.
Then do the following:

Access 97                                                       Access 2000+
❍ Click on Queries                                         ❍ Click on Queries
❍ Click on New                                             ❍ Double-click on “Create query in Design view”
❍ Click on Design View and OK                    ❍ In the Show Tables dialog, click Close
❍ In the Show Tables dialog, click Close         ❍ Click on the SQL button in the toolbar
❍ Click on the SQL button in the toolbar


Data description commands:
❍ In Access you do not use SQL commands to view the tables and table information. To view
the tables, go to the Tables tab of the database window. To view the information on any
table, highlight that table and click on the Design button.

What Does SQL Do?

SQL Server and its use

what is microsoft sql and its importance

SQL Standard

The History of SQL

What is SQL?