Create an Adobe PDF File From an Access Database
Adobe Acrobat (.PDF) offers a great method of sharing data across the Internet while preserving formatting. It's simple to generate these files from an Access database.

---

Create an Adobe PDF File From an Access 2007 Database
Backing up your Microsoft Access databases is an important part of protecting your critical data. In this tutorial, we walk through the process of backing up an Access database, step-by-step.

---

Create PDF from MS Access Report
On a machine where the Adobe PDFWriter is installed, the current printer is swapped out with the PDFWriter and the PDF file is created. The original printer is then restored.

---

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)

---

MS Access Database
MS Access uses a simple, file based database and does not need any database server to be installed on client machine. Each database is stored as a single file. The extension of the MS Access database file is .MDB. All tables within the database are stored within teh same database file.

---

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).

---

INTRODUCTION TO THE ACCESS DATABASE
In this tutorial you will learn about databases in general and about the Access database in particular. The concept of a database is not as easy to grasp as that of a word processor or a spreadsheet. So if this is the first time you are learning about databases you would be well advised to read over the lesson first, away from the computer, and perhaps highlight the text to ease understanding. (pdf file format)

---

Save a file in PDF format
Portable Document Format (PDF) format ensures your printed or viewed file retains the formatting that you intended, and that data in the file cannot easily be changed. The PDF format is also useful if you intend to use commercial printing methods.

---

How to Import Shapefiles into Microsoft Access
How to Import Shapefiles into Microsoft Access. This tutorial demonstrates how to import an ESRI shapefile into an Access database using the... (PDF file, install Acrobat Reader to read this file)

---

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

---

Microsoft Access Tutorial
Microsoft Access is a powerful program to create and manage your databases. Below shows the Hierarchy that Microsoft Access uses in breaking down a database. (pdf file, install Acrobat Reader to read this tutorial).

---

Importing and linking
There are a number of different ways to create and populate a table: -Create the table definition from scratch and then populate the table manually with data values; -Create the table definition from scratch and then append data from some other electronic format to the table; -Import the table definition and data from another database or application (such as MICROSOFT EXCEL or a text file); -Create a link to an external data source. In this case, the data is not actually stored in your database file, but is accessible from within ACCESS like any other table. (pdf file, install Acrobat Reader to read this tutorial)

---

Access 2003: Creating Switchboards
Learn how to create a switchboard so that when editors open the database they go right to the form screen. (pdf file, install Acrobat Reader to read this tutorial)

---

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)

---

Microsoft Access GUI Building
Microsoft Access provides the tools for developing graphical user interfaces that facilitate the use of database applications. An Access GUI consists of a set of Forms. Forms are nice front ends for accessing the data that is stored in database tables or that is generated by queries. (pdf file, install Acrobat Reader to read this tutorial).

---

Access 2003: Understanding Databases
This is a short reference to the basic functions of Access software and understanding the parts of a database. (pdf file, install Acrobat Reader to read this tutorial)

---

Basic Skills and Tools Using Access
1. Describe the primary functions using Microsoft Access. 2. Describe the steps for creating a new database file using Microsoft Access. 3. Describe the steps for creating and modifying a table and fields using Microsoft Access. 4. Describe the steps for creating relationships between tables using Microsoft Access. (pdf file).

---

Microsoft Access Tutorials
These tutorials are in Adobe Acrobat PDF format. You can download them individually or as a set. To view the files, you need the Acrobat Reader, which Adobe provides at no charge.

---

Change the default file format
When you create a new, blank database in Microsoft Office Access 2007, you are prompted to provide a name for the database file. By default, the file is given the ".accdb" extension - it is created in the Office Access 2007 format and is not readable by earlier versions of Access. In some cases, you may prefer to create files in an earlier Access format. In Office Access 2007, you have the option of creating files in either the Access 2000 format or the Access 2002-2003 format (both with the extension ".mdb"). Then, when you create a new database file, the resulting file is created in the earlier Access format and can be shared with others who use that version of Access. This can be helpful if you have upgraded to Office Access 2007 but you share files with others who have not.

---

Converting a Microsoft Access Database to an MDE File
The situation may arise 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 you will need to allow the users to process their data as normal. It may be that you haven't got the time to fully create Microsoft Access User Accounts or to set Microsoft Access Security Permissions. By knowing what can and cannot be done by using the Microsoft Access MDE file format, will allow you to make a decision and to quickly release a secure database to the users.

---

Using Microsoft Access without Microsoft Access
How to Work with Microsoft Access even if it's not Installed. Microsoft Access is a very powerful database - so powerful that that a VBScript programmer doesn't even need to install it in order to use it. One of the exciting aspects of using Microsoft Access on a Windows XP or Vista computer is that Microsoft Access doesn't even have to be installed for it to be used. All that the computer user needs is a text editor and some VBScript code. By using VBScript the would be database designer can: * create a new database file (a .mdb file) * add tables to the database * update the contents of the database * run queries on the database The great thing is that they will not need to have any additional software in order to do all of this.

---

Connecting to Microsoft Access with ADO
Readers of this tutorial will learn how to make a Universal Data Link file which provides the basis for connecting to an MS Access database file. They will also go through the steps to be followed in writing VBA code to work with the database in accessing the Connection object. TOC: Connecting to Microsoft Access with ADO; Overview of ActiveX Data Objects; Create a UDL file to connect to an MDB file; Read the connection string from the file; Create a reference to ADO; Write code to open and close the ADODB connection to the database.

