Looking for a free training on Microsoft Access. You don't know anything about creating database applications using this famous software. Well this site is intended specially for you.
You might say: Okay, but I'm not an IT professional and I can't program! Not serious. With this free course, you'll edit with Microsoft Access applications without programming. Just small manipulations that will be explained to you step by step with a language accessible to all as well as concrete examples and exercises that will accompany you throughout your progress.
In this course we will learn how to create a new database, master best practices to create tables and relationships, tame forms, query the data by using queries, automate everything using macros, package your application in a file executable in the manner of pros software and much more.
Finally all you need allowing you to fly using your own wings in the world of MS Access applications.
Talk to you we a file database or Access application?
Can we create professional applications using Ms Access?
Which version of Access use?
Y'a t – he of the prerequisites for this training?
What is Microsoft Access?
What is a database?
Know the interface of Microsoft ACCESS 2007.
This chapter is mandatory! It is designed as a step-by-step tutorial that will allow you to create your first applet. Its goal to connect and take a tour through the different objects in Access, and also to know how everything works and begin to familiarize yourself with the terminology used in the world of databases.
Here we will learn the right methods to create tables, this is the Foundation to build databases that are strong and last
Usefulness of relations
types of relationships
What is a form and what does it do?
Create a form using the wizard
Create a form in design mode
What is a query and what's the point?
Create a single query
Create a query from several tables
What is a State and what does it do?
Create a report using the wizard
Create a report in Design view
A macro embedded
A special macro: autoexec
Split an Access BD
Consider your future users
Configuration and setting up the application
Why not help the Microsoft?
Chapter XI: How about an Access database application on the internet?
A BD Access on a LAN