This tutorial will explain how to use Microsoft Access to create a working contact management (CRM) database with some basic features. Follow along using our free download of the database we created in this video: [ Ссылка ]
All you need to get started is a copy of Access and a beginner's knowledge of how it works.
Get more help and advice on Excel, Access or VBA projects:
[ Ссылка ]
If you want to find out whether a bespoke database would be right for you, get in contact:
[ Ссылка ]
Learn more about our work:
[ Ссылка ]
Please see our previous Stock Control database with Free Download:
[ Ссылка ]
---------------------------------------------
If you found this video helpful, please consider giving it a like, leaving a comment or sharing it.
More from the Software-Matters channel:
[ Ссылка ]
Visit the Software-Matters website:
[ Ссылка ]
Software-Matters is based in Gillingham, Dorset, in the south-west of the United Kingdom (UK), near Somerset, Wiltshire and Hampshire and the cities of Bournemouth, Poole, Southampton, Bristol, Bath and Salisbury.
----------------------------------------------
MORE INFORMATION:
To follow this tutorial you will need a full copy of Microsoft Access. The video was made using Access 2010, however the process is very similar in Access 2013, Access 2016, Access 2019 and Access 365 (as well as Access 2007).
We'll be going as far as setting up the database tables, which traditionally would be stored in a so-called 'back end' database file, while forms, queries and report, which are not significantly covered by this tutorial, would be stored in a separate 'front end' database file. The tables from the back end are then 'linked' to the front end, so that it behaved as if all the objects were in one file.
In some places we have made the design deliberately simple in order to keep our relationships clean and the number of tables low. This helps those new to Access to get their heads around how to create the database, but for actual use, might cause problems. We recommend that you learn more about database design from other sources before beginning your project if you intend to use it for a real business.
Key topics to consider are: database normalisation theory; Inner, Left, Right and Outer Joins; Basic SQL (structured query language) use; Software Development Methodologies; UX (user experience) enhancement techniques; and of course, the very specific needs of your business, project or client.
All together, a broad knowledge of these topics will allow you to design your tables with enough foresight to make the setting up of the queries, forms and reports you'll need later as easy as possible. Plus it should make the system easy to use and less likely to be corrupted or crash.
Keep in mind that even if your CRM database needs don't fit very well with our example contact management database, or if you need an entirely different kind of system like an accounts database, the lessons in this tutorial can still apply.
If you need a stock control database not a contact management database, then see our previous tutorial: [ Ссылка ]
0:00 Introduction
1:08 Designing your Contact Management Database
6:56 Reviewing Your Database Design
8:48 Setting Up Tables and Fields
13:30 Establishing Relationships
19:52 Creating Queries
23:26 Other Access Features
24:25 Conclusion
