Tutorial of Microsoft Access 2007
Microsoft Access 2007 is desktop database software that helps users quickly house, track and share information. With Access, it is not necessary to know a programming language. The database can be built and used by pointing-and-clicking through the database components. In a tutorial, students must learn database design. They must also understand the purposes and uses of tables, queries, forms, reports and macros.
Other People Are Reading
Instructions
-
-
1
Plan the database. Illustrate and document what the database will do. List the data needed, the source of the data, stakeholders and what the stakeholders need from the reporting.
-
2
Decide which fields will be in the tables. Determine whether the fields will be text or numerical. Click on the "Create" tab, then go to the "Table Design" panel. The tables will contain the raw data. Input the information into tables or key it in manually; or import it from another information source such as Microsoft Office Excel or an enterprise computer system. Save and name the table.
-
-
3
Go to the Query Wizard. It is located on the "Create" tab. Walk through the step-by-step guide that the wizard provides. Provide the tables and fields to include in the query; the wizard will automatically create the query based on the answers. Click on "Run" or the Spreadsheet view, to see the results of the query. Save and name the query. Queries pull information from the tables.
-
4
Click on the "Create" tab. In the "Forms" tab, click on "Form Design". In the upper-left corner of the Form window, right-click on the black square. Go to "Properties". In the Property Sheet window, click on the "Data" tab. Click on the down arrow in the Record Source field and select the table that the form will use. Forms are used to input information into tables.
-
5
Click on "Add Existing Fields", on the "Tools" option of the "Design" tab. Click, and drag each field to be included to the form. Click, and drag the field to move them to the desired location.
-
6
Click on the "Label" field on the "Controls" option on the "Design" tab. Drag the Label field to the form. Type the name of the form in the "Label" box. Save the form. A report is built using the same steps as a form. The only difference is to click on "Form Design" on the "Create" tab, and the Labels can be in the Page Header, Detail or Page Footer sections.
-
1
Tips & Warnings
Wizards can be used to build queries, forms and reports. If this is the first foray into Microsoft Access, use the wizards to understand how tables, queries, forms and reports interact.
Macros and Visual Basic can also be used in Microsoft Access 2007; however, do not explore these options until there is a firm understanding of the basics of Access.
References
Resources
- Photo Credit computer class-room image by araraadt from Fotolia.com
