Microsoft Access training

Woospeak, language and office training center since 2006 , offers you its expertise for your Microsoft Microsoft Access office training . Our experienced trainers will help you improve and master Microsoft Access software.

Goal:	Acquire the essential basics of Microsoft Access software. Structuring a relational database. Define queries. Build forms and reports. Create simple macros. Acquire a methodology to design and manage a database.
Method:	Face to face, telephone, videoconference, e-learning
Prerequisites:	Know how to use a computer in a basic way (mouse, keyboard) and know the Windows environment
Public:	Anyone who has never used Microsoft Access
Duration:	2, 4, 6, 8, 10 hours ... adjustable duration as needed
Possible certifications:	TOSA, B2i, PCIE, ENI

The objectives of your Microsoft Access training

Our Microsoft Access training is one of our training courses in our office catalog. It will help you to master all the features of Microsoft Access software . This training will allow you among other things: to acquire the essential bases of Microsoft Access software, to structure a relational database, to define queries, to build forms and reports, to create simple macros, to acquire a methodology to design and manage a database.
Whatever your basic level, our tailor-made training programs are fully adapted to help you progress.

Your Microsoft Access training program (Beginner)

The content of the Microsoft Access training program is organized into 8 major areas, and will be adapted according to your objectives and your needs:

Module 1: Presentation of Access software

• Getting to know Access
• Find your way around the screen: toolbar, status bar, menus, ruler
• Methodology for building a database
• Creation of a database and DBMS
• Importing data from Excel under Access

Module 2: Design and organize your database

• Organize and distribute your data between different tables
• Create tables, define fields
• Identify the primary index key
• Define relationships, ensure referential integrity
• Import, export and attach data.

Module 3: Relationships

• Link tables
• The different types of relationships (one to one, one to many)
• Referential integrity
• Join types
• Create drop down list
• Complex relational diagrams: relay tables, star diagrams, etc.

Module 4: Querying your database with queries

• Selection requests: choice of fields, sort order, definition of selection criteria
• Extract data by setting criteria
• Grouping on a field, on an expression
• Multi-table and cross-analysis requests
• Action requests: update, add, delete, create table.

Module 5: Calculated queries

• Column calculations
• Online calculations: formula syntax, use the expression generator
• Some calculation functions: (True, Extract strings, Uppercase, Lowercase)

Module 6: Creating forms and entering data

• Create an instant form
• Create an instant form in a table
• Manage data: add, delete, modify, search, filter records
• Modify the form
• Subforms: creation, integration into a form
• Editable drop-down lists.

Module 7: Creation of reports

• Create a label report
• Create a report by the assistant
• Change state
• Creation of column or tabular reports
• Sorting and grouping
• Direct mail status. Printing a report.

Module 8: Creating complex forms

• Hierarchical organization of forms
• Create a form and a subform
• Insert action buttons: search list, command buttons
• Insert calculations
• Insert images

Practical work & learning control

If you wish, we can also offer you an office certification such as TOSA. This Microsoft Access training is eligible for the CPF (Personal Training Account) .

Microsoft Access in video training, by phone or face to face

As a specialized training organization, Woospeak offers you different training methods:

• A webcam training , where you follow your Microsoft Access lessons from your computer live with your trainer via your webcam.
• A telephone training , where you follow intensive 30-minute sessions
• A face-to-face training , where you are in the presence of your trainer
• A mixed training which combines several courses

This Microsoft Access training can take place at home or within your company.

We organize training sessions wherever you are and everywhere in France

Want to know more ? Please do not hesitate to contact us with any questions.
You can also ask us for a quote on your Microsoft Access training .