Microsoft Access Code Snippets and Other Useful Bits
Over the course of some years, a programmer collects useful code snippets into a library for reuse. Danny Lesandrini shares a few of his indispensable Microsoft Access code snippets, a few interesting ones and one dangerous one.
Leveraging Data Macro in Microsoft Access 2010
Finally, Microsoft Access developers have a version of table triggers at their disposal. Follow along as Danny Lesandrini walks through an example of implementing a Data Macro in Access 2010.
9 New Features in Access 2010
Read along as we count down the newest and hottest features in Microsoft Access 2010 and take a look at how they work.
Book Review: Access 2010 Programmer's Reference
Back in June we evaluated four great Access 2010 books that had just been released. There's now another volume available written especially for programmers. Danny Lesandrini peeks inside to see if this book lives up to its name.
Exploring Relational Database Theory and Practice
Microsoft Access 2010 has a collection of wizards to lead you step-by-step through each process involved in developing and using a production-grade database application. ' Exploring Relational Database Theory and Practice ' is extracted from ' Microsoft Access 2010 In Depth', published by Que.
Migrating your Access/SQL Server App to the Cloud
Have you ever wanted to share your Microsoft Access application to users outside of your LAN? Typically, this means either rewriting it as a Web application or implementing replication but the Cloud changes all that. The following article will show you simple steps to moving your Microsoft Access database to the Cloud.
A Microsoft Access Developer's Path to Dot Net
One Microsoft Access developer's search for an exit path from Access into .Net development led him to Microsoft Silverlight and MVC2. If you're serious about adding technologies to your toolkit, are looking for a web solution or just something new, Silverlight or MVC2 might be it.
Book Review: The Excel Analyst's Guide to Access
The 'Excel Analyst's Guide to Access' is especially good for Excel users who need an introductory but aggressive tutorial into the world of Microsoft Access. Read on to find out why Danny Lesandrini decided to keep this particular book in his own personal library.
Microsoft Access Small Business Solutions
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.
Microsoft Access: Business Intelligence on a Shoestring
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.
T-SQL Equivalents for Microsoft Access VBA Functions
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.
Top 10 Reasons Why Access Still Rocks for Developers
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.
Working with external text files in MS Access
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.
Extending the InputBox function for MS Access Forms
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.
Reporting what's not there
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.
Bulk-Batch Email From Microsoft Access
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...
Uses for Cartesian Products in MS Access
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.
Building a Dynamic Where Clause
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.
What's new in Access 2010
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.
Pros n Cons of ADPs
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...
Access 
Advertisement
Advertisement
Advertisement
