Microsoft Access Tutorials

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?

How to Use the Wizard to Create a Crosstab Query
Crosstab queries make it easier to view records by displaying the information in a compact view similar to a spreadsheet. With the wizard, you just need to answer some questions to create the query. These instructions apply to Access 97.

Prevent a User from Closing your Application
In this MS-Access form tutorial you will learn how to Prevent a User from Closing your Application. (video tutorial)

What is Database?
Before we begin delving into our Microsoft Access tutorials, we need to have a full understanding of what a database is. This site is geared towards people who are just starting out using Microsoft Access, so for some of you with a little more experience, this may seem a little dumbed down, and for that, I apologise in advance. That said, I feel that the first question we need to address is "what exactly is a database".

Use files from other Office programs in your Access forms and reports
Using files from other Office programs The concepts you must understand in order to use files correctly, such as whether to link or embed them, and whether to use bound or unbound files. It also briefly explains OLE (Object Linking and Embedding), the technology that some Access components use to store and display files. Storing files in a database How to add fields to your database tables and either link to or embed file data in those fields. Adding unbound files to forms and reports How to add files that remain fixed as you move through the records in a database or the pages in a report. Adding bound files to forms and reports How to add files that change as you move through the records in a database or the pages in a report. Updating and editing links and files How to update links to your files, display updated files automatically and manually, and edit files in Access. Solving common display problems What to do when you see file names instead of the files themselves, and "Package" in your table fields instead of a specific Office file type.

DFirst Function
The DFirst function returns the first value from a specified set of records (or domain).

Query to retrieve max date in Access 2007
How can I build a query to select the latest date among several records?

VBA how tos
How to add a field to a table. How to assign a primary key to a table, a foreign key to another table and establish a relationship between these two tables. How to back up files from one directory to another. How to compact the current database automatically when it reaches a certain size. How to compare the contents of two directories. How to connect to an Access database with ADO after it has been secured with user-level security. How to connect to an Access database with ADO after it has been secured with shared-level security. How to copy the current record on the form. How to create a desktop shortcut to open a database with a command line parameter. How to create a listing of the Access and Jet errors. How to delete a field from a table in VBA. How to delete a file in VBA. How to delete a table in VBA. How to determine a file's size. How to determine the default file format. How to format a string with varying numbers of leading zeros. How to get individual items passed to another form using OpenArgs. How to get the Error Description from the Error Number. How to hide tables in VBA. How to link to a table located a database that has a database password. How to modify the system warning messages. How to prevent "Invalid use of Null" error when using the DLookup( ) function. How to prevent users from sharing a common front end database file located on a networked server. How to rename a file in VBA. How to programmatically select the first record on the subform. How to set database options using VBA while creating a new database. How to set the macro security level in Access 2003 runtime.

Assign Default Permissions
Assign default permissions for new tables, queries, forms, reports and macros.

MS-Access Live Data in Excel
Here, we will try linking live MS-Access Data in Excel and see that it stays live reflecting changes made in MS-Access. MS-Access will function as the Server Application and MS-Excel will be at the Client side.

Case Statement
In Access, the Case statement can only be used in VBA code. It has the functionality of an IF-THEN-ELSE statement.

Using SQL to Generate SQL Statements
Learn the benefits of generating SQL statements from a query, how to make the output from a query appear in the form of another SQL statement and how to use the data dictionary, database tables, or both to form SQL statements.

Creating Complex Reports
Learn index: how to display the report Design window, how the report Design window relates to other Design windows, what the different sections of a report are, what report properties mean and how you use them, how to design each section of your report, how to group data in your report, how to view your report as you design, how to save your report within your database.

Use speech recognition
You'll save time if you complete dictation first, review your file, and then format text or make corrections. As a result, you'll switch between using Dictation mode and Voice Command mode less often.

Define a custom format for a Date/Time field in a table
I have a table with a date field in it. When I view the table, I'd like to see the date value displayed as "mm/dd/yyyy hh:nn:ss" format. How can I do this?

Data Field Design
As a database is expanding, so are its objects. For example, many of the tables created by the Database Wizard lack some fields that otherwise would not suit a particular scenario. As we learned already, you can add new fields to a table. Since such new fields are not added to the corresponding forms or reports, you have to insert these fields in the appropriate objects. Even though the Form Wizard or the Report Wizard can be used to create quick objects, you still have the option of changing or improving their look by moving fields around and changing the sequence of fields' navigation. Learn: Fields Design Techniques, Form and Report Design Accessories, Forms, Reports, and Data Existing Fields, Forms, Reports, and Queries Fields, Form and Report Design: Controls Insertion, Form and Report Design: Controls Selection, Form and Report Design: Controls Moving, Form and Report Design: Controls and Sections Sizing, Form and Report Design: Controls Deletion, Tab Order, Opening an "Un-Openable" Form.

Add Fields to a Table
Access 2003 can appear to be a very confusing and frustrating program to run, requiring multiple tables and views to use properly. Adding fields will often require you to use both Design View� and Datasheet View.� The following steps will help you to add fields to a table in Access 2003.

Add Controls to a Form in Access 2007
A control in Access 2007 is an object on a form that passes information between the user and the form. Common control types include labels, boxes and buttons. Adding a control to a form is common task and most forms in Access contain many controls. The following steps will show how to add controls to a form in Access 2007.

Install handwriting recognition
This feature is available in the Simplified Chinese, Traditional Chinese, English, Japanese, and Korean language versions of Microsoft Office.

How To Create A Crosstab Query
Crosstab queries are useful for summarizing information, calculating statistics, spotting bad data and looking for trends. The results of a crosstab query are read-only data cannot be added, edited or deleted in a crosstab result. An aggregate function, such as sum or count, is used to help summarize the data.