This Tutorial
- Using SQL to create a Microsoft Access database
- Using SQL to access Microsoft Access databases
- Using SQL to describe Microsoft Access database tables
Related Pages
Microsoft Access Workgroup tutorial
Microsoft Access Database Splitter tutorial
Microsoft Access Build Your Own Database manual
- SQL tutorial for MySQL
- SQL tutorial for SQL Server
SQL database comparisons
- Comparison of the commands and operators used in WHERE clauses in Oracle, Microsoft Access, MySQL and SQL Server, and how to limit the number of rows returned
- Comparison of useful functions in Oracle, MySQL, Microsoft Access and SQL Server
Useful links
Microsoft Access
ASP Free site
has a series of articles for beginners. Novices should start with the
"Getting to Know ... " articles..
Alan Browne's tips
contains tutorials suitable for all levels of expertise from casual users to Access developers.
Microsoft:
This link will take you to the Microsoft Access Developer Center, from which you can find code samples, tutorials and tips.
MySQL
Download the
MySQL database from the MySQL AB site.
Knowledge base
articles and user manual
are also available from the MySQL AB site..
The
PHP MySQL Tutorial site covers the basic procedures for new PHP-MySQL programmers.
Home > Database Development >
Describing Microsoft Access
Database Tables
Structured Query Language (SQL) tutorial
Describing Microsoft Access Database Tables
Describing tables
You can find information about tables’ data structure from the table’s Design View in Microsoft Access.
What’s next?
In this chapter, you have learnt the basics of database and table creation using SQL. Following from this, you will discover how to add data to tables, and to extract information from this data.