Access offers all sorts of possibilities to design relational databases. The tables are easily exchangeable with Excel. Can to embed the Rich Text Format and attachments and images. Who wants to deal as a layman again with Access, however, have to bring time and nerves. First, you should deal with the basics "relational database" and work towards a concrete outline for the database. For the subsequent implementation and incorporation into Access to at least to the additional purchase of a learning book hardly get around. The built-in help function can forget this fact. And in the book is not everything in it. Again and again on detailed issues and potential pitfalls for which you have to herausklauben the statements from the Internet. And if you want more, you can go from the graphical user interface quickly to deeper levels where macro and VBA programming are required. The own construction of the relations between the tables should be thoroughly thought out and tested. If the data is entered only once, is allowed to exercise in structural changes to the best care to avoid data loss. Conclusion: This software is for beginners not foolproof and allows little learning by doing. So you have to develop some knowledge in advance before you can make your own Access database for everyday use. For Access provides a huge number of solutions, some of which can only be met by professionals but.
