In this package, trainees will learn features of Microsoft Access 2010. Trainees will have a systematic guidance through the development of database applications and will learn how to use & create the database objects within their database applications. This package stresses on providing depth understanding of database building and design to enhance both of the appearance and functionality of the database applications.

• Understanding database concepts
• Using Access databases
• Creating & using database objects
• Customizing database objects to suite end users
• Exchanging data between Access databases and the other programs
• Understand and get familiar with the database normalization
• Work with the Table Analyzer to enhance tables' design
• Use the Performance Analyzer to enhance the database performance
• Use the Documenter to produce statistical reports about databases
• Create and use crosstab queries to get structural matrix reports
• Create and customize PivotTables to produce complex structural matrix reports
• Create PivotCharts to graphically represent data
• Display related data from multiple tables using joins
• Manipulate tables' data using action queries
• Write simple SQL SELECT statements against tables' data
• Use the WHERE clause to restrict data through SELECT statements
• Use the ORDER BY clause to sort data through SELECT statements
• Create and use macros to automate database usual tasks
• Assign macros to controls, events and conditions
• Create and use macro groups
• Convert databases between various Microsoft Access versions
• Split a database to back-end and front-end databases
• Compact and repair databases
• Create a backup copy from the database file
• Secure databases by using passwords
• Create Navigation Form

Topics :