Microsoft's advanced database creation and maintenance software. It is very popular among developers who maintain online databases with Windows NT. MS FrontPage - A popular site design and management tool developed by Microsoft. Official Web site. Name server - A server responsible for translating IP addresses and domain names.

Articles for beginners and advanced users of the Microsoft Office Access database. Examples and solutions to implement. Bugs and traps to avoid. Sample code and utilities to download. All free....   Read Article.

GROUP BY: SQL's Organizational Clause - GROUP BY is an invaluable SQL clause for organizing and performing operations on information about several different items you want to aggregate. For instance, what if you wanted to get information about employee attendance in several different time periods to do comparisons...   Read Article.

The DELETE Operand in SQL for MS ACCESS: DELETE is one of the simpler SQL commands, and can be used to delete rows (or records) permanently from a table. It's very useful if you're trying to purge old data from your records. If you want to archive your records, however, you're better off SELECTing...   Read Article.

Mail Merging Microsoft Access Data with a Word Document: We can use Microsoft Access data as the data source for a Microsoft Word Mail Merge document. The Access data can be used in exactly the way needed to create a personalised letter in Word. Often your database is going to be storing specific types of...   Read Article.

Creating Mailing Labels in Microsoft Access: Most of the reports that you will create in Microsoft Access will be used for common data printing requirements. However there are times when entirely different kinds of printouts are required, such as when you need to create mailing labels. Mailing labels are created...   Read Article.

ACCESS USER GROUP NATIONAL SEMINAR: The Access User Group is proud to announce that two of the world's leading exponents of Microsoft Access will be presenting at our national seminar in May. Based in the USA, Luke Chung is the CEO of FMS and recently acclaimed "Access Hero" by Microsoft at the Access...   Read Article.

Creating Microsoft Access Parameter Queries: Most of the queries that you will create in Microsoft Access will have pre entered criteria in the query design grid to select a group of records. This article will show you how to enable the database user to input criteria to be used by the query. A parameter query...   Read Article.

Cancel Printing of a Blank Report in Microsoft Access: As the Microsoft Access database developer, you will probably create many reports for your database users to view and print. Many of these may be fairly complex and have parameters to be entered by the user to generate the report based upon input criteria....   Read Article.

Using Macros to Automate Data Entry: As you will have seen in the previous topic, we can use Macros to Require Data Entry and to inform users of any errors made in the data entry routine. We can also use Microsoft Access Macros to speed up the process of data entry. We can use a macro to remove the need for...   Read Article.

Require Data Entry with a Macro: If you are using a Microsoft Access database application for data entry you will want to ensure the quality of the data that is being entered. Validating data in Microsoft Access allows you to check data whilst it is being entered into the database, and there are various ways...   Read Article.

Types of Macros in Microsoft Access: When working in your database application, often the same tasks may be performed repeatedly. Rather than having your database users perform the same steps each time, you can automate the process with different types of macros in Microsoft Access. Access macros automate...   Read Article.

Microsoft Access Password Recovery Tools and Downloads: Many times, your database will contain information that you do not want to make available to everyone. Requiring a database password can solve this problem. You can protect your information by ensuring that the database user provides a password before...   Read Article.

Logical Operators in Microsoft Access SQL: Originally, logical operators were a concept from algebra used to exclude and include number sets. They are, very simply, NOT, AND, and OR. Sometimes this set is expanded to combinations of the operators, but at core it's only these three. The logical operators...   Read Article.

Convert Microsoft Access to Microsoft SQL Server: Designing a database application requires careful consideration of the business environment's current situation as well as planning for future expansion in either the volume of data to be stored and retrieved, or the number of users accessing the database....   Read Article.

SQL - Multiple Conditions using the AND and OR conditions: In the previous article, Using the WHERE clause with the SQL SELECT Statement, we demonstrated how you would use the SQL WHERE clause to conditionally select data from the database table. The WHERE clause can be simple and use only a single condition...   Read Article.

Using the WHERE clause with the SQL SELECT Statement: You can create more powerful SQL SELECT queries by using the WHERE clause to choose to display only specific rows contained in the database table. The WHERE clause is used to filter the data that the SELECT statement would return in the resultset. We use...   Read Article.

Validating Missing Data by Responding to Data Entry Events: We can use various techniques for validating data being entered into our database, as seen in the Validating Data in Microsoft Access article, however sometimes our validation routines can be overly restrictive. There may be occasions where we need...   Read Article.

Previewing a Microsoft Access report sized using acCmdZoom: When we open a Microsoft Access report in Print Preview we have options available to us about how we would like to see and view the report on the screen. We can use the Zoom options on the Print Preview toolbar to allow us to resize the preview of...   Read Article.

Eliminate Duplicates with SQL SELECT DISTINCT: When you are working with the SQL SELECT statement, you will more than likely come across duplicate rows when viewing your query results. This should cause no real problems, and by using the SQL DISTINCT keyword in your SELECT statement you will be able to remove...   Read Article.

Database Solutions for Microsoft Access - Sample Data Model for Employees and Qualifications: The following data model is designed to hold information relating to Employees and Qualifications that each has achieved. For this scenario we need to define the following facts. These facts define the requirements...   Read Article.