fbpx
Logo
Home » Posts tagged "microsoft access database design"

Tag Archives: microsoft access database design

Microsoft Access Database: How To Completely Remove A Database ?


Microsoft Access Database, like with many of the other Microsoft applications is very versatile and can be a valuable asset for businesses (of all scopes). However, unlike MS Word and MS Excel which are normally used in the workplace for the day to day and general running of the business work flow and then can be also used to support Microsoft Access at a level that complements other systems, Microsoft Access Database is the kind of application that takes office applications to the next level and can be used in various […]

Tags: , , , , , , ,

Why You Should Avoid Using Memo Fields for Grouping in MS Access ?


A memo field can store a huge quantity of information, allowing up to 65,536 characters, with different choices. In the most recent release of Microsoft access database, it can store up to 1 GB of characters and enables rich text formatting. However, it is often advised to avoid the use of memo fields for grouping in Access. Memo Fields In the 2009 edition of Microsoft access database and including the recent version, there was a bug in which the memo […]

Tags: , , , , ,

Planning Tips To Building A Microsoft Access Database


image1

In my latest eBook on how to build a Microsoft Access database, I cover a section about planning your database before developers should delve in and implement. Before they know it, it’s too late when they realise how off track they are and now left with potentially a reversing and undoing exercise! So, to get started on the right track, here’s an extract for your reference… Reverse Engineering? I’m often asked How do you design a good Microsoft Access database? […]

Tags: , , , , ,

Creating an Append Query in Microsoft Access


image6

This article talks about the importance of the  Append Query and the appropriate way of creating them in Microsoft access database. In Microsoft access database and all the other database management systems, queries as the heart of the software system which can execute numerous actions to make your database more systematized and functional. Queries prove to be useful for working on various tasks including returning record-sets in an ordered and filtered way, updating values, editing or deleting data, and even making a new table in the access database. Action Queries can be used for adding, changing, or deleting numerous records from a table, […]

Tags: , , , , , ,

Microsoft Access Database Design – Step 3 of 7


Access Courses

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: , , , , ,

Microsoft Access Database Design Concept – Step 2 of 7


MS Access Macro

This is the most important step and is the process I refer to as Reverse Engineering! The best way to build the Access database architecture correctly is start with the end result The Reports! by sketching out what reports you want to end up with. After all, database systems are there to serve and we want information please! As an exercise, if you were migrating from a paper based system or an older database system , you may want to lay […]

Tags: , , , ,

← Older posts