Query Joins - Inner & Outer Joins
You will often need to join tables in a Microsoft Access query where you need to view information from two or more separate database tables. For this you will need to use query joins to accomplish the task. When you run a database query to find data in related tables, by default Microsoft Access will look for records that have a matching value on both sides of the relationship. Whilst this is what you may want to do most of the time, by knowing how to use the different types of query joins, you can control which records will be displayed as the output. This enables you to again find the exact data that you want - not more and not less.

---

Join tables and queries
When you include multiple tables in a query, you use joins to help you get the results you are looking for. A join helps a query return only the records from each table you want to see, based on how those tables are related to other tables in the query. This article provides conceptual information about joins, discusses the various types of joins, and shows you how to use them.

---

Getting to Know Access 2003, Part 3
After a brief hiatus, our series explaining the ins and outs of using Microsoft Access 2003 continues. This installment takes you from creating tables to hold data to enforcing referential integrity on those tables. TOC: Getting to Know Access 2003, Part 3; Creating a New Table Without the Wizard; Set the Properties for Your Field; The Primary Key; Relationships.

---

Introduction to Microsoft Access 2003
This tutorial is designed for users who are new or only have little experience using Access 2003. It introduces fundamental database concepts and operations and illustrates how they are performed in Microsoft Access 2003. This tutorial does not cover all of the features and functions of Microsoft Access 2003, emphasis will be on basic and frequently-used features, such as the creation of tables and queries, or importing spreadsheet into Access.

---

Create a query using a Left Join in Access 2003
I want to join 2 tables together. But I need to retrieve information even if there is no related information in the second table. How can I do this?

---

Joining Tables
One of the most powerful features of SQL is its capability to gather and manipulate data from across several tables. Without this feature you would have to store all the data elements necessary for each application in one table. Without common tables you would need to store the same data in several tables. Imagine having to redesign, rebuild, and repopulate your tables and databases every time your user needed a query with a new piece of information. The JOIN statement of SQL enables you to design smaller, more specific tables that are easier to maintain than larger tables.

---

Define the Correct Join Type Between Tables
You can specify join types between tables or fields in Microsoft Access 2003 to expand or narrow the results of your search. For example, choosing a full join expands the results to include records that match and do not match the join condition. By defining the join type between Microsoft Access tables, you can stipulate which records a query uses for its action. The join line shows Access how tables are related. Here are some steps to help you define the correct join type between tables in Access 2003.

---

Left align a field in a report
In an Access 2003/XP/2000/97 report, how can I ensure that my field values are left aligned?

---

How to: Perform Joins Using Access SQL
In a relational database system like Access, you often need to extract information from more than one table at a time. Learn how to use Access SQL to perform joins.

---

Multiple Table Queries
Most of the queries you create in Microsoft Access will more that likely need to include the data from more than one table and you will have to join the tables in the query. The capability to join tables is the power of the relational database. As you know, in order to join database tables, they must have a field in common. The fields on which you join tables must be the same or compatible data types and they must contain the same kind of data, however they do not have to have the same field name (although they probably will). Occasionally, the two database tables that you want to bring the data from may not have a field in common and you will have to add another table to the query with the sole purpose of joining the tables.

---

Hide tables as system tables
I've created an Access 2003/XP/2000/97 database and flagged all of the tables as hidden objects. The users have figured out how to display these hidden tables. Is there any way that I can keep my tables from being displayed in the database window?

---

Create an Update Action Query
Microsoft Access 2003 lets you create an append action query to merge tables at the end of one or more existing tables. Appending tables saves you the effort of retyping data. Follow these steps to create an append action query in Access 2003.

---

Self Joins
How to query a Microsoft Access database table that joins to itself. The example is a pedigree going back 4 generations, where all animals are entered in the one table.

---

A Guide To First Normal Form (1NF)
The goal of normal forms is to remove redundant data from relational database tables by splitting the tables into smaller tables without losing any of the data. It is necessary that the decomposition is lossless, meaning that you can simply come back to the base table by combining the newly created tables with joins.

---

Getting to Know MS Access 2003
This article introduces features in MS Access such as the Getting Started screen, shows you the sample database that comes with Access, and defines the different "objects" that are available such as reports, modules and macros. Let's begin the tutorial with an overview of Access 2003. It helps to have the program installed on your computer before following the tutorial. TOC: Getting to Know MS Access 2003; Open a File, Explore the Sample Database; Objects: Tables, Queries, Forms and More; Using Help.

---

Tables Tutorial
Pretty much in all versions, from Access 97 to 2003, the process is just about the same. Tutorials for MS Access 2007 may come at a later date because of some visual differences. Once you have a new Table in Access 2007 then you should be able to follow along. For those most part this article will be dealing with 2000-2003.

---

Access 2003: Understanding Tables
Tables are a key feature in Access, this document will help you better understand them. (pdf file, install Acrobat Reader to read this tutorial)

---

Access 2003: Sorting and Filtering Tables
Learn how to sort and filter the data within your Access tables. (pdf file, install Acrobat Reader to read this tutorial)

---

Access 2003: Tables
Take a tutorial on the basics of Access tables. (Audio and Video)

---

Searching For Text Anywhere In a Database
Thanks to internet search engines, users are used to searching for text but unfortunately even the desktop search tools from Microsoft and Google do not have a search that looks into tables (easily). This article outlines a simple tool to search tables or linked tables to find if a text string(s) exists in those tables. It does this by building SQL queries after analyzing the system tables in any Access/Jet database. This code is suited to Access 2000, XP, 2003 and 2007.

---

