As I have preached many times and so it seems other Access database experts are of the same opinion, designing an Access database requires a plan, time and a methodical approach. I found this article which is another perspective but similar to my 7 step MS Access database plan that may be worth a read – check it out below… Create an MS Access Database – 9 Simple Steps to a Productive Database STEP 1: Define the Purpose Before you […]
Tag Archives: designing an access database
The next step is the Data Design Field for Your Microsoft Access Database. From your reports, break down into natural units that will be the foundation for your Access database design. In simplified terms, an orders database system might consist of many tables but a core process like an order transaction could be made up from five tables (as described further in this article). The Data Design (your fields) should start to get a little easier to complete this task […]
Tags: creating and planning an access database, data design field for ms access, designing an access database, how to build an access database, microsoft access database design, table and field design for access
Before you enthusiastically enter all your information into a Microsoft Access database it is wise to apply some organisation to the process. As you open the application you will see that the programme can hold vast amounts of data that can boost the efficiency of your business. The software is commonly found in offices and businesses which are seeking to keep on top of paperwork and many other tasks that require analysis and storing of data. Unlike MS Excel, you […]
Tags: access database help, access reports and forms, designing an access database, learning access database concepts, learning the concepts, mastering an access database, query objects, tables objects
Learn access database,This video from YouTube takes you from the very beginning even before working with the actual database application which is often overlooked when designing and planning an Access database. It’s a good guide to help relate how you actually would use and benefit from any database in the ‘real world’ making this a very human and user friendlier approach and best of all it’s ‘geek’ speak and jargon free!
Tags: Access 2007, Access Database, Access database tutorial, access database video tutorial, designing an access database, planning access objects, planning an access database, structure an access database