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.

Using an Update Query to Convert Text to Proper Case: Occasionally you will want to work with text of a particular case, and the text that has been entered into the database table may not be the text that you want to use. If the text has been entered incorrectly to begin with, this may reflect when you are...   Read Article.

Using a Microsoft Access Combo Box to Search for a Record: In the previous article, we looked at Creating Event Procedures in Microsoft Access. The article described how we would use the AfterUpdate event procedure of an Access Combo Box control. Here we detail how to create and use the VBA code that will...   Read Article.

Creating Event Procedures in Microsoft Access: If you need to automate an action from a single event of a control then you can write all of the necessary VBA code as an event procedure that is attached to the event property of that particular control. A procedure contains a series of Visual Basic statements...   Read Article.

Validating Data in Microsoft Access: Validating data in Microsoft Access allows you to check data whilst it is being entered by the database user and will enable you to not save the data if it breaks any validation rules or routines. It is easy for an end user to make a mistake when they are entering data...   Read Article.

Creating Union Queries: Microsoft Access allows you to create various query types using the QBE (Query By Example) pane. There are also various other queries that you can create in Microsoft Access, however you will need to create these by typing in the appropriate SQL (Structured Query Language) directly...   Read Article.

Aggregate Functions in SQL and Microsoft Access: With SQL there are many functions available that allow you to perform or manipulate calculations on your data. These functions can be used as part of the SQL SELECT statement. Aggregate functions allow you to perform calculations on multiple rows of data, but...   Read Article.

Converting a Microsoft Access Database to an MDE File: The situation may arrise when you quickly need to secure and distribute a Microsoft Access database that also contains Microsoft Access VBA code. You will protect the database from editing by restricting the database users access to the design views, however...   Read Article.

Microsoft Access Query Types: Select, Action, Parameter and Aggregate: Queries are very useful tools when it comes to databases and they are often called by the user through a form. They can be used to search for and grab data from one or more of your tables, perform certain actions on the database and even...   Read Article.

Replacing a Standard Microsoft Access Error Message with a Custom Error Message: When creating Microsoft Access Forms for your database application, there are many times when you may come across error messages when user interaction takes place. Some of the error messages in Microsoft Access may appear completely...   Read Article.

Auto Numbering In Microsoft Access: What is it and when should it be used? Auto numbering is a handy little feature that will search out the next consecutive or random number for you, and as the name suggests, it does it automatically. It then adds that number into the field where the data type is set to 'AutoNumber'....   Read Article.

Validate A Forms Textbox To Ensure Only Text Is Entered: Whilst entering data into textboxes via your Microsoft Access forms, you may need to validate certain data against that which is acceptable. When setting the data types of your database fields one of the data types available is the Text type. As the...   Read Article.

What Are Macros and Why Would You Use Them? Macros are basically Microsoft Access' way of telling the application what it needs to do. It's essentially a small program (or a piece of script) that can tell the application a whole range of things it can do and how to go about doing them. They can sometimes...   Read Article.

Resetting a Microsoft Access 2003 AutoNumber: In previous articles, we have shown examples of How to Reset the Microsoft Access AutoNumber in Microsoft Access 97, 2000 and Microsoft Access XP (2002). We have also dealt with Using an Append Query to Set the Initial Value of an AutoNumber Field. In the latest...   Read Article.

How to create a macro that will link tables to external databases: There are times when information needed is contained in other Access databases. For example, there may be one database that contains customer service information while another database contains customer finance information. The administrator...   Read Article.

The Microsoft Jet Database Engine - Database Solutions for Microsoft Access: Jet is the Database Management System (DBMS) which underlies MS Access and also Visual Basic, as well as MS Word and MS Excel. The Jet engine (Joint Engine Technology) was developed by Microsoft in the early 1990's as an answer...   Read Article.

Turning Good Data into Good Information: Good information really is the holy grail for decision-makers at all levels, but particularly those at the higher levels of management. Distance from the cash-generating processes of an organisation is unfortunately directly proportional to the importance of decisions...   Read Article.

How to Create a Microsoft Access Macro to Import Information from a Text (.txt) File: Macros are operations used in Microsoft Access in order to automate functions in databases. They can be used to open reports, run queries, update the databases and import from various file formats such as Excel (.xls), database,...   Read Article.

Confirm Changes using the Before Update Event - Database Solutions for Microsoft Access: When creating the user interface in Microsoft Access, the database designer should always be looking at ways to simplify the data entry process, prevent bad data from getting into the database or ask for confirmation when...   Read Article.

Creating a new table using an Excel file - Database Solutions for Microsoft Access: As I became familiar with Access, I was very pleased to know that you could import existing information to use in Access. This saved retyping and editing time. In most cases, it is easier to use Access to store, retrieve, manipulate,...   Read Article.

How to create a Microsoft Access Append query with criteria: A Microsoft Access append query can be used to add records to an existing database table. Prior to creating an append query, decide upon the two Microsoft Access tables that you would like to use. One table will contain the records you would like...   Read Article.