Access Fundamentals
Microsoft Access is a powerful database program you can use to store all kinds of information from a simple list of recipes to an inventory catalog with tens of thousands of products. Once information is stored in a Microsoft Access database, it's easy to find, analyze, and print.

---

Reading Access Databases with PHP and PECL
In this article, I'll introduce you to PHP's MDBTools extension, which provides an API to programmatically read data from Microsoft Access database files. If your project involves working with such files, extracting database records either for calculations or for conversion to other formats, you'll find this extension invaluable. Come on in, and see how it works!

---

Using the Recordset with MS Access and ADO
A Connection object may give you access to the database, but that's only half the equation; the Recordset object gives you access to the data. Keep reading to learn more about the Recordset. TOC: Using the Recordset with MS Access and ADO; The Recordset Object, Properties, Methods and events; Write code to Open ADODB connection, Recordset and close open objects; Review recordset properties using code.

---

Connecting To An Access Database Using ASP
If you are reading this page then I shall assume that you already know a little bit about ASP and running ASP applications. To make this tutorial more interesting and the following database tutorials on, Adding, Deleting, and Updating, data from a Microsoft Access database, we are going to use these tutorials to make a simple Guestbook application.

---

Linking SQL Express 2005 Tables to MS Access 2007
This tutorial shows you how to link tables on your SQL 2005 Express server to an MS Access 2007 database. Some of the salient features of the MS Access 2007 program were discussed in an earlier tutorial including a detailed description of the "Ribbon." Reading the earlier article will help you to go through this tutorial with ease.

---

Connecting to an Access Database using C#
This may seem like a common task, and it is, however I found it ridiculously difficult to learn how to do it. The MSDN website has articles on each class involved but nowhere does it explain how to put everything together. After reading this blog you should be able to: -Open a connection to an existing MS Access (.mdb) database. -Perform SELECT queries. -Extract the results from queries. -Modify/Add row of a table. -Update the changes to the Database. -Close the connection. -Figure out for yourself how to do other operations.

---

Catalog Your SQL Scripts with MS Access
Our application development department is frequently asked to run 'ad hoc' queries against the database and deliver the results in an Excel spreadsheet to the end user. It seems that the same requests are made on a regular basis, but often, the SQL used to generate the data is either lost or misplaced. Danny Lesandrini shows how this problem can be reduced or eliminated entirely by defining a realistic and user-friendly naming scheme for saved SQL queries, standardizing query metadata by using a 'Comment Block' template, and creating a utility to search query SQL file names and metadata.

---

Create a MS Access database programmatically in perl
Is there a way I can programmatically create a MS Access database in PERL by reading a text file? Each line in the text file is '|' delimited and represents a record. The top line in the text file contains the field names separated by '|".

---

Opening Excel Database directly
With limited features of Database Functions also built into it with the power of Filter, Sort etc. This is where we step in to introduce a Table in Excel for our new example for Reading/Updating the Excel data from Access. Even though there are facilities in Excel to implement general database rules for creating and maintaining a table it is often not followed. It is left to the user to decide how to create a worksheet and how to create a database when both can go into a single Worksheet side by side.

---

Sort records on text, numeric, or date values
Sorting data can play a big role in making a report or form effective and easy to use. For example, a product catalog that lists the products in alphabetical order or on the basis of unit price is much easier to use than one that lists the items in random order. This topic explains how to sort records when viewing and designing a table, query, form, or report. In this article * Introduction * Sort the records in a view * Remove a sort order * Save a sort order with an object

---

Blueprint for using data in SharePoint Server
By combining Office SharePoint Server 2007, the 2007 Microsoft Office system, and the data in your enterprise, you can create a business solution that will make you feel right at home. In this article * Building a business solution is like building a home * Understanding data foundations -The three types of data -Making connections to data -Using data grids to work with data -Using forms to efficiently change data -Using reports to present data and make decisions -Using dashboards and KPIs to act upon data * Leveraging data within SharePoint Server -SharePoint lists -SharePoint libraries -Web Parts and Web Part Pages -The Business Data Catalog -KPI lists -Workflows -SQL Server Reporting Services -The Report center * Using data from Office system programs with Office SharePoint Server 2007 -Excel and Excel Services -InfoPath -Access -SharePoint Designer -Other Office system programs * Get started with templates and scenarios -SharePoint site templates -SharePoint workflows -Office system templates and scenarios