---

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

---

Access 2003: Basic Workshop
Learn how to create a complete new basic database following this step-by-step guide. (pdf file, install Acrobat Reader to read this tutorial)

---

Microsoft Access XP
Tables, Query, Forms, Reports, Backing up a database, Creating a Mail Merge (pdf file format, install Acrobat Reader to read this tutorial).

---

Convert an Access 2007 database to an earlier file format
If you created a database in the Microsoft Office Access 2007 (.accdb) file format, but you want to share the database with people who are using earlier versions of Access, in most cases, you can convert the database to an earlier file format by using the Save As command. This article provides the steps for converting a database to an earlier file format and discusses some of the factors that prevent you from converting a database. In this article: * Convert an Access 2007 database to an earlier file format * Factors that prevent conversion to an earlier file format

---

Access 2003: Queries
Learn how to run queries and use criteria to help you pull data from your database. (pdf file, install Acrobat Reader to read this tutorial)

---

Introductory Exercises
This tutorial contains a series of exercises which give an introduction to the Access relational database program. (pdf file, install Acrobat Reader to read it).

---

Access more tutorials (pdf)
Access is a database program that allows you to create, sort and retrieve information data quickly and easily. With Access you can generate database objects such as tables, forms, queries, and reports, which make it the proper software to deal with large collections of information for teaching and research.

---

Self Help Documents: Microsoft Access
Topics: understand and create database, import and export data, sort and filter tables, insert graphics, queries, reports, forms, advance table design view, understand relationship and learn how to connect through an ODBC to make tables that you can manipulate in Access. (Download all these tutorial in pdf file format).

---

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

---

An introduction Microsoft Access
MICROSOFT ACCESS is a relational database management system (DBMS). At the most basic level, a DBMS is a program that facilitates the storage and retrieval of structured information on a computer's hard drive. (pdf file, install Acrobat Reader to read this tutorial)

---

Convert a database to the Access 2007 file format
You can convert a database that was created by using Microsoft Office Access 2003, Access 2002, Access 2000, or Access 97 to the new Microsoft Office Access 2007 file format. You should use the new file format whenever possible because it supports new features, such as multivalued fields and attachments. However, a database in the new Access 2007 file format (.accdb) cannot be opened or linked to with earlier versions of Access, and the new format no longer supports replication or user-level security. If you need to use your Access 2007 database with earlier versions of Access, or if you need to use replication or user-level security, you must use a file format from an earlier version.

---

HTML Help with MS Access (pdf file)
Access 97 was released about the same time as HTML Help, so there is zero support for this particular help system from Access 97. For example, you won't be able to use the help functionality of the MsgBox function with HTML Help as it only works with WinHelp. The way to fix this particular problem is to use Sonke Huckfeldt's techniques for creating custom MsgBox and InputBox functions. These techniques can be found in a sample database which is available from the same page you retrieved this article from.

---

File Management
Each table, query, form, and report is a database object that you can copy, rename, create a description of, and set properties for. You can create database objects by importing them from another Access database. You can create tables in Access by importing them from or linking them to another data source. You can import as well as export files. To keep your database in good shape, you need to work with several procedures. Backing up your data is the most important of these operations; however, compacting the database and repairing will be necessary at times. If you are on a network with multiple users, you may want to explore replication to decrease network traffic while still updating your databases. With multiple users, you also need to consider security--that is, who should and who should not have access to the database file and the objects inside.

---

Print, share, and protect files in the PDF and XPS file formats
Often you want to save your files so they cannot be modified, but you want them to be easy to share and print. Examples include resumes, legal documents, newsletters, and files intended to be read and printed. PDF and XPS formats can help. What do you want to do? * Learn about PDF and XPS file formats * Install and use the Save as PDF or XPS add-in from Microsoft * Install a third-party solution

---

Make changes to a PDF file
Portable Document Format (PDF) is a common format for sharing final versions of documents. Most PDF files are similar to read-only; they can be read but not changed.

---

Converting an Access Database to ACCDE File Format
If you have created a Microsoft Access database application that you will be distributing, you will want to convert it to a format that will prevent users from copying or modifying the database’s functionality. This article will deal with how we can convert an Access database to an ACCDE file. Situations may arise where you need to quickly and securely distribute an Access database that also contains VBA code. While allowing the database to provide all the necessary functions, you also want to prevent users from viewing and modifying code or altering the design of forms and reports. Converting your database to an ACCDE file will help you to lock the code and disallow design modifications.

---

Microsoft Access File Format
The newest version of Microsoft Access marks the introduction of a new file format which uses the file extension of .accdb. In addition to this new format, however, Microsoft Access 2007 continues to provide support for many of the file formats used in earlier versions of the database program. Even so, it is recommended that users of Access 2007 use the new .accdb file format whenever possible, in order to take advantage of the many new features and benefits it provides. The new .accdb file format includes a number of new product enhancements and features. When a new database is created using Access 2007, the file is saved as an .accdb file by default. This new file format should be used whenever possible since the format supports a number of new features and benefits, including multiple value fields and the addition of attachments in various formats.

---

Create a Report Snapshot in Microsoft Access
Microsoft Access is a popular database program. If you want to send an information file from an Access database and you know the recipient doesn't own Access, you still can send the file with a report snapshot. Report snapshot is a portable viewer that the client can use to open the file and view its contents.

---