Access 2010 Intermediate AC-018

Course Overview

To create an application composed of tables, queries, forms, reports, macros and menus.


Prerequisites

Microsoft Access 2010 Intermediate and experience in application creation using Access

Syllabus

Queries:

  • Definition and use;
  • Creating a query using the assistant;
  • Working with queries;
  • Relationships inside queries.

Forms:

  • Definition and use;
  • The user interface concept;
  • Creation modes;
  • Working with forms.

Reports:

  • Definition and use;
  • Types of reports;
  • Creation modes;
  • Working with reports.

Advanced Report Creation:

  • Understanding the concept of a control;
  • Modifying the properties of a control;
  • Understanding the dependency and interdependency concept;
  • Using the design mode and the report assistant;
  • Creating simple reports in design mode that contain grouping and use the assistant;
  • Applying conditional formatting;
  • Fixing common printing issues;
  • Using the properties of objects;
  • Sorting and filtering report data;
  • Adjusting the print parameters for a section;
  • Modifying the format of a field.

Macro Creation:

  • The concept of macros;
  • Defining a macro;
  • Identifying the macro creation window;
  • Defining an event;
  • Developing macros in Access;
  • Creating a simple macro, a group of macros and a conditional macro;
  • Using macros with objects;
  • Associating macros with command button properties and form properties.

Appendix:

  • List of macro Actions in ascending order.

Share

[ssba]


Duration : 2 days
Regular Rate : $ 290
Preferential Rate : $ 220
Notes :


Upcoming Dates

[ESPRESSO_TICKET_SELECTOR event_id=13365]

Duration : 2 Days
Regular Rate : 290.00 $
Preferential Rate : 220.00 $
Note :
Upcoming Dates :
price
qty