· 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
