MS Access (LEVEL-11) هذه الدورة تدرس باللغة الإنجليزية

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

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.