 My first name is Jean-Pierre. Difficult to pronounce or very few. I have been a contributor to the office since 2012. The office is today's headmastering for your information. It's also mine. I contribute to the office, I think. As the author of the paper of Access to Base, it's library that is known as being compatible with the API or the Access. Well, compatibility for Access to Base is total session. It's fact made to make that what is today in the brain of millions of people in the world. I made a VBA in the Access API that it can be reused when making or to help them to make a step with Access to Base. Your applications, not applications arise from what they do today with Access, which will never be able to complete with Access. But they contributed something, something different, something new. It's your work of mine, that's my pleasure. That I derived from something that I did a few years ago, three years ago in the past. I had to migrate to a new format, a number of Access databases. That number was 1000 on the same site. Just to give you an idea of the success of the Access. And I needed to know what was inside that. And I started scripting something. And the ideas that I had at that time were reused in what I present today. That has been achieved in first place last month or two months ago. I call it Facebook. It is based on the extension site. It requires the growth is 6.0 and recommended 6.1. Because it uses the Access to Base library. And I put in Access to Base library the number of matches to the development of this thing. It also runs. It's always easy if you apply the Access to Base extension that is not recommended. You don't see all of them on Tesla. Okay, you find documentation on the library that is there. And it's also written basically. It's always the ID, the VBA, basic and show that the growth is also easy. What does it do? Well, it scans a base application. A base file is always an application. So it automates the thing. And a base application is always some automation. You have an application. And it scans the application. And it produces documentation. That's the ID with a focus on of course what is inside in terms of items. And mainly and also what are the links between the items. Well, in a query you mentioned there. It's important to know that that query is used in that query. But that knowledge is important and is previewed by the application. The process is the next one. So the first step is scanning the base application. It must be open. We squeeze out the name of the game to just open it. And to start the new item to say what I want this database file to be scanned. That through a dialog you can follow what happens. And everything is stored in another database file, the representation. That's the first step. And the second step, of course you can change what you want to do. But the second step is to produce documentation based on what is in the representation. Why representation? Because the tool is multi-database. It is to have all the portfolio that you have in terms of base applications as a user or as a set of tools as a company in one representation. And being able then to produce documentation, documentation produced here is in the form of html pages that imagine variance. For instance, as access proposes to the representation tool that just is not a way of doing that. It produces a work document, a new document with all the items that are in this case html pages are produced. The characteristic that a relation between two items is visible through library. So we can explain them all. If a table is used by a query, and when through this realize a query, you want to send a query to click on the table name in the query. A relation between an identity file and a tool. The bosses are now present in the current release. The orange bosses will probably be implemented in the next release. But you can see, especially that everything that is sql related, table names or links are identified. You can see that you can have, for instance, a table connected to another table. Because in your relationship I have made a relation with the number of people, in key field number three, or connected to another table behind you. And so, as you see, I went very deeply to identify what are relations in the research. Basically, it's just two tables, a database table with one entry into the database, and an objects table with one entry by object. Not many things. In fact, all the properties of an item are gathered in the properties in those tables, just along jason's screen. jason for us. That means that many, many properties. And also, in the objects table, you can see that there are uses and use by the interface to describe relations. It's important to know objects each user's object by one, two, three, etc. And we proceed to know that object is used by object each user's object. This is something we will not forget if we increase the page of what is on the side today as examples. All the database here have served to me to test totally software-based version. In fact, some of that generates the table that I've seen, only the table. The remainder of the template can store the table in the template that you define. I propose it on the side, but there is no part of the software example. And the table here, so it's a table of contents. You will see that there is one template of contents, this one, and another template for all the other things. And everything is clear. For this database here, as I said, there are some of them which are databases, in fact they are used to export the software to huge basic libraries. Because I can also do basic libraries for the basic problem. There are databases that are made by the database and that serve as examples for base handling. There is also a database that databases can make a different thing. And each database file or the refile that I've seen is very complex. You can see here that all the tables are very complex database and these birds have a lot of debug and a set of software. There are none of them to debug in the software. Just to give you an example it's not html file it's also a software generated table. The remainder is the template and I will switch the JavaScript in the template to do things. One thing is what I have to find and I have to also be able to scroll and keep the head of the database part of the template of the software. This is the table. The table is laid to the left and then used by for instance I just misused by the table because to the relationship that I have to Moscow it's on the table and I just have to click on any of them which is there. This is the table laid to the left. It's below the table and it's right. Obvious also the key and also if there are any of the tables as four of the tables if there are any of the tables you can identify them and send them or send them. You can also have a number of statistics about fees are many or no new value of them if there are no the most positive if there are days the oldest days, the most recent days so the number of items number of informations that can help to maybe realize some of the things or if you want to find out the stream the long stream is 49 characters and not your fees for example 50 maybe it's time to do something about that. About queries well I want to mention that there is an SQL beautifier and that also there so inside the SQL itself if you live here on the table name you will jump on the body to the description of that table like in this example also have SQL within the data source of the form itself also the SQL is beautified and you already identified the number of days it needs so we have details about the forms some directly have the form you can see there also have the structure control of the form stream control of the chart you have also the coordinates of things to see if not in your design you have property line of the same line of the chart and also the days when appropriate html file which is a template documentation and templates contains a number that we will substitute by what is appropriate the main document which we generate on the right place what the topics we generate as documentation typically for what is looked at you can have a vertical view of this one like it shows on the table you can also have horizontal view you can also style add styles in your your templates and in fact the html file uses many class types so that you can really design the details the examples I did not show but you can also find on the site that's a basic script about like what's the html basic html process as course also by choice that you can in fact as you see script identifies the key you can form each operator or identify in your skills you can choose specifically for order to make the special agreement and then for sqs so we see this script defines the way that this script is more removed by using a key flag to make it appear so you have also depending on the value of the product for instance to have I say something negative by use with a bold background make sense for you what we make as a general the same for html we can specify settings for each database separately and what other settings you can have the name of to give to the specific database and also the free text templates like this kind by the specific for the whole installation of each database and then you can go and say how to call a database statistic because it is costly I have really good profiles it doesn't make sense to go through all the slides to produce the statistics the returner is listed below versus what you have and what you also optionally can switch off depending on your needs you can also switch off the dependencies that you want to be similar to your address if you don't like have queries mentioned on the table you can switch it off it is kind of a form so you can also define a few things today screenshots are to be made manually stored with specific name in the right directory there is a big change automatically made screenshots or forms lots of diagrams to be done and also for basic scripts which can be linked with many things you can find in your database a bunch of forms that you can want we want two things identified the example here is one of them was basically what you see it is about which is a potential reversal for tools by doing what you find today to see all its procedures and by doing all the procedures for the motion is quite very interesting you can also do it with script by using a certain API take those parameters and you see the time for scan for the circumspect of the space like 6 minutes and a small an average rate of error is 20 seconds it is an asphalt to use basically like by this point access to various 22,000 lines of code for scanning document that is quite out this was the set and by doing this there are some invitations the test is made in a number of tests also but it is not ready for fire work but access to ways is also not ready for fire work shape which is ready to live to be able to be ready for this space the test that I need to make is I want to have also the and then security controls should not be defined there are some errors that are known 6.5 is recommended because what was not existing access to ways makes it also have really good data sources for which I am really good problems where we are not if you were not it was a master version of the game of the church and then all the evolution is potentially so I think he generated three shots that the passes should be with spiked to be able to transform ok so that is not how actually