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

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

In this course, students will learn how to use Access to manage data, including creating a new database, constructing tables, designing forms and reports, and creating queries to join, filter, and sort data.

Objectives

Upon successful completion of this course, students will be able to: 

• identify the basic components of an Access database. 
• build the structure of a database. 
• manage data in tables. 
• query a database. 
• design forms. 
• generate reports. 
• streamline data entry and maintain data integrity. 
• join tables to retrieve data from unrelated tables. 
• create flexible queries to retrieve data and modify tables.  
• improve the functionality of Access forms. 
• customize reports to organize the displayed information and produce specific print layouts.  
• share data between Access and other applications.

Prerequisites

Lessons

• Lesson 1: Getting Started with Access 2010
• Lesson 2: Building The Structure of a Database
• Lesson 3: Managing Data in a Table
• Lesson 4: Querying a Database
• Lesson 5: Designing Forms
• Lesson 6: Generating Reports
• Lesson 7: Controlling Data Entry
• Lesson 8: Joining Tables
• Lesson 9: Creating Flexible Queries
• Lesson 10: Improving Forms
• Lesson 11: Customizing Reports
• Lesson 12: Sharing Data Across Applications