Sneak Peek of SharePoint 2010 and Access Services from WPC09
Wow, these video demos keep getting better and better as Day 1 of WPC09 moves along. Here is another clip of how Access is going to directly tie in with SharePoint 2010 via Access Services.
From the demo it now looks like you can create an Access form in the client application and publish that up [...]
Using form value to run a query (or report)
Access queries are a wonderful way to extract specific information out of your database. You can run the same query over and over, but if you want different information, you need to reconfigure the criteria on your query. You can create a Parameter query, which displays a dialog box prompting you for the criteria value, [...]
Access - Removing Those Pesky Duplicate Records
If you find duplicate records through a query, the next logical step is to delete them. However, the number of records to be deleted can run into the hundreds, or even more. Manual deletion of these records would be impractical because of the time involved. And you can use an Access trick to remove duplicates [...]
Access - The Easiest Way to Create a Unique List…..
in a drop-down, or combo box. Here’s the problem: You want to create a drop-down list of all current possibilities in a field. For example, you want to create a list of all the states in which you currently have customers. You don’t want a list of all 50 states. You don’t want a list [...]
Keyboard Shortcuts in MS Office
Here are some of my favorite shortcuts. If you feel like you can’t find any of your commonly used features now that you have MS Office 2007, all the keyboard shortcuts have remained the same.
Feel free to add your favorites to the list!
All of MS Office
Ctrl-Home
Move to the beginning of the file
Ctrl-EndÂ
Move to the end [...]
Access 2007 - Why Can’t I Arrange My Fields On A Form?
You’ve created an access form in Office 2007 by clicking on the Create Form button. All the fields are the same width. Now you want to make one a bit narrower. But when you select it and drag the side, all the fields get narrower. How do you change the width of one field?
When you [...]
