Microsoft Access Tutorials
Learn the basics of Access so you can start using this popular database program right away. You'll learn how to work with Access' most useful features to design databases, maintain them, search for valuable nuggets of information, and build attractive forms for quick-and-easy data entry.
Load Excel into MySQL
This page describes how to load Excel XLS Worksheets into MySQL via Microsoft Access, the easy way. You can use this same technique to load data quickly into any ODBC data source.
Function Library: IsError(), IsNull() and IsNumeric()
We've added information and examples of three new functions to our Microsoft Access Function Library.
Using the DoCmd Object in Microsoft Access
The DoCmd object is one of many objects that is offered by the Access environment. Its parent is the Application object. One of the common uses of the DoCmd object is with Macros. The DoCmd object is used to run Microsoft actions. One of the first ones that we will be looking at is running Form operations with the object .
Using Text Files with Microsoft Access
Microsoft Access through VBA makes it easy for us to interact with the system files. In this article we will explore how to manipulate text files through Microsoft Access. To use files with Access we will have to use the file system object or FSO.
Exporting a table
Postgres is the well known and most used Open Source OLTP database available today which is claimed to be as good as or even better than MySQL. EnterpriseDB is Postgres packaged differently to provide enterprise capabilities to Postgres users.
Microsoft Access Mailing Lists and Form Letters
In this tutorial, we examine the process of creating mailing labels using Microsoft Access using the built-in Label Wizard. We begin with a database containing the address data and walk you step-by-step through the process of creating and printing your mailing labels.
Mailing Lists in Microsoft Access
In this tutorial, we examine the process of creating mailing labels using Microsoft Access using the built-in Label Wizard. We begin with a database containing the address data and walk you step-by-step through the process of creating and printing your mailing labels.
Access to Word mailmerge, record IDs appearing instead of record labels
I have 2 tables in an MS Access database. One table (table01) contains a list of items while the other table (table02) contains other data with 1-6 of these items (from table01) associated with them. There is a relationship between these two tables. In Access, regardless of the form, report or query, everything is OK. However, when I use MS Word to do a mailmerge, everything is OK except the items from table01 appear as the ID numbers instead of the contents of the fields. Any suggestions on how to have the contents of the fields appear instead of the ID numbers?
Joining 3 tables (using left joins) in Access 2003
How do you link 3 tables together, where table 1 is linked on one field to table 2, and the table 3 is linked to table 2 on another field?
Suppress system messages (Query confirmations)
How can I suppress the system messages when I run queries? For example, when a delete query is run, Access will ask you to confirm the number of deletions. How can I suppress these kinds of messages?
How to Remove the Primary Key
Remove the primary key only if you're sure you won't need relationships between the tables in your database. Remember, you can only run queries on tables that have been joined in a relationship. These instructions are for Access 97.
Create and use speech recognition user profiles
Speech recognition user profiles store information about how to recognize your voice. You can create profiles for multiple users on the same computer. You can also create additional profiles for yourself when working in environments with different levels of noise or using different microphones.
How to Use the Wizard to Create a Simple Data-Entry
A form provides an interface for entering data into a database. Forms can be easier to use than Datasheet view, especially if others are typing in your data. You can create a simple form with the wizard in seconds. These instructions are for Access 97.
Microsoft Access or Something Else?, I don't know which to use...
I'm a web tech, but my boss asked me to build what he calls a "database" for him. So basically I need a customer database and I have NO CLUE what I'm doing... I'm just tinkering with all kinds of programs and completely lost. What program am I supposed to be using to build this database... I have microsoft access, but I couldn't figure it out. I downloaded Python and pHpMyAdmin, although now that I have, I don't know why.... Could some one please give me a sense of direction??? Just let me know what I need to use, and where I can learn to use it!
Printing Your Table
Many computer users don't give much thought to what happens after they get their information in a database. Very often, getting information into a database is only half the story-you also need to worry about printing out information so you can share your data with others.
In this tutorial, you will learn how you print the information contained in your database. You will learn concepts that apply whether you are printing a simple table or a complex report. However, this tutorial is only the start.
Set the value of a textbox based on the value of another textbox
What VBA code do I use to set the value of a textbox based on the value of another textbox?