98.9% Of all customers recommend us, we're so confident about our results we publish all reviews and statsView Live Stats View Reviews
What Is The Database Documenter And How Is It Used?
Wed 23rd June 2010
To create a detailed report including field names, properties and relationships between tables, go to the Database Documenter and Access will present you with a list of all objects within your database. These objects are arranged in intuitive tabs so you can navigate through easily and choose exactly what you want to document. This is particularly useful if you have previously documented the database and would like to create a document to reflect the changes on one table. Select which objects you would like to document or if you are documenting everything then select the All Object Types tab and click the Select All button. There are some additional options to allow the user to document specifically what they require. Click OK and the user is automatically presented with the document in Preview mode.
This document can be exported to a range of document types. To export, right click on the document, choose Export and select the document type and location when prompted. This will provide an automatic detailed report on all objects included within the database along with other options such as the relationships set up within the tables. For a novice user of access this document is very detailed and may be considered to contain too much information, but consider the following scenarios.
The first is that something goes wrong with a table. Every other user swears blind that they have changed nothing within the database and it's your design that is the problem. You open the database and run the report and can see that the Last Updated field was today while you were at lunch which is when the problem started. You can therefore deduce that someone is telling fibs and this will help you narrow down the problem. Having printed off the new report you can quickly and easily compare it to the old original report which you saved and can see exactly what is different. Change it back and hey presto things are working again just fine!
The second scenario is when a user has created a database and needs to document the structure and tables generally. You may not be with the company forever so you need to document carefully in case you leave and somebody else takes over your job. The automatically created document can be a good starting point. You may want to add or delete information. You may want to add more text with further instructions to help people cope when you aren't there to help them, but this document will save you time in giving you a basis for the documentation.
This is particularly useful when it comes to documenting the relationships between tables as a small diagram is automatically produced including the relationship type. This will save a lot of box drawing time in whatever software package you used to use! Bear in mind that there is no table that stores the field names for a table so documenting them manually can be tedious.
The third scenario is for when databases get more complicated as the wish list grows. A developer will constantly need to make additions and alterations and sometimes it is easy to forget why something is the way it is. Sometimes things look complicated, but were created in a particular way for a reason. Using this document as a basis for you documentation means you can add notes to show exactly why something has been designed in a particular way.
Original article appears here:
Access courses in London and UK wide.
London & UK
London's widest choice in
dates, venues, and prices
On-site / Closed company:
Product Performance Engineer
Excel VBA Intro Intermediate
I have very recently completed the Excel VBA intro/intermediate course at the Limehouse training site. I thought the course was very well done. The trainer was knowledgeable, patient and interesting with his delivery (which is impressive seeing as programming would send most people to sleep!)
I was a complete beginner on Visual Basic but fairly good with excel before I started and the course was exactly what I needed to get going. The example code covered a wide range of useful things and happen to be a very good set of examples for the kind of thing I want to do with VBA.
This is my first day back in the office and I am already using VBA and actually getting things to work! Don't expect to come out of the 2 day course a pro but it is a good place to start.
The course was really useful and enlightening. Everyone got loads out of it.
BBC Studios And Post Production
Printed handouts of all exercises would be v beneficial, it was v difficult to follow the final exercise. During the day Doug tailored some parts of the course to questions that we were asking which was very beneficial to the group. We had a smaller group today which was much better and more manageable. V useful session - covered everything I was expecting and more.