Preparing Your Access 2003 Database for Deployment, Part 1
While planning and creating your Access application, there are decisions to make and additional options to consider when preparing for deployment. This is part one of a two-part series designed to help you prepare your database application for release.

---

Getting to Know MS Access 2003, Part 2
Last week you looked at the Microsoft Access 2003 interface and help functions. This week you'll learn what a relational database is and how to create your first database. Table of Contents: Getting to Know MS Access 2003, Part 2; Data Distribution; Relationships; Designing Your First Database; Creating Your First Database.

---

Managing Your Household Inventory Using Microsoft Access 2003
This is the third of a three-part series of workshops that serve as a general introduction to Microsoft's Access 2003 database program. In Part III we learn how to create a database to manage your household inventory. It is advised that you create a list and take digital photos of the household items you want to document. This class is designed for adults with some computer experience, but little or no previous database experience.

---

Demo: Expose your Access database structure
Have you ever struggled to understand how the components in a database relate to each other? Microsoft Office Access 2003 puts the answers right before your eyes with a new tool called the Object Dependencies task pane. This task pane makes clear the relationships among the forms, tables, queries, and other objects in a database. Now, you can update or troubleshoot a database without having to spend hours learning its structure. No more worrying about whether you'll break one part of your database if you make changes somewhere else. Access 2003 shows you what you need to know.

---

Maintaining Your Address Book Using Microsoft Access 2003
This is the second of a three-part series of workshops that serve as a general introduction to Microsoft's Access 2003 database program. In this tutorial, we will learn how to create a database to manage your personal or business address book. These classes are designed for adults with some computer experience, but little or no previous database experience.

---

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.

---

Splitting a Microsoft Access Database
One of the important decisions that must be made before a Microsoft Access Database can be distributed is the form that the database will assume after the deployment. In this article, it addresses the pros and cons of splitting the database, and implementing the Database Splitter to create a front and back end database.

---

Introducing Microsoft Office Access 2003
Microsoft Office Access 2003 is the database management program that gives you an improved user experience and an expanded ability to import, export, and work with XML data files. Working in Access 2003 is easier because common errors are identified and flagged for you with options to correct them. Additionally, a new feature to Access 2003 also helps database developers view information on dependencies between database objects. Learn: Extending databases, Importing, exporting, and linking data, Protecting information and Enhancing the user experience.

---

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.

---

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.

---

Adding Programs to Access 2007 Deployment Packages
Learn how to add an add-in to a Microsoft Office Access 2007 deployment package created by using the Package Solution Wizard. The Package Solution Wizard makes it easy to create a deployment package that contains your application, the Microsoft Office Access 2007 Runtime, and additional files. However, the Package Solution Wizard does not support deploying additional programs with your application. This article describes how to modify a deployment package that you created by using the Package Solution Wizard to deploy an additional program when the user installs your application. To demonstrate this, you will add the Microsoft Save as PDF or XPS Add-in for 2007 Microsoft Office system programs to an existing deployment package created by using the Package Solution Wizard.

---

Deploy an Access 2007 application
This article discusses basic deployment planning, the features of the Access 2007 Runtime, and how to download the Runtime. This article also provides an overview of deploying database applications by using Access 2007. For more information about planning, designing, and deploying an Access 2007 application, search the MSDN Web site and the Technet Web site, and see the links in the See Also section of this article. What do you want to do? * Plan for deployment * Understand the Access 2007 Runtime * Download the Access 2007 Runtime * Deploy an Access 2007 application

---

Import an Access 2.0 database into an Access 2007 file
If you use an existing database in the Access 2.0 format (.mdb), you can import tables, queries, and macros from that database into a Microsoft Office Access 2007 database (.accdb). To import forms, reports, or modules into Office Access 2007, you must first convert the database by using an earlier version of Access, open the database in Access 2007, and then convert the database into the Access 2007 database format. The following sections in this article explain how to perform each of these tasks. What do you want to do? * Open an Access 2.0 database in Access 2007 * Import data from an Access 2.0 database * Convert an Access 2.0 database by using Access 2003, Access 2002, or Access 2000

---

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.

---

