Access: 3. Reports and forms

  • Course types: Calendar course / In company
  • Version: Office 2010/2013/2016
  • Takes place in: Antwerp, Brussels
  • Duration: 1 day
  • Price: € 365 VAT excl. / Cheaper course?

"Instructive and practical course, taught by an enthusiastic teacher"
Muriel Michiels – P&V Assurances

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 2016: 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 2016: Advanced and VBA Programming.

Choose a date and location

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 2016 - Creating databases
  • Access 2016 – 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

Choose a date and location

  • Dates
  • Days
  • Timing
  • Language
  • Location
  • Planning
  •  

Request an offer



Share this course on Facebook, Twitter, LinkedIn or e-mail

Practical info

The practical info and applicable cancellation conditions related to this training course.

 

Choose a date and location

€ 365 VAT excl.
Cheaper course?

Requesting a quotation

Would you like to organize this training course for your employees? At your offices or at a Xylos training centre? We transform your requirements into the perfect solution.

Request

Discount

SEVERAL PARTICIPANTS
If you enrol several employees for the same course on the same date, you will get a discount:

  • 2 employees: 15% discount on the 2nd subscription
  • 3 or more employees: 15% discount on the 2nd subscription and 40% on further participants

Questions?

Contact Inès Vansteenkiste

+32 2 264 13 20
xylos@xylos.com