Would you like to see more Microsoft Access courses?

Further Details

Course Content: Complex queries Joining tables in queries Creating calculated fields Summarizing and grouping values Advanced form design Adding unbound controls Adding graphics Adding calculations Adding combo boxes Advanced reports Creating customized headers and footers Adding calculated values Working with subreports Creating charts Creating charts in forms Creating charts in reports PivotTables and PivotCharts Creating PivotTables Modifying PivotTables Working with PivotCharts Internet integration Working with hyperlink fields Working with data access pages Macros Creating and running macros Attaching macros to events of database objects Advanced macros Creating macros to provide user interaction Creating macros that require user decision Using AutoKeys and AutoExec macros Advanced queries Creating crosstab queries Using parameter queries Using action queries The SQL statement Writing SQL statements Attaching an SQL statement to database objects Importing, exporting, and linking objects Importing Access objects Exporting Access objects XML documents Linking Access objects Working with shared databases Database management Optimizing resources Ensuring database integrity Security fundamentals Protecting databases Encrypting and decrypting databases User-level security Modules and MDE files Understanding modules Understanding MDE files Application design Examining an application Planning an application Advanced forms Building a form based on joined tables Using automated data entry Using grouped controls Improving the user interface Creating Subforms Automating forms Working with dialog boxes Working with macro groups Automating navigation across forms Switchboards and Splash Screens Working with Switchboards Working with Splash Screens Automating Splash Screens

Guide price

£450 per person (public course)