Planning tips for building Microsoft Access database
- In my recent e-book on how to create a database, I cover a section on database planning before developers develop and implement it.
- Before they know it, it is too late when they realize how far they are off track and now leave with a reverse exercise and cancel!
So, to get on track, here's a snippet to go back to...
- Reverse engineering? He often asks me how to design a good database? My simple answer, I reverse-engineer it!
- It's a technique I've used a few times and it works really well for me. The process is good
- The architecture of a database in Microsoft Access or any other database application has nothing to do with Microsoft Access or any other database application.
The methodologies I have come across over the years leave me with a lot of questions about "Are the methodologies that have often been discussed really justifying the end result?"
The amount of time and complexity of technologies in Microsoft Access database methodologies and system analysis sometimes represent a huge burden of your time and sometimes questionable theories - you might work with others and that's great!
So here's how I get started with reverse engineering...
Database planning (more for beginners) can send you to the wall! But if you spend some time preparing a to-do list of steps that will be required when you start creating a Microsoft Access database, and checking each item when you're finished, this will be a good start and will keep you focused.
But hey, even before you type one letter on this keyboard and create your first table, the next process is an exercise using pen and paper (or text editor on your computer) and there's no requirement to start Access at this point.
Remember, Access is a database management system tool that exists to serve as a tool for your operations and does not dictate how you run your business. Therefore, this article talks about your operations and how it will fit the structured Microsoft Access database.
For reverse engineering, I've devised a seven-step strategy. Database created in Microsoft Access
- In fact, the first five steps are crucial because they will ultimately identify and define the "background" database system.
- The remaining two steps deal with the "front end" database system and, in some cases, are never considered because users may just want to work with the "back end."
MS Access is a great database tool and has great built-in functionality to help you create a database and explore more.