Trusted teacher

I will help you master all the features of Microsoft Access software. objectives: --------------- Acquire the essential bases of Microsoft Access software. Structure a relational database. Define queries. Build forms and reports. Create simple macros. Acquire a methodology to design and manage a database. Whatever your basic level, I will adapt to it in order to help you progress. Program ------------------- Module 1: Presentation of Access software Familiarize yourself with 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 into Access *** Module 2: Design and organize your database Organize and distribute your data between different tables Create tables, define fields Identify the index primary key Define relationships, ensure referential integrity Import, export and link data. *** Module 3: Relationships Link tables The different types of relationships (one to one, one to many) Referential integrity Join types Create a drop-down list Complex relational schemas: relay tables, star schemas, etc. *** Module 4: Query your database with queries Selection queries: choice of fields, sort order, definition of selection criteria Extract data by setting criteria Grouping on a field, on an expression Multitable and cross-analysis queries Action requests: update, add, delete, create a table. *** Module 5: Calculated queries Column calculations Online calculations: formula syntax, use the expression generator Some calculation functions: (True false, Extraction of strings, Upper case, Lower case) *** Module 6: Creating Forms and Entering Data Create an instant form Create an instant table form Manage data: add, delete, modify, search, filter records Modify the form Subforms: creation, integration into a form Editable drop-down lists. *** Module 7: Creating Reports Create a label report Create a report using the wizard Change state Creation of column or tabular reports Sorting and grouping Direct mail report. 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

Trusted teacher

With extensive experience in creating databases for the management of different areas of activity. In addition, mastery of the integration of Access with other office automation tools. The courses are dedicated to students and professionals.

Trusted teacher

Office automation plays an essential role in the management of your business or at home this court list is for you yourself to be able to practice computer and office tools like professionals from A to Z ...

Trusted teacher

EXCEL POWER POINT WORD and ACCESS are inevitable software when working with a computer. I will introduce you to this software with exercises to do by yourself, exercises accompanied by courses appropriate to your requests.

Trusted teacher

Computer development professional offers courses on: - Ms Access, all versions - MS Excel, all versions, - Programming in VBA - Assistance in the design of management tools During the day or in the evening, exclusively remotely (Teams, Google Meet, or other..)

Trusted teacher

You are a financial director or boss of your SME, a manager in a large company, or you want additional training to perfect your knowledge. If you spend more than 4 hours a day on your Excel files, if you feel overwhelmed by your next budget, if your reports lack punch, nothing is lost! Hello, My name is Yves. I have more than 25 years of business experience (of all sizes) and have worked in multiple functions (sales, purchasing, planning, supply chain, administration). Today I choose to help business professionals by accompanying them in their project and training them to become more efficient in their tasks. Excel is a fantastic and underutilized tool. I teach Excel at all levels, including VBA programming. I work on PC, but also on Mac, both FR and US version of Excel.

Trusted teacher

Microsoft Excel and Access are great tools for maintaining MIS and perform automated functions. Being an expert I would like to help learn the basics as well as perform advanced operations. For Beginners, In each class I would attempt to teach excel functions. For Advanced, In each class I would attempt to solve their daily problems or better ways to manage and represent data including use of Macros.

Trusted teacher

Whatever your level, beginner or with basic knowledge, student or employee. Excel is not intended for programmers or mathematicians, rather a MUST LEARN tool for anyone who is preparing to enter the professional world or who is already there. All it takes is willpower and discipline. I provide you with simple methods to learn Excel and use it on a daily basis. Excel structure Formula and functions. Pivot table Connection with MS ACCESS Formatting Graphs (Dynamic and static) the dashboards. VBA Macro

Trusted teacher

I have been doing online computer tutoring on topics including database programming such as Oracle Sql,SQL server,MS Access,MS Excel ,jav and HTML I have been volunteering as a computer tutor for couple of years in Schenectady county public library,New York Previously was tutoring as GED math tutor for more than 50 hours tutoring in Literary Newyork Greater capital region,New York I hold bachelors Degree in Information Technology