Course details

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.
Updated on 08 November, 2015

About Family Computer Center

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
Are you from Family Computer Center ? Claim your course!
Courses you can instantly connect with... Do an online course on Microsoft Access starting now. See all courses

Is this the right course for you?

Didn't find what you were looking for ?

or