4/09
Microsoft Access Small Business Solutions, published by Wiley, proves that Microsoft Access can be used to create valuable business solutions in theory and in practice by providing both the reasoning for the database design and the databases themselves in the CD that accompanies the book.
4/02
Learn how to deliver dynamic content by building a meaningful Business Intelligence Application, utilizing only what is available on the client's desktop, when a Data Warehouse BI Application, SQL Server and SSIS/SSRS aren't an option.
3/01
If you need to migrate your Access application to SQL Server, don't count on The SQL Server Upsize Wizard in Microsoft Access to automatically
convert your VBA functions. If you want to push the complex query processing done by your Access queries to the back end, you'll have to rewrite them in T-SQL.
2/10
Microsoft Access is fun,
but it is also powerful and more importantly, it has a place in the development community and in the real world of production applications. What follows are the top 10 reasons why Danny Lesandrini believes this is still true.
12/18
It's possible to treat a text file as a data table, and use the standard approaches to dealing with tables, which is a major advantage in that you can use SQL to filter the text in the file. Doug Steele shows you how.
12/07
While it's not carved in stone, you can do yourself a favor by following this list of dos and don'ts when naming tables and fields.
11/12
While it's not possible to change the behavior of the InputBox function, this article illustrates how to create your own Access form that includes a text box with its InputMask property set to Password, and then use that form instead of the one generated by the VBA InputBox function.
11/02
Creating in-memory ADO recordsets may be a solution in search of a problem, but I find the process fascinating and there's been at least one occasion where it was just the right thing for my application. Maybe it's just what you need too.
10/16
It's easy to write queries that will show data in the database that matches a criteria. However, if no data in the database matches the criteria, it becomes more difficult. This article examines two different scenarios where it's necessary to create data in order to be able to report zero values in queries.
10/05
If your users collect email addresses in a database, odds are before long, someone's going to get it into their head to send out an email "blast" or batch. There are several approaches, but what you really need is an engine to send individualized emails, one at a time...
9/18
Less well known than inner and outer joins is the Cartesian product, which produces every possible combination of records between the two tables. Doug Steele offers four examples to demonstrate some legitimate uses for Cartesian products.
9/08
Microsoft Access has always had one of the most powerful and flexible reporting engines
available to database developers. Follow along as Danny Lesandrini shows
how to expand the usefulness of your reports by leveraging the WhereCondition
property through Dynamic Where Clause generation.
8/26
Doug Steele presents a simple technique to add zip files from within your application.
8/03
Wonder what turn Access will take in Microsoft Office 2010? Danny Lesandrini explores how the new Access looks and feels, what can and can't be done with it and how steep the new learning curve is going to be.
7/16
The Access MDB format is evil and ADPs (Access Data Projects) should be used exclusively vs. there are "no advantages to an ADP." There are strong feelings on both sides of this argument, with the truth falling somewhere in-between. Read on to learn more...
Search Database Journal:
