| LeighsDatabaseTips.com | |
| Introduction A site dedicated to the practical/business application of MS Access Database features and functionality. Access databases being extremely versatile and quick to develop, are ideal for small to medium business needs. MS Access has received some bad press. This is due to very few people knowing how to create practical, sound data structures that lend themselves to all the power of Access without the over burden of academic or theoretical programming methods. Others, without the practical business experience of building solid foundations run the risk of faulty and limited functionality. My aim is to deliver a service with neither of these flaws and to educate the business arena of the true power of MS Access Databases. Enjoy. Leigh Adams (Director EBSDatabases) |
![]() About me |

| ___________________________________________________________________________ *** End of Summaries - Full Articles displayed from here How to Make Big Money With Access Database Design I have developed a Step by Step Method over the Past 30 years for designing Access Databases rapidly. My Company has grossed hundreds of 1000s of $$$ using this method. Today, more than ever before in this time of MASS DATA requirements, the HUGE market for Business Software is just waiting to be Tapped by Skilled people in the know. Using access databases with Proven Software Development techniques its easy. Businesses WANT personalization, and this is what usually takes the time. The essential Steps to Design and Build Access Databases - very Quickly are little known You can Learn them. I want to help others share the profits that can be made from this service. It may not suit everyone but it is very lucrative. If you are intelligent, keen to profit, happy to work smart - you will benefit greatly from this superb process. A recent example is of a Client you had spent many hours developing their own database, only to find it didnt do what they wanted. One of our students who had done the -Make BIG Money from Database Design- program, rebuilt the database in 3hrs and was paid $2100 for the effort....nice one. Sponsored by www.ebsdatabases.com An Access Database Client speaks up EBS provided us with a great access databasee which is aesthetically pleasing and user friendly. This placed information which was spread throughout various departments in a convenient well organized environment which allowed for the sharing of data quickly and effectively. This change to an access database has allowed department heads to focus on making critical changes which promoted growth rather then seeking information for their departments. Now with the click of a mouse we are able to analyze the information and determine where we need to spend our dollars for a better return. EBS took the time to understand what we do and create the package we needed to succeed. Thanks EBS Minister William J. Anderson Eastern Bible Institute Sponsored by www.ebsdatabases.com Contact Management Made Easy Keeping in touch with clients and customers is essential for strengthening the relationship - getting into their mind at decision time - making them feel familiar with you - the type of edge needed today. With the type of access databases (and or web based systems) doing this has never been easier. With unlimited contact points, auto-follow sms and email reminders, standardised Responses, bulk emailout features, statistics and more, an access database can be personalised to meet your exact needs. Contact me to get a quote Sponsored by www.ebsdatabases.com How to Design a Practical Access Database Step 1. DATA STRUCTURE Main Entities describe the physical items being tracked. Ie People, Products, Purchasers Fields are what this entity has one of only. Ie CompanyName, ContactName etc Related Entities describe the items being tracked that are related to your entities. Ie. Each Person may have multiple children – Children would be the sub entity of People. Each related entity’s fields are what each sub entity has one of, ie Age, Childname etc Step 2. ON SCREEN LAYOUTS Often a pictorial view is best here (Use Alt+PrtScn, then paste into a word document) Or design by hand and scan. Layout Types are either:- a. Listing: where there are multiple entries down the screen, 1 per line – useful for searching purposes. b. Details: where one entry is displayed, showing all its data – useful for data entry. Step 3. PRINTED REPORT LAYOUTS Often a pictorial view is best here (Use Alt+PrtScn, then paste into a word document) Or design by hand and scan. Similar to screens, either a listing (ie Alpha list) or a detailed view (ie Letter layout). Step 4. AUTOMATION This is where you can state where you want your database to do something for you. Ie. At 9am every day, send the emails I have flagged in the system, or after I enter a date into the DateofBirth field, I want to see the persons Age etc. Visit: www.ebsdatabases.com for more info Sponsored by www.ebsdatabases.com An Australian Makes $400/hour Designing Databases Revolutionary method for building customised software specific to client needs Learn How to here Sponsored by www.ebsdatabases.com How to Use Access Database as an Invoicing System Unlimited, automated Invoices, Quotes and Purchase Orders. A very regular business need. It can be automated, organised and streamlined very easily. One recent client, asked for complete automation, so thats what they got. Whether they are in their office or sitting on the Beach or in the highlands of the Swiss Alps, their purchase orders are delivered on time. They just have to leave on their PC. the EBS Business Automation Software design comes to the rescue. A windows based scheduled task triggers the system, it opens and collates all stock items that have fallen below their minimum level, collates the Purchase Orders for each Supplier, Emails it to them and sends an sms to the boss as confirmation (thats right, he stills wants some control). If you are wishing your system could do this, shoot me an email. Sponsored by www.ebsdatabases.com A Satistfied Client Can I just thank you for making my experience in setting up a Company Database a totally painless one! It seems that as soon as I thought of something that I needed and sent it to you, you sent right back with the solution – great! I was dreading having to set up a database, but just couldn’t cope with organising the volume of the work that I was getting in – certainly not without missing something. The program is now looking just like I want it to, even down to the colour scheme - and I know that any last minute tweaks will be dealt with immediately. Whether by Skype or email, you have been very patient and informative, and did not make me feel as if I was the class dunce, and you seemed to get right away what I was asking for. You have never complained about how many revisions I needed and have reassured me that if in the future I require more as my business needs change, I have only to send the details to you to make it happen. Before I came to you, I spent weeks (and about the same amount of money!) trying to fit a ready-made package to my needs – failed miserably!! I would not hesitate to recommend you to anyone thinking of having a totally bespoke Database. A very heartfelt THANK YOU Leigh! Michele Connell Cheer Creations Sponsored by www.ebsdatabases.com Access Database Client Saving $40,000 Our EBS Access Database has revolutionised the way we do business. With a very busy Service Company, we need information quickly, accurately and available to all our staff. EBS has delivered an access database system to do all this and more for under $4000 and the beta version was ready for viewing within a week. Further more the operating costs are only $400pa and this has allowed us to make savings of over $40,000 per year in staff costs. Prior to EBS, we had another company take 18 months and only delivered 10% of what EBS has done. Author: Mic Humberstone - Surekil Pest Control - Australia Sponsored by www.ebsdatabases.com Using a database for Tracking Inventory Multi-supplier, automated Purchase Orders, Goods Receipting, Stock Deductions at Invoice or POS, customised. Enqury: www.ebsdatabases.com Sponsored by www.ebsdatabases.com Using SMSing from Within Your Database Whether you are using a PC based MS Access database or a web based system designed by us, either way, automation is king. If you can define it - we can build it. More recently, notifying people automatically has moved to sms via mobile phone networks. As both PC and Web based EBS systems can auto send emails, sms services are available also. You do not need a connection to the mobile network, you simple subscribe to a Email-to-SMS third party service. In OZ, they usually cost between 15-22c per sms depending on your volume. The beauty is that just a simple email sent to the service provider, will delivery the content to the stated mobile number - within a second - world wide. Contact us for more info. Sponsored by www.ebsdatabases.com Customised Software for Specific Industries Currently EBS is developing specific software for niche markets in both Property Management (ie Appartments) and Job Management (ie for Service type trades ie Electricians, Plumbers, Pest Control etc). We are looking for advisros in this field to assist and hence become an integral part of this success. If you know someone interested, let give them my contact details. Sponsored by www.ebsdatabases.com Designing Your Database for Automation When you leave the design of something to someone else you risk your ideas or dreams not being realised. Same with software systems and database/ system automation. You need to be very clear when you are describing what you want. I recommend you describe the processes in reverse. ie Client pays my Invoice, System sends client invoice, Invoice Items added to Invoice, Job Recorded, Enquiry made etc. Sounds silly, but I assure you after over 30 years of dealing with business system design, all problems can be attributed back to mis-interpretation because someone guesses what comes next based upon their understanding of the end result. Please try it, I think youll like it. Cheers Sponsored by www.ebsdatabases.com How to Use Access Database as an Invoicing System Unlimited, automated Invoices, Quotes and Purchase Orders. A very regular business need. It can be automated, organised and streamlined very easily. One recent client, asked for complete automation, so thats what they got. Whether they are in their office or sitting on the Beach or in the highlands of the Swiss Alps, their purchase orders are delivered on time. They just have to leave on their PC. the EBS Business Automation Software design comes to the rescue. A windows based scheduled task triggers the system, it opens and collates all stock items that have fallen below their minimum level, collates the Purchase Orders for each Supplier, Emails it to them and sends an sms to the boss as confirmation (thats right, he stills wants some control). If you are wishing your system could do this, shoot me an email. Sponsored by www.ebsdatabases.com |