Results for:
Access 2010

• 5 tips to make your Access database super-fast

  10 Jul 2012

  (Guest blogger Juan Soto is an Access MVP and founder of IT Impact, Inc . You can read more about Juan in our Q&A with him.) We've all been there. You fire up Access and load your favorite Access app only to see it drag like molasses in winter. Try these five tips to boost the speed of your database...
• Query Criteria, Part 1: Be specific!

  27 Jun 2012

  ( This post was first published in August 2011 and is the first in a series of posts about using query criteria, which includes Query Criteria Part 2: Like what? and Query Criteria Part 3: prompting for input by using a parameter .) Queries are a fundamental part of developing and using any database...
• Using crosstab queries in reports

  23 May 2012

  (Guest blogger, Molly Pell is a Senior Systems Analyst at FMS, Inc. , a leading Access applications company, which designs custom solutions to improve operations for small and large organizations in all sectors.) A well designed database stores data in a normalized format with dates defined in a field...
• Using a Combo Box to search as you type

  3 May 2012

  (Guest blogger, Molly Pell is a Senior Systems Analyst at FMS, Inc. , a leading Access applications company, which designs custom solutions to improve operations for small and large organizations in all sectors.) Here's a neat trick that you can use to filter a Continuous or Split form while your users...
• Access 2010: How to write expressions for Web queries, forms, and reports

  19 Mar 2012

  Today’s guest author is Russell Sinclair , the Program Manager for expressions, ACE, along with other features. (NOTE: Because this post explains one of the basic improvements to Access 2010, it remains very popular among Access developers. For that reason, we're republishing it so many more of...
• Q&A with Access developer Juan Soto

  17 Feb 2012

  Juan Soto founded IT Impact, Inc . (an Access development company) after working at an ice cream factory in Chicago. The factory's large Enterprise Resource Planning system required that he spend hours manually calculating whether a final batch of ice cream really made the company money. He had to factor...
• How to save your Access SharePoint password

  26 Jan 2012

  Recently, someone posted a comment on IT Impact Inc.'s blog asking how to get SharePoint to remember his password when he logged in via Access. He wanted to avoid having to log in every time. Ben Clothier, a Senior Access Developer at IT Impact, knew the answer. He wrote a detailed blog post (with plenty...
• Full-featured Access Services solution at http://www.accesshosting.com

  14 Nov 2011

  Our friends at AccessHosting.com are offering free trials of two Access "cloud" solutions. Curious? Here's the deal, from the source . Offer text provided by AccessHosting.com Reporting services for Access Web Databases in SharePoint 2010 now available - Office 365 users looking web based reporting functionality...
• Ways to use Access data in Excel

  6 Oct 2011

  When you need to use Excel to analyze data in an Access database, you have several options: you can copy and paste the data, create a data connection from Excel, or export the data to an Excel file. Your best choice depends on what you want to do. Copy/Paste If you just need some values from Access one...
• UPDATE: Using 64-bit Access 2010? You may want to wait on SP1

  8 Jul 2011

  A customer's post on TechNet brought one of my colleague's attention to an error folks are seeing after applying SP1 to 64-bit Access installations and then trying to use a wizard: The database cannot be opened because the VBA project contained in it cannot be read. ... To open the database and delete...
• Free preview of Total Visual CodeTools 2010

  7 Jul 2011

  The good folks at FMS, Inc. have kindly made the latest version of their Access/VBA development tools freely available for use until August . Whether you're writing new code, updating old projects, or taking over someone else's work, Total Visual CodeTools helps you deliver better, standardized solutions...
• Social media done easy

  13 Jun 2011

  If you think back to around Valentine's Day of this year, you might remember our post about AccessLove , a social-media-type Access web database that became very popular with Microsoft employees. As a result of that response, the creators of AccessLove decided to present a "how we did it" session to...
• Access Services and IT pros: Impressions from TechEd 2011

  26 May 2011

  Today's post is contributed by Lois Wang from the Access team. J.R. Arredondo and I had the opportunity to be at TechEd 2011 in Atlanta last week. We had two talks: a small interactive session called ”Empowering information workers with Access,” and a big-room presentation called “Managing...
• Office 2010 SP1 on track for late June

  17 May 2011

  We're on track to deliver Office 2010 SP1 in late June 2011 (here's yesterday's official announcement ). We definitely recommend this update for all Office 2010 users. There has been great work put into this service pack that further enhances the performance and security of Access. Here are a couple...
• Office 365 helps you take care of your data

  12 May 2011

  If your organization has important data stored in an older, unsupported database program, and other people in your organization need to work with that data on a regular basis, Access 2010 and Office 365 can help. By migrating your data into Access 2010, and then publishing the database to your Office...
• Streamline reporting on recurring data imports

  26 Apr 2011

  Do you often have to summarize large data sets that have been extracted from your corporate database? Access can be very helpful when you need to work with a huge stream of data. We've published a new article that shows you how to make the data easier to import, analyze, and summarize in reports, even...
• Deploy Access applications with the help of Terminal Services and RemoteApp

  20 Apr 2011

  One of the great things about Access is the variety of ways in which you can deploy a database application to a group of users. For example, if you're using Access 2010, you can publish a database to Access Services on a SharePoint server , enabling anyone with access to that server to use the database...
• Does your Access database have a disaster recovery plan?

  4 Apr 2011

  Once you get to know Access, it doesn't take long before you start putting all your important data into Access databases. Some of these databases can quickly become indispensable, especially in a business setting. At that point, it's important to have a plan in place to recover the databases in case...
• Back to the basics in Access: Reporting rapidly

  31 Mar 2011

  In the previous post , we gave many examples of how Access can really help you create a database fast and with ease. We mentioned data validation, querying, reporting, and viewing data in Excel as areas where Access is rapid and flexible. In this post I will focus on reporting. The last post mentioned...
• Back to the basics: No-code application development with Access

  29 Mar 2011

  Every now and then I have a home project for which I cannot afford (or do not want to deal with) a professional home contractor. Sometimes they are too expensive, or do not think my home project is big enough, or do not want to take the time to understand what I want to do. That is why I really like...