Import an Access 95 database into an Access 2007 file
If you use an existing database in the Access 95 format (.mdb), you can import tables, queries, and macros from that database into a Microsoft Office Access 2007 database (.accdb). You can also import forms and reports that do not employ Microsoft Visual Basic for Applications (VBA) code. To import forms and reports that contain VBA code (and also modules), first convert your Access 95 database to the Access 2002 - 2003 or Access 2000 file format by using Microsoft Office Access 2003, Access 2002, or Access 2000, and then use Access 2007 to convert that file to the Access 2007 file format. What do you want to do? * Import data from an Access 95 database * Convert an Access 95 database by using Access 2003, Access 2002, or Access 2000

---

Access database (Office Pro 2000) Can't use it with Office 2003
I used to use the software suite Office Professional 2000, which included Microsoft Access. My computer crashed, and I decided when I was rebuilding everything to put Office 2003 Student and Teacher Edition on it, which does not include Microsoft Access. I have a database that I use frequently and now I can't use it at all. I thought that a way to fix this and be able to use the database I would just reinstall Office 2000 Pro and choose to just install Access. I thought I could use Access 2000, and for the rest of the office suite programs I could just use the 2003 version. Wrong! Even though I installed Office 2000 on an external hard drive, my system wants to use the old version of all the Office programs. I know this sounds convoluted, but hope I've explained my problem well enough. I want to use Microsoft Office 2003 Student and Teacher Edition, and because it does not contain Access, I want to have a standalone Access program. Is this even possible? And if so, how do I do it. Just so you know, I did try to do a customized install of 2000, but it installed all the programs anyway. Hope you can help me. If there's no way to use Access in this configuration, what database would you recommend, and is there one that I can export my Access database to, since it has over 500 records and I don't want to have to reenter all that data?

---

Get started with Access 2003
There are different ways you can get started with Microsoft Office Access 2003, depending on your experience level. 1)Upgrading from previous versions of Microsoft Access. 2)Already familiar with other database or spreadsheet applications. 3)Using a database for the first time.

---

Migrating to Access 2003
Access 2003 lets you create and use powerful database management solutions that make organizing, accessing and sharing information easier than ever before. Use Access 2003 to better collaborate with Microsoft Windows SharePoint Services sites, take advantage of enhanced XML support, add smart tags to forms and reports, easily discover object dependencies, and more.

---

Getting to Know Microsoft Access 2003, Part 4
In this lesson we'll cover some basic but important concepts: entering data, working with data, navigation, making data entry more efficient, and changing the appearance of your tables' datasheet views. TOC: Getting to Know Microsoft Access 2003, Part 4; Navigation; Lookup Fields; Changing Datasheet Appearances.

---

MS Access 2003 (pdf file format)
MS Access 2003. Access is a database program that allows you to store your data.

---

Preparing To Upgrade Access Tables to SQL Server 2005/2008
This article discusses some of the subtleties that you can apply to your database tables prior to upsizing your tables to SQL Server. In this article, I will show you how to fix up some of your Access backend before you make the conversion. I do this because once you are in an environment where you have Access as a front-end and a SQL Server back-end, things are going to get more complicated. Another good thing about this article is that it will probably improve your database model and reduce the size of your database at the same time.

---

Set or change Access 2003 user-level security in Access 2007
If you created a database in a previous version of Access and you applied user-level security to that database, those security settings remain in place when you open that file in Microsoft Office Access 2007. In addition, you can start the security tools provided by Microsoft Office Access 2003 - the User-Level Security Wizard and the various user and group permission dialog boxes - from Office Access 2007. This article explains how the Access 2003 security features work, and it explains how to start and use them in Access 2007.

---

How to Create a New Database From Scratch
Microsoft Access 2003 is a great program for making and managing databases of all kinds. You can create new databases manually or by using the Database Wizard feature. If you don't want to use the Database Wizard, here's how to create a new database from scratch in Access 2003.

---

Center a form in the application screen in Access 2003/XP/2000/97
Question: In Access 2003/XP/2000/97, I've created a database with a form in it. When I open the form, it's off to one side and part of the form does not show in the application window. How do I center on a form in the application screen so that all of the form is displayed?

---

Access 2003: Creating Labels
Learn how to create labels by using the information in your Access database This document offers some tips on understanding and creating relationships in Access 2003. (pdf file, install Acrobat Reader to read this tutorial)

---

Getting to Know Microsoft Access, Part 10
In the tenth and final part of our series on getting to know Microsoft Access 2003, you will learn how to create charts and graphs, improve the performance of your databases, and more. TOC: Improving Performance; Exchanging Data with Others; Sharing your Data with Others.

