Learn how to manipulate the comprised elements (sections, controls) of reports and to optimize the presentation and functionality of reports with Access.

Private session

This training is available in a private or personalized format. It can be provided in one of our training centres or at your offices. Call one of our consultants of submit a request online.

Call now at 1 877 624.2344

Duration: 1 day
Regular price: On request

Course outline

Duration : 1 day

© AFI Expertise inc.
Audience	Any data base user or manager
Prerequisites	Windows - User or equivalent Following training: Access - Data structuring and normalization
Objectives	Able to manipulate the comprised elements (sections, controls) of reports. Learn how to optimize the presentation and functionality of reports
Teaching method	Presentations - Demonstrations - Guided and Individual Exercises
Contents	Chapter 1 – Modifying the Structure and Appearance of a Report Access the creation mode of a report Manipulate the sections of a report Manage page breaks in a report Insert pagination and date codes in a report
	Chapter 2 - Changing the Location, Size and Appearance of Controls Manipulate controls Manipulate the organization of controls in creation mode (Tabular, Stacked) Identify the types of controls Add a control Modify the organization parameters of Tabular controls Control access to dependent controls in forms Modify the value of a control Modify the value of a control's property
	Chapter 3 - Performing a Mailing Create a report for printing labels Create a report for printing envelopes Create a sample letter
	Chapter 4 - Creating Summary Reports Perform grouping and sorting in a report Use calculated fields in group sections Use statistical functions
	Chapter 5 – Representing Data Graphically Add a graphic control to a report Modify the elements of the graph
	Chapter 6 - Creating Nested and Independent Reports Add sub-reports Create a compressed report of independent sub-reports
	Chapter 7 - Using Command Buttons Create an application form Use the command button wizard Manipulate event properties Create a start-up form

Surround yourself with the best

Pierre-Edouard Brondel

Trainer

Renowned as an educational expert in the IT and office technology field who has accumulated more than 25 years of experience, Pierre-Édouard is first and foremost passionate about human capital.

Human

Digital Tools

Technology

Data Science

Organizational Strategy

Project Management

Change region

Access - Building reports

Course outline

Surround yourself with the best