Training > Microsoft Office Access™, Database

Database concepts

What is a database?

What is a table?

What is a field or property?

What is a record?

What is a primary key?

What is an index?

What is a relationship, a query, a form and a report?

Creating a database

Defining your needs

Creating a logical structure

Using a wizard to create a database

Creating a database from scratch

Creating a database by importing external files

Creating relationships between tables

Creating a table by entering data

Exchanging data with others programmes

Importing data from others’ programmes

Exporting data to others’ programmes

Linking external data with your database

Publishing, merging and analysing data with Word or Excel®

Simplifying data entry with forms

Creating a form with a wizard

Changing form layout

Amending control properties

Creating a form from scratch

Adding controls on forms

Using AutoForm to create a form

Adding a subform to a form

Querying and localizing your data

Sorting data

Filtering data in tabular view

Filtering data by using a form

Using multiple criteria to localize data

Creating queries in design view

Creating queries by using wizard

Adding dynamically calculated data

Controlling and validating input data

Customizing input field options

Using an input mask

Using validation rules

Restricting input to a list of data

Updating data in a database

Deleting data from a database

Creating and amending your reports

Creating a report from scratch

Creating a report using a wizard

Modifying a report

Adding a sub-report to a report

Previewing and printing a report

Go further…

Compacting and repairing a database

Encrypting and decrypting a database

Using a password to prevent changes to a database

Programming repetitive tasks with macros

Customizing Access™ menus and toolbars