---

MS Access Append Query For MS Access 2000, 2002, 2003
This is a basic Append Query tutorial. For the most part all versions of MS Access, from 97 to 2007, the query builder appears the same. There will be some small differences throughout all versions. This tutorial will be dealing with MS Access 2000-2003.

---

Introduction to Microsoft Access 2003
Our goal is to assist you to learn the software, understand some basic concepts and show you some tips and techniques so you can develop your database management skills over time. The five workshops are: Introduction to Access; Access Queries; Access Reports; Access Database Design; Access Form Design. (pdf file, install to Acrobat Reader to read this tutorial).

---

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:

---

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.

---

How to Determine Which Query to Use
Choosing the right query to use in Access 2003 can save you loads of time. Microsoft Access can seem tricky and complicated, but using queries effectively can make Access 2003 seem a lot simpler. These are the steps to take to determine which query to use in Access 2003.

---

Find and replace part or all of a record in an Access table, query, or form
This topic explains how to use the Find and Replace dialog box, select queries, and update queries to locate and optionally replace records in a Microsoft Office Access 2003 database. This topic also explains how to find and optionally remove or replace wildcard characters that reside in your data. In addition, this topic briefly explains some of the techniques you can use for learning the structure of an Access database. Searching a database can be a complex process because the data can reside in any number of tables. If you know the structure of a database - the types of data each table contains, which tables have one-to-one and one-to-many relationships, and so on - data can be much easier to find. Finally, this topic provides a reference that explains how to use the wildcard characters that Access provides, and a troubleshooting section that explains how to solve common problems with find and find-and-replace operations.

---

You must install the Microsoft Access 2.0 Converter in order to convert this file
When you open a file in Access 2.0 file format in Access 2003, you are prompted to install the Access 2.0 Converter. This issue occurs because you have to install additional files that are not installed by Access 2003 to open or to convert an Access 2.0 database file.

---

Access 2003: Creating a New Database
Learn how to create a new database using the built in templates. Also, start a blank database and learn how to use table wizards to help build your database. (pdf file, install Acrobat Reader to read this tutorial)

---

Whats New In Access 2003
If you're upgrading from either Access 2000 or Access 2002 to Access 2003, you're in luckin most respects, Access 2003 looks and works almost the same as both Access 2000 and Access 2002.

---

Open the database exclusively
In Access 2003/XP/2000/97, I tried modifying some of the objects in my Access database and I received an error message stating that I needed to open the database exclusively. What does this mean and how do I open a database exclusively?

---

Restrict the Data in a Field
In a Microsoft Access 2003 table or database, you can restrict the data in a field to certain values. Controlling the types of data that someone can enter into a field prevents bookkeeping errors and incorrect database entries. Take these steps to restrict data in a field to certain values in Access 2003.

---

MS Access as a Documentation Tool: Display Object Dependencies
In this article, we will examine a feature that is new in MS Office Access 2003, and which offers great potential in our documentation, maintenance, and general upkeep efforts, from the perspective of the organizations MS Access databases. In MS Office Access 2003, we can directly and easily view information on dependencies between database objects. The capability to view a list of a database's objects, particularly within the context of how those objects relate to each other, can help us to maintain a database over time. The capability is perhaps most useful in helping us to avoid errors that emerge with the uninformed removal of record sources or other databases objects, but numerous other potential uses exist, as well.

---

Basics for Building Microsoft Office Access 2003 Runtime-Based Solutions
How to use the Microsoft Office Access 2003 Runtime with the Microsoft Access 2003 Developer Extensions so users without Microsoft Access 2003 installed can still use Access-based applications. If you are creating an application that runs in an Access Runtime environment, you must carefully consider how to provide an interface for the user. You must also consider the fact that some users may own the correct version of Access and run the application in a full Access environment. Take care to test your application under both environments to make sure it properly balances usability in the Access Runtime environment with code security in a full Access environment.

---

Importing XML into MS Access 2003
MS Access has been around for a long time, and over time it has added support for importing and exporting its data into HTML when HTML was king. When the extensive use of XML appeared on the landscape, MS Access added importing and exporting features to its arsenal. According to product documentation, MS Access 2003 fully supports importing and exporting XML. TOC: Importing XML into MS Access 2003; Importing the file into MS Access 2003; Importing the same file into Excel 2003; One more time.

---