Microsoft Access can use data
stored in Access, Microsoft SQL Server,
Oracle, or any ODBC-compliant
data container. Skilled software developers and data architects use it
to develop application software. Relatively unskilled programmers and
non-programmer “power users” can use it to build simple applications.
It supports some object-oriented (OO)
techniques but falls short of being a fully OO development tool.
Anderson School District in Pendleton, SC, has provided the following Access training documents with exercises. These teach you how to use many of the features or Access, such as creating and working with tables, forms, reports, generating easy and complex queries. All of the features demonstrated here are also available in Access 2003.
Introduction to Access XP (pdf, 10 pages, 215kb)
This Access training document teaches you how to create and edit Access tables, use table design functions, perform basic and more complex queries, and generate forms and reports. It contains a glossary of terms and 5 in-depth exercises explaining how to accomplish the tasks that are described.
Access Exercises (pdf, 5 pages, 86kb)
These Access exercises demonstrate and instruct you how to do the following: create a Report and Report Layouts, create an AutoReport, use the Report Wizard, work with Report Preview, print a Report, and save a Report.
Introduction to Access (pdf, 63 slides, 234kb)
These training slides explain the following Access database concepts, featuress, and procedures:
- Database Design Concepts
- Database Management System (provides functions to store, search or query, and report the data contained in the database)
- Relational Database (a collection of related information organized into separate files or tables that can be related to one another by common components or fields.)
- Single Table vs. Relational Tables
- The Access Database Container
- Database management system components or ‘Objects’.
- Planning and Creating a New Database
- Naming Conventions
- Creating tables in design view
- Creating a Primary Key or Index
- Working with Tables
- Choosing Fields for a Query and Criteria in a Query
- Criteria Symbols
- Working with Queries and more Complex Queries
- Query Types
- Forms and Reports
- Forms and Reports Design
Tags for this post>> Access