Go to Top
  • No products in the cart.

Blog

Insert CreatedBy and CreatedOn in any missing tables

When we design Access with SQL Server solutions we almost always add CreatedBy and CreatedOn to all of our tables, allowing our clients to see who created records in the Access frontend. Script to add CreatedBy and CreatedOn Automatically to tables Many times we inherit SQL databases and we need a quick way to add both fields to all tables in the database. To that end we use the following …Read More

Count all the objects in your database

The other day our company was tasked to convert a lot of Access databases to multiple SQL Server backends. To get a sense for the tasks involved, we needed a way to count all the tables, queries, forms and macros in each database. I did a quick Internet search but did not like any of the code snippets, so I created my own little program that will print out the …Read More

Reporting more granularly than usual

Typically, when we do reporting, we usually do it at a higher granularity. For example, clients commonly wants a monthly report of sales. The database would store the individual sales as a single record, so it’s no problem summing up the figures to the month each. Ditto with year, or even going from a sub-category to category. But suppose they need to go down? More likely, the answer will be …Read More

How to Do Test Cases and Ensure Software Quality

Software quality is an subject that has become more prominent in the software development industry over time because companies have placed more importance on offering quality products to different types of customers in the market. Nowadays software vendors place more attention on software testing and thus invests and puts more effort into planning and test cases. Test cases are nothing more than the individual parts of a test plan designed …Read More

Effective Communication Using FogBugz

Effective communication between team members is of utmost importance when it comes to achieving quality software; however, the quality of the software is almost never perfect. For this reason, it is common for clients to report errors in applications to its suppliers, expose aspects that need improvements or request the addition of new functionalities, which creates a request for the development team responsible for the project. The request is where …Read More

Free Online MS Access Tutorials in August Presented by AccessUserGroups.org

August is here! Summer is winding down, but we still have some great MS Access User Group webinars. We’re also happy to announce that we’re launching a new chapter – the Canada Access User Group. If you haven’t attended one of our webinars before, they are free webinars open to the public – from novice to professional developers – to learn from our live MS Access tutorials. At the end …Read More