05-09-2012, 04:52 PM
Introduction to Microsoft Access 2003
access2003.pdf (Size: 1.09 MB / Downloads: 112)
Introduction and Objectives
Microsoft Access 2003 is a powerful, yet easy to learn, relational database application for Microsoft Windows. 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.
Please be aware that Microsoft Access is only available for Windows users; Mac users may want to seek out a FileMaker Pro Tutorial.
Access vs. Excel
Access databases and Excel spreadsheets although originally very different, have evolved to have similar functions. Although either type of program can do many, but not all, of the things that the other one does, there are some things which are easier in one program than the other.
Excel is not database management systems. Excel spreadsheets store data in rows and columns called worksheets. The areas within the worksheet where the rows and columns intersect are called cells. The most common use of spreadsheets is to manage basic information such as telephone numbers, employee names, financial data, calculations, etc.
Adding and Deleting Fields to Tables
Even the best planned database will sometimes require you to add or delete a field in the Design View. To add a new field, select the row you want to insert above and choose “Row” from the Insert menu. If you need to delete a field, select the row containing the field and choose “Delete Row” from the Edit menu.
You can also move fields in the table design. Select the field you want to move by clicking on its row. A black triangle will appear to indicate the field is selected. Then, drag the field to the new location.