The course is intended for those who are familiar with the basic database operations with M.S Access. This course helps you to design database applications for small business concerns. It helps the candidate to upgrade application development.

Course Content 

Revision of database objects.

  • Tables.
  • Queries.
  • Forms.
  • Reports.

Advanced table options.

  • Create lookup.
  • List box.
  • Combo box.

Advanced data type options.

  • Relationship with multiple tables.
  • Table Templates.

Advanced query options.

  • Query wizard.
  • Parameter query.
  • Calculations in query.
  • Append Update, Delete, and Make table and crosstab queries.
  • Sorting and grouping data in a query.

Advanced form Options.

  • Split Forms.
  • Use of form wizard.
  • Tabular forms.
  • Master detail form.
  • Calculation in form.
  • Using command buttons.

 Advanced report options.

  • Reports using wizard.
  • Repot based on multiple tables.
  • Master detail report.
  • Calculations in reports.
  • Reports based on queries.

Macros.

  • Introduction to Macros.
  • Creating and running macros.
  • Various macro actions.
  • Using Macros associated with command buttons.

Sample Project

  • Inventory.
  • Student Management system.

Family Computers is one of the pioneering companies to open computer training centre in Qatar and provides training services to corporate houses and individuals alike.  we provide training for a wide range of topics related to computers and have trained in excess of 40,000 students. A figure which is more than most of the training providers put together.

We are always in the forefront in launching job oriented, practical computer training courses. We emphasis on the importance of individual attention to students and limited students in a batch. This also helps us to improve the quality of our service.

See all Family Computer Center courses

Contact information not available.

Courses you can instantly connect with... Microsoft Access Training New Horizons Doha

Is this the right course for you?

Rate our content

Didn't find what you were looking for ?

or