www.aspfree.com Tutorials

Financial Calculation Software, a Snap with MS Excel
There is more to Microsoft Excel than simple math. It has more than 50 functions that can be set up, in effect allowing you to do a certain degree of programming. This article explains how to create and use a financial calculator in Excel, and discusses some of those functions. TOC: Financial Calculation Software, a Snap with MS Excel; Calculating the payment on a loan; Usage of function PMT; A simple spread sheet to calculate PMT.

Exploring Access 2007
Microsoft Office 2007 has grown from what used to be a group of Microsoft programs into an Office System.

Upgrading your Access Application for a Multi-user Environment
MS Access is not an industrial-strength database like Oracle or DB2 nor does it pretend to be. It is best suited for desktop applications. However, it is often the case that an existing application needs to be upgraded for a multi-user environment. Depending on circumstances, it is not always necessary to implement a true client/server RDBMS. If demands are fairly modest, Access can function satisfactorily in a multi-user environment. This article will deal with the issues that arise when upgrading an Access-based application and will take you through the major steps necessary to upgrade your desktop Access database application for a multi-user environment. TOC: Upgrading your Access Application for a Multi-user Environment; Connection Object; Recordset Object; Security; Performance Improvements.

An Access Front-End to MySQL
Using ODBC, Access can connect with a MySQL database. A proprietary front-end to an open-source database? Microsoft and MySQL? Irreconcilable differences would seem to condemn such a union to a rapid divorce. Read on to see how, despite expectations to the contrary, this marriage can work. Why do it? TOC: An Access Front-End to MySQL; Preliminary Steps; Limitations; State of the Union.

Securing and Administering Access
This chapter addresses the issue of database privacy, integrity, and security. The main purpose for database security is to prevent both inadvertent and intentional damage to the data and the database objects. Proper security measures prevent anyone who might view or edit the information from gaining unauthorized access. They also prevent anyone from making design changes without express permission to do so. You can protect both the data and the design elements with a variety of approaches. TOC: Securing and Administering Access; Secure the Database with the User-Level Security Wizard; Groups; Add, Edit, and Remove Users; Save or Print the Security Report; Apply Global Database Protection to a Database; Remove Database Objects from View; Back Up and Restore a Database; Back Up Individual Database Objects; Database Administration; Compact and Repair a Database.

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.

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.

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.

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.

Retrieving and Arranging Data Meaningfully
We'll cover three important and related topics this lesson: filtering and sorting records, and basic queries. When you Sort records you order them in meaningful ways. When you filter records you hide those you don't want to see. Queries are like powerful filtering and sorting tools that also perform calculations. We'll discuss some basic queries in this lesson and more advanced queries next time. TOC: Retrieving and Arranging Data Meaningfully; Filtering; Basic Queries; Select Queries.

Advaned Queries and SQL
This week we're going to take queries to another level. We discussed the commonly used select query in last week's tutorial. This week we'll discuss some other ways to retrieve data as well as other query operations that allow for updating, adding, and deleting data. We'll start this lesson with a look at some special purpose queries: parameter and autolookup queries. After that we'll discuss the action queries update, append, make-table, and delete. TOC: Advanced Queries and SQL; AutoLookup Queries; Update Queries; Delete Queries; SQL (Structured Query Language).

Forms
In the seventh article in our series covering Microsoft Access, we take an in-depth look at forms. TOC: Creating Your First Form; The Form Wizard; Customizing Your Form.

Learning about Reports
In this week's lesson we're going to look at reports; what they are, how you create them, and how you customize them to fit your (or your organization's) needs. Reports show your table data as information so people can make decisions with them. You can create simple reports that show all the data in your tables, or you can summarize or perform calculations on the raw data to create attractive, informational reports. You can even use reports for printing mailing labels. TOC: Learning about Reports; Report Wizard; Customizing Your Report; More Ways to Customize Your Reports.

Macros
This week we'll discuss, for those of you unfamiliar with programming, one of the more conceptually complex aspects of Microsoft Access. We'll start with a discussion of events: what they are and how Access uses them. Then, we'll move on to a lengthy discussion of macros, including what they do and how you design and use them. TOC: Macros; Debugging; Getting Fancy with Macros.

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.

Understanding and Creating an Access Project
Table of Contents: Understanding and Creating an Access Project; Creating the Project; Populating with Data; Connecting to SQL Server; Linking to specific tables;

Jump Start VBA Skills with MS Access Macros
Macros help to speed up the performance of certain repetitive tasks when using an application. They are used extensively in all office-related software. As a programmer, you can leverage the built-in macro object in MS Access to get a head start in understanding VBA. This article explains how. TOC: Jump Start VBA Skills with MS Access Macros; Creating and running a macro in MS Access: opening the macro designer; Creating the first macro; Converting this macro to VBA code; Creating the second macro.

Data Access Pages: What they are and how to create one
Dynamic content is at the heart of successful presentation of enterprise information on the Internet. Without the ability to present data with user interaction, Internet based commerce will be meaningless. It is possible to create dynamic web pages with data from the enterprise by using several technologies, including MS Access. TOC: Data Access Pages: What they are and how to create one; Creating objects to be converted to DAP; Creating a Data Access Page; Displayed Data Access Page; DAP properties from the DAP Design; DAP from the Form and the Report.

Migrating from Access 2000 to SQL Server 2000
In this article, we will simulate migrating a relatively small but established business from Microsoft Access 2000 to SQL Server 2000. There are a variety of reasons a business might wish to perform such a migration. Legacy queries, forms, and reports will be taken into consideration, as well as the appropriate way to handle database files. Growing businesses often come to a stage where they need to migrate their MS Access database to a SQL Server. TOC: Migrating from Access 2000 to SQL Server 2000; MS Access: User Created Objects; Creating a SQL 2000 Server database; Exporting tables from MS Access 2000 to SQL 2000 Server; Establishing links to SQL 2000 Server database; Verifying functionality of existing objects.

wsh
This article explains how parametric queries can be used as a source for creating a Data Access Page. It also describes how to host such a page on an intranet. TOC: wsh; Creating a parametric query; Turning this into a Data Access Page; Page display in the browser.