Most organizations maintain and manage large amounts of information. One of the most efficient and powerful ways of managing data is by using relational databases. Information can be stored, linked, and managed using a single relational database application and its associated tools. A hands-on training provides understanding of the basic database concepts, creating and modifying databases and their various objects using the Microsoft® Office Access™ 2010 relational database application. You will gain the basic skills needed to work with Microsoft® Office Access™ 2010 databases, including creating and working with Access tables, relationships, queries, forms, and reports. You will also learn to maintain data consistency, how to customize database components, and how to share Access data with other applications.
|
Topics:
- Identify the Elements of the Access 2010 Interface
- Identify the Components of a Database
- Examine the Relational Database Design Process
- Create a New Database
- Create a Table Using the Design View
- Manage Tables
- Establish Table Relationships
- Modify Table Data
- Sort and Filter Records
- Work with Subdatasheets
- Create a Query
- Add Criteria to a Query
- Add a Calculated Field to a Query
- Perform Calculations on a Record Grouping
- Create a Form
- Modify the Design of a Form
- View and Edit Data Using an Access Form
- Create a Report
- Add a Control to a Report
- Format the Controls in a Report
- Enhance the Appearance of a Report
- Prepare a Report for Print
|
Target Audience
This course is designed for students who wish to learn the basic operations of the Microsoft Access database program to perform their day-to-day responsibilities, and who want to use the application to be more productive in their work. It provides the fundamental knowledge and techniques needed to use more complex Access features such as maintaining databases and using programming techniques that enhance Access applications.
Prerequisite
To be successful in this course, you should be familiar with using personal computers and you should have used the mouse and keyboard. You should be comfortable in the Windows environment and be able to use Windows to manage information on the computer. Specifically, you should be able to launch and close programs; navigate to information stored on the computer; and manage files and folders. To ensure your success, we recommend you first take one of Element K's introductory Windows courses, such as either of the following, or have equivalent skills and knowledge:
•Windows XP Professional: Level 1 or
•Windows XP: Introduction |
Training Class Material:
- Course material
- 20% off Practice Test
- One hour Consulting Service
For more information
call 714-505-3475
For Schedule, click here. |
Home
