Understand the distinction between Selection and Action requests, define the possibilities offered by Action queries and design and execute an Action Query.
Following training: Access - Data structuring and normalization
Objectives
Understand the distinction between Selection and Action requests
Able to define globally the possibilities offered by Action queries
Able to design and execute an Action query
Teaching method
Presentations - Demonstrations - Guided and Individual Exercises
Contents
Chapter 1 - Setting up a Query
Create and run a parameterized Query
Chapter 2 - Manipulating records with Action Queries
Create a Query Add
Use the Delete query
Make a Create a Table Query
Make an Update Query
Chapter 3 - Customizing the Database
Create groups of objects
Define operating options
Perform automatic correction of object names
Chapter 4 - Automating Object Management
Create a macro and discover the macro editor
Differentiate between command macros and built-in macros
Execute a macro
Associate a macro with a command button
Open and close a form with a macro
Associate the macro with a trigger event
Chapter 5 - Automating Printing
Print specific records
Attach the print macro to the right event
Chapter 6 - Interacting with the User
Use message boxes
Use conditional macros
Chapter 7 - Automating the Search
Filter records
Perform a search
Chapter 8 - Using Table Events
Choose the appropriate table event
Create a table event
Delete a table event
Chapter 9 - Defining Startup Options
Access the configuration options
Create a main menu
Use the AutoExec macro
Surround yourself with the best
Pierre-Edouard Brondel
Trainer and Desktop Application Consultant
Renowned as an educational expert in the IT and office technology field who has accumulated more than 25 years of experience, Pierre-Édouard is first and foremost passionate about human capital.
Yves Pilon
Trainer
Yves Pilon is passionate about technological tools. His knowledge of web and office softwares has made him an expert on all Microsoft Office tools. Yves' excellent pedagogy has earned him praise from our clients on several occasions. He stands out for his spirit of synthesis and active sense of listening to the needs of the participants. The expertise he has accumulated over the years gives him the ability to ensure a productive transfer of knowledge to our clients.
Frédéric Paradis
Certified Trainer and Cloud Architect
As a certified Microsoft trainer, Frédéric describes himself as a Cloud magician who easily navigates the mythical space between technology and reality.
Marc Maisonneuve
Training program director
Marc Maisonneuve has acted as a Training Program Director, professional effectiveness trainer and user tools practice leader at AFI for several years. Mr. Maisonneuve is known for his analytical skills, his legendary calm and his undeniable desire to encourage people to develop their skills. He has the ability to present technological solutions in a natural way and to adapt them to the concrete needs of the workplace.