---

Microsoft Access Viewlets
Using the Blank Database Wizard in Access. Change Properties for Table Fields in Access. Using the Selection Filter in Access. Using the Report Wizard in Access. Creating an Input Mask in Access. Deleting and adding a Table Field in Access. Creating a Relationship Between Two Tables in Access. Sorting a Table Using Multiple Columns in Access. Freezing and Unfreezing Columns in Access. Sorting a Table in Access. Creating a Simple Query in Access. Navigating Through Table Data in Access. Hiding and Unhiding Columns in Access. Building and Applying a Sort Filter in Access. Searching For and Replacing Text in an Access Table. Automatically adding Date and Time to Access form

---

How to Capture your Network Database User's Name
Looking for that extra special effect to give your database project a professional flair. Would you like to display your User's names as they log in to the database? If the answer is yes then carry on reading.........

---

Access Tips
Adding the Database Name to a Report in Access, Automatically Compact and Repair Access Databases, Change the Default Working Folder in Access, Combining Text from Two Fields in Access, Create a Vertical Control in Access, Define a Default Field in an Access Database, Deleting Duplicate Records in Access, Display Tabbed Documents in Access 2007, Displaying Highest or Lowest Values in an Access Query's Results, Import Access Tables into Excel, Insert Time/Date in Excel or Access, Navigation Pane in Access 2007, Number Entries in an Access Report, Report Layout View in Access 2007, Techniques for Creating Forms and Reports in Access, Upgrading to Access 2007, Using Validation Rules to Restrict Data in Microsoft Access

---

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

---

XML for the uninitiated
You may have heard of Extensible Markup Language (XML), and you may have heard many reasons why your organization should use it. But what is XML, exactly? This article explains the basics of XML - what it is and how it works. After reading this article, you should have the tools that you need to converse intelligently with an XML expert, such as someone from your IT department.

---

How to add a Welcome Message for your Database User's
Looking for that extra special effect to give your database project a professional flair. Would you like to add a welcome message for your user's as they log into your database? If the answer is yes then carry on reading...

---

Getting Started with Access
Access provides a powerful yet comfortable environment in which you can manage your information. Using Access, you can tame even the most difficult data-management tasks. This tutorial is the first step in your journey. Here you will learn basic terms, as well as how to start and exit Access. You will also learn how to get help and even catch a glimpse of what you can do with Access.

---

No Access license on this machine - message when I start Access
When you start Access 95 or Access 97, do you see a message about your computer not having an Access license? This could be because Access is not registered properly on your computer. The problem is often caused by installing Access 97 and Access 2000 on the same computer.

---

How to convert an MDE to an MDB
If you have written an MDB database file and you want other users to preform applications with it, then you can convert it into an MDE file. But now you want to convert it it back into an MDB file and you don't want to change any codes. This process is simple, keep reading to find out more.

---

What happened to data access pages?
A data access page is a Web page that is designed to let you view and work with data from the Internet or an intranet. This data is typically stored in an Access database. The ability to create, modify, or import data access pages is no longer supported in Microsoft Office Access 2007. However, you can still use Access 2007 to work with databases that contain data access pages. * Use Access 2007 to work with a database that contains data access pages * Alternatives to data access pages

---

VB6 With Access
Microsoft Access may be the most powerful programming tool available for Visual Basic. While nearly everything Access does can be accomplished with Visual Basic code (there are exceptions), Access makes most design tasks so much simpler that I consider having a copy of Access as much a necessity for database development as a keyboard.

---

Need Access Help
Can anyone help me with 2 questions? I taught myself Microsoft access and can't figure 2 things out... 1. How can I make the startup screen of access be maximized at the beginning? (When I start it up it goes thru the process of a regular access project. I don't want to see the tool bar or anything. I would like the screen to take up the whole area instead.) 2. How can I make it so another users use it if they don't have access on their computer?

---

Getting started with Access 2007
There are several ways that you can get started with Microsoft Office Access 2007, depending on whether you are using Access for the first time, moving data from another database or spreadsheet program into Access, or upgrading from a previous version of Access. This article covers questions that are likely to arise in each of these situations.

---

Delphi 6 and MS Access Reports
This may sound like a weird question but I am wondering whether anyone has been able to trigger an MS Access Report from Delphi 6. I am trying to port an Access "application/database" into Delphi 6 and, while I can replicate (and even improve upon) the Access Forms, The first phase of this task is going to get a lot more complicated if I have to also duplicate the various reports that are already available in the Access database. So, what I would really like to do is to interface the Delphi application to the MS Access database in a manner that would allow me to initiate the existing Access Reports.

