July 2009 - Posts
Raymond Starkey, Director of ACCESSible IT Ltd. , provided us with an example that he has used to teach Access users about using the Partition function to create a frequency distribution. As he says, “no one ever mentions these but they are so powerful
Read More...
Today’s guest contributors are Kerry Westphal, Krunal Sheth, James Rivera, and Michael Tucker—from the macro designer feature crew. The Macro Designer is a revamped editor that allows you to automate repetitive tasks; wire together forms and reports
Read More...
The Power Tips feature of the Access Team Blog has been running for about 3.5 months now, so we thought it’d be a good time to remind everyone how the feature works. What’s a Power Tip? A Power Tip can be a code sample, some SQL, an expression, a series
Read More...
There are some great posts written about different investments across the suite of Office client products. Here is a quick guide to the group’s announcement: Access 2010—The 10,000 ft. View (my favorite) Excel 2010—The 10,000 ft. View What’s up with my
Read More...
The Office 2010 blog has a great post about send a smile (or some times a frown). Basically, you click on the Send-a-Smile (or frown) to send feedback directly to the team @ Microsoft. These actions can have an immediate impact on the product. Several
Read More...
Last week I wrote about the Office 2010 Technical Preview bevy of announcements. This post kicks off a series of conversations about what is new in Microsoft Access 2010. As a team, our passion is to help people quickly and easily create databases tailored
Read More...
Today’s guest blogger is Alison Balter. Alison is the founder of InfoTech Services Group, Inc. and has authored 14 Access books since 1995. When working in a client/server environment, it is imperative that you limit the number of rows that the user brings
Read More...
Undoubtedly, you have seen a flood of announcements coming from the Office organization today. Some of the highlights include: Office 2010, SharePoint Server 2010, Visio 2010 and Project 2010 have reached the technical preview engineering milestone. A
Read More...
This is guest post from Allie Rutherford a summer college intern on the Access team. Do you own your own business or are you in a position where you have to keep track of your customer relationships and sales leads? Have you ever wished your CRM or sales
Read More...
Mike Hnatt has generously extended to the Access blog readers a FREE version of Gladstone’s Access Report Writer . Traditionally, he has sold the developer version of the wizard for $995. The offer includes unlimited computer licenses, ability to change
Read More...
I was looking at SQM data about file size last week and ran into an interesting question. We capture the size of the file every time Access opens the file in SQM. It is interesting data as it provides insights into the size of a typical existing app.
Read More...
Today’s guest blogger is Colin Wilcox, writer for Access Training on Office Online. When you query multiple tables for data, you sometimes see a message about “ambiguous outer joins.” The message tells you to create a separate query that performs one
Read More...
There is a good article that recaps the recent O’Reilly Velocity 2009 conference on web performance and operations. I particularly liked this quote: Phil Dixon, from Shopzilla , had the most takeaway statistics about the impact of performance on the bottom
Read More...
