Course – Access Training
This Access course is for Access database administrators. At the end of this intensive 3-day Access training, you will be able to create tables in Access, create a relational model, create reports, and make queries to interact with the data of your tables. This Access course is therefore the ideal training to manage an Access database.
Introduction of Course – Access Training
Definition of a database
Definition of an RDBMS
File extensions
Presentation of the interface
Present Access Objects
Practical Workshop: Creating an Access Database
Table Creation in Access
Create a table
Table creation methods
Data Sheets Mode
Creative mode
Different types of fields
Optimize the size of the fields
The basic tables
Motion tables
Practical workshop: create customer tables and products
Relational model
Introduction to modeling
Relationships 1-1
1-n relations
The relational schema of the base
Define relationships
Edit, delete relationships
Practical workshop: Creating a relationship model
Form Creation in Access
Create a form
Form creation methods
Form opening modes
Creating input forms
Creating consultation forms
Add an object to a form
Edit a form
Hands-on Workshop: Creating Seizure and Movement Forms
Creating queries
Simple queries
Criteria
Filters
queries with SQL
State creation
Create a state
State creation methods
State opening modes
State presentation tools
Autre(s) cours dans cette catégorie
→ SQL Training, Conceptual Data Modeling
→ Course – SQL and PL / SQL Training
Préalables :
- Know the computer tool
Objectifs :
- Design and structure a relational database.
- Master the functions of management of requests, forms and states
- Create queries
Montréal :
Québec :
Gatineau / Ottawa :
Moncton :
Classe virtuelle (en ligne) :
774 $
per participant
Duration :2 day(s), is 14 hours.
Hours: 9 am-5pm, 2 coffee breaks.
Locations: Montreal, Gatineau / Ottawa, Quebec City.
Regular price: 911 $
*The preferential rate applies if you register at least two participants in the same session.
“ I want to thank you both for providing my resources some excellent training(Cobol) over the past 3 days. Mamadou, thank you for being so accommodating on such short notice and for sending your facilitator to Gatineau for this customised and personalised training course. We’ll look forward to continuing our partnership for future training needs. “
“J’ai grandement apprécié les méthodes d’enseignement du prof. Le fait que nous soyons un petit groupe a grandement facilité les apprentissages. Il s’adapte à son audience et les exercices sont formateurs. Je recommande fortement. “
“ Ce fut un plaisir de faire affaires avec Doussou Formation. Ce qui fait LA différence est le service personnalisé totalement à l'écoute des participants ainsi que l'adaptation aux besoins de formation. Flexibilité / Adaptabilité / Professionnalisme / Courtoisie. Merci!“