Access 2007 - Level 1 هذه الدورة تدرس باللغة الإنجليزية

تفاصيل الدورة

In the course, students create and modify new databases and their various objects. They learn how to maintain data consistency and integrity; improve queries, forms, and reports; and also integrate Access™ with other applications.

Objectives

Upon successful completion of this course, students will be able to: - examine the basic database concepts and explore the Microsoft Office Access 2007 environment. - design a simple database. - build a new database with related tables. - manage the data in a table. - query a database using different methods. - design forms. - generate reports. - modify the design and field properties of a table to streamline data entry and maintain data integrity. - retrieve data from tables using joins. - create flexible queries to display specified records, allow for user-determined query criteria, and modify data using queries. - enhance the capabilities of a form. - customize reports to organize the displayed information and produce specific print layouts. - share Access data across other applications.

Prerequisites

Lessons

• Lesson 1: Exploring the Microsoft® Office Access™ 2007 Environment
• Lesson 2: Designing a Database
• Lesson 3: Building a Database
• Lesson 4: Managing Data in a Table
• Lesson 5: Querying a Database
• Lesson 6: Designing Forms
• Lesson 7: Generating Reports
• Lesson 8: Controlling Data Entry
• Lesson 9: Joining Tables
• Lesson 10: Creating Flexible Queries
• Lesson 11: Improving Forms
• Lesson 12: Customizing Reports
• Lesson 13: Sharing Data Across Applications