Microsoft Office Access Tutorial 2007
Microsoft Office Access is database software that does not require the user to know a programming language. Access uses wizards and point/click methods to guide the user through the process of building and maintaining a database. For those unfamiliar with Access, there are some basics that should be taught.
Other People Are Reading
Instructions
-
-
1
Teach the basics of a table. Allow the students to enter raw data into the table and also teach how to import data. The table contains the raw data used in an Access database. Information for the table can be entered directly into the database or imported from other sources. The aspects of the table such as fields, field types, table construction and table design.
-
2
Cover queries. Show how queries can be used to manipulate, select, add, remove or modify data in a table. Queries can also be used to create or delete entire tables. Teach the students how to use queries to group and/or calculate data in a table.
-
-
3
Instruct on the use of forms, have the class build forms from the queries and tables in the dataset. A form is used to enter information into a table or navigate a database. The form is a user-friendly way of entering data into a table. It is more visually pleasant than entering data directly into a table. Forms can also be used as database menus. In lieu of users directly accessing the components of the database, forms allow users to click menu buttons to move from one part of the database to the next.
-
4
Teach the class that reports are used to present the information in a printer-friendly format. The reports obtain information from tables or queries. Walk through report creation, formatting, page setup and layout.
-
5
Create macros to show how database tasks can be automated. Explain the built-in functions that are available in the macro drop-down boxes. The tutorial should instruct the student how to create a macro and embed it into the database.
-
1
Tips & Warnings
All of the sections except tables and macros can be taught through the use of wizards. This may be helpful as it already builds upon the knowledge of wizards in other Microsoft Office applications. At each step of the tutorial, check for the students' understanding and allow "hands-on" learning.
References
Resources
- Photo Credit searching image by dinostock from Fotolia.com
