logo small

Databases

E: info@croydonitcentre.co.uk

M: 07553557016

Microsoft Access is a relational database management system that enables everyday office-based IT users to interface with the complex Microsoft Jet Database Engine. Microsoft Access is extremely versatile and has the ability to link directly to data stored in other applications and databases.

Beginner Beginner Beginner Biginner Intermediate Advanced
Skills Covered Databases and tables • Planning and designing databases • Creating tables Fields and records • Finding and editing records • Organizing records Data entry rules • Setting field properties • Working with input masks • Setting validation rules Basic queries • Creating and using queries • Performing operations in queries Using forms • Creating forms Relational databases • Table relationships • Creating lookup fields • Modifying lookup fields Complex queries • Joining tables in queries • Using calculated fields Advanced form design • Adding graphics • Adding calculated values • Adding combo boxes Reports and printing • Calculated values • Labels PivotTables and PivotCharts • Create parameter queries to view results based on specified criteria, and create action queries to add, delete, and modify data in table. • Create and run macros to automate tasks and attach macros to the events of database objects. • Create data validation and create macros that run parameter queries and create macros to import and export database objects. • Import Access objects from other applications and from CSV files. Export objects from one database to another. • Save to previous versions.
Price £30 per hour £35 per hour £40 per hour

You are viewing the text version of this site.

To view the full version please install the Adobe Flash Player and ensure your web browser has JavaScript enabled.

Need help? check the requirements page.


Get Flash Player