How to Use Microsoft Office Access 2003
Microsoft Access 2003 is an application designed to create databases. Databases serve the primary function of data collection, management and storage. MS Access databases store data in tables and can exist as a single file that allows you, in a few steps, to query, report and create forms based off your tables.
Other People Are Reading
Instructions
-
-
1
Open the Microsoft Access 2003 application. Click “File," then "New” to open the New File task pane.
-
2
Click “Blank Database” to open a new file. A dialogue box will open prompting you to name your file. Click “Create” once you have named your file.
-
-
3
Create your table in design view, using a wizard, or by entering data. Choose the one you want by highlighting it and selecting “Open.”
-
4
Customize the fields in your table. In design view, enter the field titles in the grid and close when complete. Using the wizard, select from the sample tables and sample fields. Rename the fields by selecting “Rename Field” and input your preferred titles. Select “Next” in the wizard.
-
5
Name your table and select “Yes, set a primary key for me.” Click “Next” to continue through the wizard. At the end, select “Enter data directly into the table” and click “Finish.”
-
6
Enter data into your table. As you complete your first record and hit the "Enter" button, the next line will appear for you to enter a second record. When you have completed data entry, close the table as you would any window. The table is saved under "Objects" and "Table" in the file's object list. Upon opening the file, the object list will appear.
-
7
Click on "Queries" or "Forms" or "Reports" in the file's object list to create a query, form or report. As with tables, each object has a wizard to guide you through completion.
-
1
Tips & Warnings
Sort data in tables, queries, forms and reports from the toolbar icons.
