Courses

Share data across applications.

Use action, unmatched, and duplicate queries to manage data.

Create complex reports and forms.

Use macros to improve user interface design.

Use VBA to extend database capabilities.

Perform database management tasks such as backup, compacting, repairing, performance analysis, checking object dependencies, and documenting.

Implement security strategies and distribute a database to multiple users.

Work with multiple worksheets and workbooks.

Share and protect workbooks.

Automate workbook functionality.

Use Lookup functions and formula auditing.

Forecast data.

Create sparklines and map data.