One of the strengths of Access is its ability to import and link to data from different sources. Excel does this too but with Access you can go on to query and report on the data in ways that Excel doesn’t readily provide. This can come in handy as part of an application but it’s…
All posts in Articles
Tweaking the System – Finding the most efficient application design
Efficiency is one of the overriding considerations when designing almost any kind of application. This requirement affects everything from the algorithms used to the distribution of work within the system.
Using Typed Datasets in Visual Studio
If you’ve worked with Visual Studio or .NET for long, you’re probably familiar with the System.Data.DataSet class which enables you to create a collection of data in memory, often retrieved from an SQL database. Within a dataset object, you can have a series of related DataTables that categorize the data. Moving further down, each table can…
Looking for Square Pegs: Finding a Solution and Turning it Into Code
(Previously published on AndrewComeau.com.) Introduction Programming and software development is a type of engineering. More than just sitting down and typing code, it’s about designing solutions to everyday problems using technical knowledge gained over years of training and experience. Larger projects can include a series of challenges to solve, some of which can’t be foreseen until they’re staring you…