Access 2007 - Introduction
Discover the basics of this powerful database program faster than you ever thought possible without the aggravation and mistakes of attempting to learn this complex software on your own.
Database design and development is complex and difficult to do well without the tools you will learn in this workshop. This workshop provides a solid foundation for using Access to create well designed databases.
Beginning with relational database fundamentals and design concepts, you will learn first hand when to use a database, how to design a database, and the main Access tools to create and manage tables, queries, forms, and reports.
Prerequisites:
Assumes no experience using Access, but a basic computer background and familiarity with Windows is expected.
Topics Include:
- Database components and terminology
- Practical uses for relational databases
- Concepts to modify and improve an existing or new database
- Creating, modifying, and managing records within a table
- Sorting, filtering, and finding records
- Creating fields and modifying field properties
- Relationship links among tables (1 to 1 and to many)
- Queries – how to get the information you need from your database:
- Calculations (expressions) in query
- Select query with criteria
- Multi-tables used in query
- Creating and modifying customized reports
- The quickest methods to create and enhance forms
- Various methods to create and enhance forms
- Importing data and transferring to other applications such as Word and Excel
|