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

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

Students should be familiar with using personal computers and have used a mouse and keyboard. Students should be comfortable with the Windows environment and be able to use Windows to manage information on their computer. Specifically, students should be able to launch and close programs; navigate to information stored on the computer; and manage files and folders.

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
تحديث بتاريخ 08 November, 2015

نبذة عن معهد New Horizons Egypt

Founded and headquartered in Anaheim, California, New Horizons Learning Centers was named the world's largest independent training company by IDC.

The Company is both an operator and franchisor of training centers that offer a broad range of Technical Training, Desktop Application, Business Skills and English Language courses for all levels of users in multiple delivery methods and formats.

New Horizons provides approximately three million student days of instruction annually with location around the globe.

New Horizons sets the pace of innovative training programs that meet the changing needs of the industry. With 2400 qualified instructors in over 2100 classrooms at 300 centers in 60 counters around the world.

New Horizons offers more courses, at more times, in more delivery methods than any other training company.

عرض الجميع دورات New Horizons Egypt
Are you from New Horizons Egypt ? Claim your course!
دورات يمكنك الالتحاق بها على الفور... خذ دورة عبر الإنترنت على Microsoft Access ابتداءً من الآن. See all courses

هل هذه الدورة التدريبية الاختيار المناسب لك؟

قيِم هذه الصفحة

لم تجد ما كنت تبحث عنه؟

أو