OBJECTIVES
Being able to create a database under Access
PUBLIC
Anyone wishing to learn about Access
REQUIREMENTS
Good knowledge of the Windows environment
PROGRAM
Introduction
Relational databases
How to build a database?
Overview of an Access database
Creation and manipulation in a table
Definition of a table, the different types of creation of a table
Types of data
Field Format - List of Choices
The calendar
Register a table - Open, modify, delete
Primary key
Creating relationship between tables
Reference integrity
The different types of relationships: one to many relationship, many to many relationship
Modification, deletion of a relationship
Creating and editing simple queries
Defining and creating queries
Selection queries
Recording a request
Creating and modifying a state
Definition - State Creation Wizard
Layout
Creating a form
Instant Forms - Forms Creation Wizard
EDUCATIONAL TOOLS
Presentations
Exercises
Practical cases
Good to know
DURATION
2 days
Organizer
Reval
You could like it :
find out about all the networking events and trainings tailored for you!
find out about all the networking events and trainings tailored for you!
