Database Management

In Access 2010, tables should be normalised with the help of the table analysis wizard. Normalisation is vital to ensure that all Access 2010 databases have the same format and can be linked up and analysed easily.

Furthermore, it is important to know how to compress a database when the amount of data in it is getting out of hand.

Besides that, this course will teach you how to:

• Repair a database
• Use the database documenter
• Create a pivot table
• Analyse the performance of a database