Skip to main content

Access: 3. Reports and forms

Version: Office 365
Duration: 1 day
Price incompany training: € 1100 VAT excl. /  Terms of incompany training

Description

Create order in your database with our Access training course on reports and forms

Does your database lack an easy-to-use, intuitive interface or not have one at all? Or would you like to display the results of queries in a more structured manner? With the Access training course from Xylos you will be able to create a clear order. You will learn how to clearly structure your database and make it intuitive. Do you want to avoid getting lost in all your data? Then the ‘Access: Reports and forms’ training course is exactly what you are looking for!

And this is not our only Access course. Xylos has Access courses for beginners and advanced users. Want to design a database and retrieve information from tables with queries? This is discussed during our first training modules (module 1 and 2). And for advanced users there is also Access: Advanced and VBA Programming.

Objectives

What will you learn during the Access’ course?

Do you use your Access databases a lot? And do other end users need to view your data quickly and without any problems? Then you had better make sure you have a clear interface. How exactly do you do that? Our expert will give you an in-depth explanation during the Access training course. You will learn to create reports and forms that show a print-ready overview of your data.

Attention: this Access training course only discusses the default databases, not the web databases, as these have limited functionality.

Target Group

Anyone who wants to create forms and reports for an existing database

Prerequisites

You have already completed the Xylos Access courses:

  • Access – Creating databases
  • Access – Working with tables (Queries and Filters)

Or you have the equivalent knowledge of primary keys, foreign keys, relationships and query types (such as action queries, parameter queries, grouping queries and calculating fields in queries).

Content

The various types of forms

  • A standard form
  • A split form
  • A continuous form
  • A Parent-Child form
  • A navigation form

Making a form

  • Making and adjusting a form with help from the wizard
  • Making a form entirely by yourself
  • The various views: Form View, Design View, Datasheet View, Lay-out View
  • Working in Lay-out View
  • Working in Design View
  • The various sections of a form
  • Working with the various controls (label, textbox, combo-box, buttons, checkboxes)
  • Anchoring controls to the edge of the form
  • Grouping controls
  • Exchanging control properties
  • Adding a sub-form

Making a report

  • Making and adjusting a report with help from the wizard
  • Making a report entirely by yourself
  • The various views: Report View, Design View, Datasheet View, Lay-out View
  • Working in Lay-out View
  • Working in Design View
  • The various sections of a report
  • Sorting a report
  • Grouping in a report
  • Adding totals to a report
  • Integrating a report in a form
View all our trainings

Request a quote

"*" indicates required fields

Address*
Name*
In which language(s) do you wish to organise this training?
You apply for this course as:
Do you want the training online or on-site?