Benefits and Drawbacks of Using Stored Procedures
Stored procedures are prepared SQL codes that you can save, allowing you to use them many times. This helps you be more productive in less time while also reducing data errors. As beneficial as stored procedures can be, there are some concerns over portability and...
read moreWorld Backup Day: How and When Should You Backup Your Database?
World Backup Day is celebrated every year on March 31st. This day is meant to educate people on the importance of backing up their files and encourage them to practice this regularly. Here at Arkware, we couldn’t agree more! We hate to see our clients lose valuable...
read moreHow Does Database Corruption Happen?
A corrupt database is a database that has lost some of its data or functionality. Seeing a corruption message is extremely concerning, especially if you don’t backup your files often. Fortunately, there are many ways to repair a database without losing valuable...
read moreMicrosoft Access – The Basics
Microsoft Access – The Basics Easy Development for Non-Developers As is typical of the many applications developed by Microsoft, MS Access has been designed to be intuitive for the user. With many in-program wizards, help screens, drag and drop features, and even...
read morePoor Practices in Database Design
A program like Microsoft Access makes it easy to build a database that is fast and optimized. You can choose from the available templates or create your own. If you use a template, all you need to do is plug in your information and voila! If your needs are more...
read moreMicrosoft Access Tips and Tricks Part 2 – Forms
In our previous blog, we highlighted some tips and tricks within Microsoft Access. In this article, we highlight some additional tips and tricks when using Access forms. The below features are available in Access 2016 and higher. Viewing a form in Layout View When...
read moreHow to Repair a Corrupted Access Database
Is your Microsoft Access database giving you problems? If your database has become corrupt, is having trouble opening or is prone to errors, rest assured that there are ways to get back on track with an efficient, reliable database. The Arkware team has extensive...
read moreCASE STUDY: ARKWARE MS ACCESS CRM
INDUSTRY: Plumbing and Septic Services LOCATION: Minneapolis, Minnesota COMPANY SIZE: 1-10 Employees KEY REQUIREMENTS: A low-cost solution encompassing Contact Management, Service Records, Custom Fields, and Centralized Data. DAN’S PLUMBING AND SEPTIC Implements...
read more7 Good Tech Habits All Employers Should Adopt
February 9th is Safer Internet Day, a day to recognize the importance of internet safety. It’s easy to take the internet for granted because it’s such an integral part of our everyday lives and embedded in almost everything we do. But it’s still important to adopt...
read moreBuilding A Microsoft Access Database
Where do I Start? A general rule for creating a database (or a database feature) is to envision the minimum solution needed to satisfy the goal. Keeping it simple applies especially to beginners. If you want to build a system for Tracking Sales Leads, don’t add in...
read more