Microsoft Access Level II Egyptian Banking Institute
Price: TBA
  • Locations: Dokki
  • Duration: 16 Hours

Course details

During this course, participants will learn how to maintain data consistency and integrity, improve queries, forms, and reports and integrate Microsoft Access™ with other applications.

Course Objectives:

  • Setup data entry controls in Microsoft Access™.
  • Create and use advanced query techniques in Microsoft Access™.
  • Design and tailor forms in Microsoft Access™.
  • Customize reports in Microsoft Access™.
  • Export and import file data across different applications.

Course Outline:

Module 1: Controlling Data Entry

  • Restricting the type of data in a field
  • Restricting the amount of data in a field
  • Specifying the format of data in a field
  • Restricting data by using validation rules
  • Create a list of values for a field

Module 2: Advanced Queries

  • Create query joins
  • Create parameter queries
  • Create action queries
  • Create sub queries
  • Save filters as queries
  • Sort data within tables, queries, reports and forms
  • Filter data within tables, queries, reports and forms

Module 3: Improving Forms

  • Design a form layout
  • Enhance the appearance of a form
  • Restrict data entry in forms
  • Add a command button to a form
  • Create multiple item forms
  • Create sub forms

Module 4: Customizing Reports

  • Organize report information
  • Format the report
  • Set report control properties
  • Control report pagination
  • Summarize report information
  • Add a sub report to an existing report
  • Create a mailing label report

Module 5: Sharing Data across Applications

  • Export data from tables
  • Export data from queries
  • Save and run import specifications
  • Export objects in XPS format
  • Export objects in PDF format

Assessment Strategy:

Participants will be evaluated based on their participation in class discussions and activities

Course Location

About Egyptian Banking Institute

A specialized and unique service provided by EBI's Research and Awareness Department. At the Egyptian Banking Institute, we produce publications every year about the EBI’s business performance, our charitable giving, our efforts to reduce the impact of our businesses on the environment, and other measures of our sustainability.

See all Egyptian Banking Institute courses

Contact information not available.

Are you from Egyptian Banking Institute ? Claim your course!
Courses you can instantly connect with...
Access 2010 - Level 1 New Horizons Egypt Access 2013 - Part 1 New Horizons Egypt Access 2010 - Level 2 New Horizons Egypt

Is this the right course for you?

Rate our content

Didn't find what you were looking for ?