Diagramming a Relationship
In the previous lesson, we saw how to establish a relationship between two tables. We also saw that the fields that relate both tables must be of the same data type. To make it possible to visually perform data entry on a table, we learned to create a lookup field. Indeed, this is based on Microsoft Access' high level of support for visual database development. In reality, the only important requirement is that the primary key and the foreign key be of the same data type. In most database scenarios and implementation, the primary key and the foreign key should integer based. As discussed in the previous lesson, the relationship is typically managed through the long integer data. TOC: Diagramming a Relationship, A Sub-Datasheet, Referential Integrity, The One-To-Many Relationship, The Many-to-Many Relationship, The One-to-One Relationship, Inner Joins, Outer Joins.

---

Data Joins
When studying relationships, we reviewed techniques of making data from one table available to the records of another table. This proved to reduce data duplication and mistakes. Another issue that involves the combination of tables consists of creating records from more than one table and making the result into a single list. This is the basis of data joins.

---

Implementing the Equivalent of a FULL OUTER JOIN in Microsoft Access
There are many different kinds of joins, like INNER JOIN, LEFT OUTER JOIN, RIGHT OUTER JOIN, and FULL OUTER JOIN. The first three of these different join types are implemented in Access, but FULL OUTER JOIN is not. If you need to perform a FULL OUTER JOIN in Access, are you "up a creek, without a paddle"? No, you are not. This article will show you how you can write some SQL code in Access to implement a simulated FULL OUTER JOIN.

---

Add a One-to-Many Database Relationship
You can use Microsoft Access 2003 to search for and share data across multiple tables. For example, suppose you are a potter and you want to keep track of your business operations. You could create one table to keep records of your pottery designs and a second table to store records of the galleries that display your work. By creating a relationship between the two tables, you could run a query that would show where each of your items is currently being displayed. Here are some steps to add a one-to-many database relationship in Access 2003.

---

Create an Append Action Query
You can use Microsoft Access 2003 to create an append action query. This is helpful if you wish to add tables to the end of one or more separate tables. This will save the time and the effort of retyping data. In order to do this, you will have to follow a few simple steps to create an Append Action Query in Access 2003.

---

Define a Many-to-Many Relationship
In Microsoft Access 2003, a many-to-many relationship is an association between two tables in which a record in either table can relate to many records in the other table. To make that relationship, you add a third table and add the primary key fields from the other two tables to this table. Here are some steps on how to define a many-to-many relationship in Access 2003.

---

Table that data
Use Microsoft Access to design well-structured tables that meet your organization's data needs and are easy to maintain. After completing this course you will be able to: 1) Plan the best table structure for your data. 2) Create tables using three different methods. 3) Assign data types and properties. 4) Set up relationships between tables. (Microsoft Office Access 2003)

---

Left Function
In Access, the Left function extracts a substring from a string, starting from the left-most character.

---

Access Topics: Reports
Report Basics (Understanding and creating reports) in Access 2003/XP/2000/97, Display reports in the Navigation Pane, Border on a report page, Dynamically size report object, Hide report object if no value, Suppress blank lines, Create a report title that repeats on every page, Display a subtotal for each category within a report, Left align a field in a report in Access 2003/XP/2000/97.

---

Microsoft Access 2003 (comprehenisve)
A complete tutorial on Access 2003. It includes 12 units which includes reports, forms, action queries, crosstab queries, summary queries, relationships, creating and modification of data tables, and more.

---

Access 2003: Advanced Tables Design View
Learn advanced table features using Design View in Access 2003. (pdf file, install Acrobat Reader to read this tutorial)

---

Working with Tables in Microsoft Access 2003
In this section, you'll learn how to: Modify tables, Create new tables, Specify data types, Specify field properties, Edit records, Find records, Sort and filter records, Create table relationships.

---

Excel to Access Converter Utility program
This utility program allows you to convert an Excel spreadsheet file which contains 'flat-file' data into one or more tables in an Access database. The program creates primary and foreign keys in the tables so that 'One to Many' or even 'Many to Many' related tables can be created automatically. You just import the Excel file into the program, create a template which tells the program which columns in the spreadsheet should be copied to which fields in which tables, click a button and the program will extract the data into a series of separate tables which can then be exported to a new database via .csv files. The program can also be used to create properly 'normalised' tables from data in MS Works or any other database by first exporting the data to an Excel spreadsheet (or .csv file which can then be imported into Excel). Full instructions are included. Version. This version runs under Access 2003 (not tried it on Access 2007).

---

Delete Fields From a Table
Access 2003 can appear daunting when attempting to change or work with database fields and tables. By following this easy tutorial you will be able to delete fields from a table in Access 2003.

---

Use Cascading Updates or Cascading Deletes
If you have defined relationships between tables in an Access 2003 database, you can use cascading updates or cascading deletes to propagate changes across all the tables with that relationship. Once you have the cascade enabled, changes that you make to the primary table are carried through to all related tables.

---

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.

---

Microsoft Access In Pictures
In this section, you'll learn how to: Create a new database, tables, records, forms, queries and reports in MS Access 2003

---

Associate an mdw security file with a database
In Access 2003/XP/2000/97, I've secured a database with an mdw file. I want to associate the Access database with the mdw file without "joining" the mdw file in the Workgroup Administrator. How do I do this?

---

Microsoft Access 2003 In Pictures
This tutorial helps beginners learn the basics of creating and using databases with Microsoft Access 2003. BEGIN THE TUTORIAL: ACCESS 2003 >> Need a quick reminder of how to do something with Access? Click a task:

---

Format the contents of a PivotTable view to read right to left or left to right
When you select right-to-left display, the elements of the PivotTable view are displayed as a mirror image of the default left-to-right display. For example, the drop areas are on the upper-right side of the view, row fields are in the rightmost columns, and items in column fields are listed from right to left.

---