---

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

---

MS access 2000
I am currently running xp professional with MS Access 2002. My problem is that I'm currently taking a class in MS Access 2000 and the requirement is that I must use MS Access 2000 not 2002. I don't want to spend big dollars on a a version of Access that's not current so what do I do? Any suggestions would greatly be appreciated.

---

Create an Adobe PDF File From an Access Database
You need to share a Microsoft Access file with others, but not all of them are running Access. Converting it to a PDF file will not only compress it, it will allow those not using Access to view it. The process for doing this depends on the version of Access you use.

---

Creating Forms in Microsoft Access 2007
Although Access provides a convenient spreadsheet-style datasheet view for entering data, it isn't always an appropriate tool for every data entry situation. If you're working with users you don't want to expose to the inner workings of Access, you may choose to use Access forms to create a more user-friendly experience. In this tutorial, we'll walk through the process of creating an Access form. This tutorial walks through the process of creating forms in Access 2007. If you're using an earlier version of Access, read our Access 2003 forms tutorial.

---

Microsoft Access Custom Form Navigation
Customising Microsoft Access forms, adding your own menus and command buttons is part of creating a Microsoft Access database application and designing an Access graphical user interface. Microsoft Access forms can contain the built in Access navigation buttons and record counter, or you may wish to add your own.

---

Access Database Manipulation via JDBC
This will teach you how to connect to a Microsoft Access database. It's also a great overview of JDBC. Once you are connected, you may run any SQL statement that is allowable on Access, such as SELECT, etc. You don't even have to have MS Access installed to run this tutorial - it shows you how to make a blank one without Access!

---

Working with Access Projects in Access 2007
Microsoft Access 2007 features significant differences from earlier versions. One of these is the lack of support for data access pages. Projects become important in this environment. This tutorial will show you how to create an Access project and more. TOC: Working with Access Projects in Access 2007; Creating an MS Access 2007 Project; Creating a Stored Procedure in the Project; Stored Procedure in SQL Server.

---

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.

---

Four Things to Love About Microsoft Access 2007
For many years now, Microsoft Access has been one of the most popular of all desktop database programs. Along with its bigger cousin, Microsoft SQL, Microsoft Access has helped form the core of database development for many small, medium and large businesses, and with the new version, Microsoft Access 2007, on the horizon it is important for workers to learn about the new features and benefits of this new program. Those who have been using Access 2000, Access XP or Access 2003 will recognize much of the interface of Microsoft Access 2007, but there are some notable differences, and a new look as well. It is important for those considering upgrading to the new version to understand the unique features and benefits of the 2007 version of Microsoft Access.

---

Link an Access 2007 database to a database that contains data access pages
A data access page is a Web page that is designed to let you view and work with data from the Internet or an intranet. This data is typically stored in an Access database. The ability to create, modify, or import data access pages is no longer supported in Microsoft Office Access 2007. However, you can still use Access 2007 to work with databases that contain data access pages.

---

MS Access Tutorial - Forms
Access provides an easy way to enter data into your Access tables with forms. In Access you have the ability to quickly make and customize these data entry forms to streamline the data input process. Learning how to properly create an Access form will save you a great deal of time!

---

Add an Item to the Quick Access Toolbar in Microsoft Access
The Quick Access Toolbar provides you with immediate access to commonly used functions in Microsoft Access 2007. In this tutorial, we explore the process of adding your own favorite icons to the Quick Access toolbar, step-by-step.

---

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.

---

Access 2002
Microsoft Access is a relational database package that runs under Windows on microcomputers. This tutorial was prepared using Access 2002. Before using this tutorial, you should know the fundamentals of Microsoft Access and know how to use Windows. This tutorial teaches you some more-advanced Access skills you'll need to do database case studies. The tutorial concludes with a discussion of common Access problems and how to solve them.

---

Create an Access 2007 Form
Although Access provides a convenient spreadsheet-style datasheet view for entering data, it isn't always an appropriate tool for every data entry situation. If you're working with users you don't want to expose to the inner workings of Access, you may choose to use Access forms to create a more user-friendly experience. In this tutorial, we'll walk through the process of creating an Access form.

---