Access: 1. Creating Databases

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

"A very structured and comprehensible course. This course definitely met all my expectations."
Marijke Sleeckx – Media Marketing

Description

Want to create professional databases? Why not take an Access training course!

Do you want to link your customers' contact details to their orders? Or combine data from several sources into one database? Then without doubt Access is the program for you. Perhaps you are thinking: what about Excel? Because it’s a spreadsheet program, Excel is not as efficient for creating complex searches, user-friendly entry forms and professional reports. Choose the best and easiest method: an Access training course from Xylos. In just one day you will learn how to design your own database.

Are you raring to put together your own databases, or would you like to have a better understanding of the structure of your existing databases? Enrol now for this first module of our Access training course: creating databases.

Choose a date and location

Objectives

Want to enrol for our Access course? What will you get from this course?

If you enrol for an Access course at Xylos, you will soon be in full control of your database structures. No one can tell you anything more about how to:

  • Set up a relational diagram
  • Define tables and relationships in Access 2013

And from now on the terminology will become part of your basic vocabulary: primary key, foreign key, record, field, index, composite key, referential integrity etc.

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 make a database in Access to add structure to their data.

Prerequisites

This is an introductory module. This means that although this is an Access training course, you don’t need any specific prior knowledge to take it. Experience with lists in Excel will certainly help; Excel and Access do have a number of interfaces in common.

Content

Introduction

  • The various parts that make up a database: tables and relationships.
  • The various parts of a table: fields, records, primary and foreign keys.

Normalisation

  • Developing a database structure with the help of the Codd normalisation method (limited to the first three steps): preparation, splitting of repeated fields, splitting of functional dependencies, splitting of transitive dependencies.

Tables in Access

  • Creating a table in Access via Design View and Datasheet View.
  • Defining a primary key in a table.
  • The various data types.
  • The various field properties: introducing a standard value; limiting input of data; defining input masks; deciding whether a value is required; etc.
  • Add or delete an index for one or more fields.
  • Making a list of choices with set values or that search for values in a different table.

Relationships

  • Defining relationships;
  • What is referential integrity?
  • Relationship types: one-to-one; one-to-many; many-to-many.

Datasheet View

  • Inputting, exchanging and adjusting data;
  • Adjusting the Datasheet View: alternating row colour, fonts;
  • Making totals in Datasheet View

External data

  • Linking tables to external datasources: Excel, Access, ODBC (SQL), SharePoint.
  • Importing data from external data sources.
  • Compiling data via e-mail.

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

€ 315 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