Book Use your pdf converter to make your pdf files easy! You can now buy software that makes converting pdf to doc possible! Did you know you can even convert pdf to word? Home Page Bloglines 1906 CelebrateStadium 2006 OfficeZealot Scobleizer TechRepublic AskWoody SpyJournal Computers Software Microsoft Windows Excel FrontPage PowerPoint Outlook Word ![]() ![]() Host your Web site with PureHost! ![]() |
![]() ![]() Wednesday, February 10, 2010 – Permalink – Access CommunitiesIt takes a villageHere are some links the Access groups. Someone has probably asked your question before. Access Communities See all Topics access <Doug Klippert@ 3:52 AM
Comments:
Post a Comment
Thursday, February 04, 2010 – Permalink – Command Reference2003-2007-2010Those of you that are just now making the switch to the Ribbon world, will find this valuable.ComputerWorld.com See all Topics access <Doug Klippert@ 3:11 AM
Comments:
Post a Comment
Saturday, September 19, 2009 – Permalink – Disable ConfirmationOnly for the braveAccess tries to prevent user errors that would have calamitous effects on data or an application by throwing up confirmation boxes before potentially dangerous actions. This provides users with an out before committing irreversible changes to the database. Although you probably want these confirmation dialog boxes in place for end-users, you may find that they slow your work down too much. You may, also, click through the dialog boxes so quickly that they're essentially ineffective. If you have a programmer's version of hubris, you can prevent Access from displaying confirmation dialog boxes. To do so, choose Tools>Options from the menu bar and click on the Edit/Find tab. Then, clear the appropriate check boxes in the Confirm panel that correspond to the dialog boxes you want to suppress. Finally, click OK. In 2007, click the Office logo and then Access Options ![]() Good luck, you've been warned. See all Topics access <Doug Klippert@ 3:00 AM
Comments:
Post a Comment
Sunday, July 12, 2009 – Permalink – Plain NumbersI'd Like to Make It ClearPlain Figures is a method of transforming statistical and financial data into figures, tables and graphs that people readily understand. Have you ever:
<Doug Klippert@ 3:01 AM
Comments:
Post a Comment
Saturday, July 11, 2009 – Permalink – A Hoard of TipsGood for all levels of userAllen Browne's tips for Access users Here is a list of the sections on this site; something for everyone.
<Doug Klippert@ 3:19 AM
Comments:
Post a Comment
Wednesday, June 10, 2009 – Permalink – Automaticaly Setup a DatabaseLink in a snapWhen you're creating a new database that will link to data that isn't in an Access format, you can speed up the setup process. Rather than creating a new database and then using the File>Get External Data>Link Tables,
See all Topics access <Doug Klippert@ 3:55 AM
Comments:
Post a Comment
Thursday, June 04, 2009 – Permalink – Database ExamplesClever timesaversRoger Carlson, RogerCarlson.com, has collected a group of Access databases that demonstrate different functions. The Library includes tutorials and a good list of files that can be downloaded. See the Table of Contents
And many more See all Topics access <Doug Klippert@ 3:34 AM
Comments:
Post a Comment
Wednesday, March 25, 2009 – Permalink – Toggle Object ViewsUse the keyboardWhen you are putting a database together you often want to switch between views of Access objects to see the changes. For instance, you'll switch the view to examine a Table in Design view and then back to data view. It is can be faster to switch between views using keyboard shortcuts, rather than the View menu. You can cycle through the views of an open object using the Ctrl + . or Ctrl + , shortcut keys. These shortcuts can be used with tables, queries, forms, reports, and data access pages. See all Topics access <Doug Klippert@ 3:31 AM
Comments:
Post a Comment
Friday, February 13, 2009 – Permalink – Data ModelingData bits and piecesWhile a few of us may be guilty of constructing databases on the run, and then trying to clean up the mess later, the wise ones plan ahead.What information will you need in the future? What reports are going to be requested? If you're the bean counter, do you need to count all the legumes? "Data modeling is probably the most labor intensive and time consuming part of the development process. Why bother especially if you are pressed for time? A common response by practitioners who write on the subject is that you should no more build a database without a model than you should build a house without blueprints. University of Texas at Austin Introduction to Data Modeling Finding the Perfect Fit By Tim McLellan AgileData.org: Data Modeling 101 DataModel.org See all Topics access Labels: General, Relationships, Tables, Tutorials <Doug Klippert@ 3:47 AM
Comments:
Post a Comment
Sunday, January 18, 2009 – Permalink – NormalizationDesigning an efficient databaseHere is an understandable article about how to put together a normalized database. One topic covered is what should be used for a Primary or foreign key. "In general, a key field should have these characteristics: Here are a few of the other topic headings: Understanding Your Data
Also see: Knowledgebase #283878: Description of the database normalization basics 15seconds.com: Introduction to Relational Databases and: Normalization Model See all Topics access <Doug Klippert@ 3:54 AM
Comments:
Post a Comment
Monday, December 29, 2008 – Permalink – Drag DataSimple exchangeTo transfer data from an Access query or table in another Office program, such as Word, there's no need to manually export the data.
It works in the other direction too. Select some Excel data. Switch to Access. While viewing the Tables Objects, Paste the Excel data. It will form a new table. See all Topics access <Doug Klippert@ 3:57 AM
Comments:
Post a Comment
Thursday, December 11, 2008 – Permalink – Alphabetize by One Field or the OtherIf one is missing, use the otherLet's say you have a database that has the company name and a contacts name. In some cases the CompanyName field is empty. If that happens, you want to continue the alpha sort using the contact's LastName. To do this, you need to create an extra query field to provide the sort, using the NZ() function to replace the contents of one field for null values in another. (Nz(variant, [valueifnull])
<Doug Klippert@ 3:47 AM
Comments:
Post a Comment
Wednesday, November 26, 2008 – Permalink – Access ForumAsk your peersHere is a forum populated by Access users and developers around the world. Just a few of the recent inquiries:
Access World Forums See all Topics access <Doug Klippert@ 6:57 AM
Comments:
Post a Comment
Tuesday, November 04, 2008 – Permalink – Too Many SlicesMore data than the pie will holdA pie chart displays the per cent of the whole is represented by the component elements. Four salesmen, four slices of pie. The problem arises when there are 10 or so components that vary in size. The labels begin to overlap and the chart is difficult to read: ![]() One suggestion that Chris Weber offers is to rearrange the order of the slices: ![]() The article uses MS Graph in Access, but the techniques are applicable in all the other applications that can use graphs. SmartAccess: Easy as Pie. . . "Chris Weber provides you with a generic method to control the data for pie charts that are actually readable." (A downloadable example file is also provided See all Topics access <Doug Klippert@ 3:41 AM
Comments:
Post a Comment
Tuesday, September 02, 2008 – Permalink – Database BasicsDefinition and explanationAbout.com has information about every human endeavor. Here is a piece that introduces Access and databases in general: "If you're searching for a more flexible data management system, a database might be just the salvation you're looking for. Microsoft Access Database Fundamentals See all Topics access <Doug Klippert@ 3:02 AM
Comments:
Post a Comment
Tuesday, August 12, 2008 – Permalink – Stop Online HelpUse local HelpWhen Office 2003 first came out, one of the new features was that the help files were "live." Rather than using stale information installed years before, the application connected with Redmond for the newest and best solutions. This can be a problem depending on how you connect to the Internet. If you're using a dial up service, or speeds slow to a crawl. Here is a way to use local information.
Labels: General <Doug Klippert@ 4:00 AM
Comments:
Post a Comment
Sunday, May 11, 2008 – Permalink – Forms and SlidesForms and SlidesPowerPoint in AccessThis download provides an Access database and a PowerPoint slide show. "Create a PowerPoint slide presentation from scratch using Access data. In addition, display and control a slide show from within an Access form. Walk through the solution and explore ways to extend the sample for your own applications. Here is an MSDN article: If you have some knowledge of VBA, you can probably figure it out from the code on the Access Form. <Doug Klippert@ 6:23 AM
Comments:
Post a Comment
Tuesday, April 15, 2008 – Permalink – List Box FilterMultiple selectionsFilter a Report based on List Box Fabalou.com: "How to open a report based on a multiple selection in a list box. For example, you may have a list of makes of car and a report that shows various details for each make of car. You want to allow the users to select a range of cars and pull up the report according to that selection."
<Doug Klippert@ 5:30 AM
Comments:
Post a Comment
Saturday, March 22, 2008 – Permalink – Default SaveChoose your own locationWhen you choose to save most Office files, the Save dialog box defaults to the Documents or My Documents folder. (The following directions work in 2007, but you need to click on the Office button in the upper left corner of the Window)
Change the folder where e-mail messages and attachments are saved Also: D.C. Everest school district Weston, WI: Office Default Paths If you don't want to change the default, but would like to be able to quickly go to an alternate site, open the Save or Save Attachment dialog box. On the left side of the box is the Places Navigation bar. If you click the Desktop icon, that location will be used to save the file. You can add spots to the bar. Browse to the specific folder. Highlight the folder and click the down arrow beside the Tools option. Select "Add to My Places." The file or e-mail attachment can then be saved where you want. See all Topics access <Doug Klippert@ 7:48 AM
Comments:
Post a Comment
Saturday, March 01, 2008 – Permalink – OLAP CubesMore dimensions than Star trek
Labels: General, Relationships, Tutorials <Doug Klippert@ 7:08 AM
Comments:
Post a Comment
Monday, February 25, 2008 – Permalink – Legacy files 2007Go backRead this article closely. If you work in a situation where you need to work with legacy (pre-2007) files, it may be handy. If you do most of your work in 2007, I wouldn't bother. "When you use Windows Explorer or the desktop to create a new 2007 Microsoft Office file, a new Office file is created in an XML file format (.dox or .xlsx). For example, this behavior occurs when you right-click the desktop, you point to New, and then you click Microsoft Office Word Document. By default, files that you create in the 2007 Office system are in XML file formats. Knowledgebase 935787 See all Topics access Labels: General <Doug Klippert@ 7:52 AM
Comments:
Post a Comment
Saturday, February 02, 2008 – Permalink – Filter Multiple SelectionsTable sortsIn a table's Datasheet view, you can filter multiple selections in a few simple ways. In the first method, you select one of the fields you want to filter by and click the Filter By Selection button on the toolbar. Access filters the records by that selection. Next, select the second field you want to filter by and click the button again. Access filters the records even further by this second selection. Continue to follow these steps until you have filtered by the desired number of selections. You can also use Filter by Form. Click the icon on the toolbar. In the displayed form, enter the criteria. You can use And/Or statements, such as "Boston" Or "San Francisco". (Access will enter the quote marks for you.) For the third option, you use the Advanced Filter>Sort feature. To do so, select Records>Filter>Advanced Filter>Sort from the menu bar. Access displays a grid similar to the Query By Example grid. Now, drag down all the fields you want to filter by from the field list. Then, in the Criteria cells enter the values you want to filter for. When you have finished, click the Apply Filter button to see the results. Fourth, you could use Filter by input. Right click any entry in a field you want filtered. Enter the value in the Filter For box and hit Enter. You could then choose another field and sort again by another criteria. Creating a Query would let you save your filter, but these methods can be used to quickly display the desired information in a table. (In 2007 these options are on the Home tab in the Sort & Filter group) Florida Gulf Coast University: Sorting and Filtering eHow.com: How to Filter Records in a Microsoft Access Table Microsoft Kb: How to filter records in an Access database See all Topics access <Doug Klippert@ 7:21 AM
Comments:
Post a Comment
Saturday, January 05, 2008 – Permalink – Sandbox WarningAvoid the dark spotsAccess 2003 added another security feature - slash - PIA. Jet 4.0 has had a protective mode in the past, but Access 2003 takes it seriously.
"To help enhance the security of your data, you have the option of running Access 2003 in sandbox mode. In sandbox mode, Access evaluates only those expressions in field properties and controls that are safe. An expression is considered safe if it does not use functions or properties that could be exploited by malicious users to access drives, files, or other resources for which they do not have authorization. For example, functions such as Kill and Shell could be used to damage data and files on a computer, so they are not considered safe.
About Microsoft Jet Expression Service sandbox mode
"Unless yours is a stand-alone computer (not part of a network), and you don't ever connect to the Internet, and no one ever has physical access to your computer, or your databases and other files are protected with strong passwords, you should not even consider setting the macro security level to Low."
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines] Access 2007 sandbox 2007 has fewer warning messages. Earlier versions of Access forced you to deal with a variety of alert messages - macro security and sandbox mode, just to name two. By default, if you open an Office Access 2007 database outside of a trusted location, you see a single tool called the Message Bar. New in 2007 VB123.com: <Doug Klippert@ 4:23 AM
Comments:
Post a Comment
Thursday, December 06, 2007 – Permalink – Info DocsThings you need to knowWOPR.com has a great lounge with members who can answer most any question you can come up with. Steve Hayward prepared a couple of Access papers that contain vital information about databases. Golden Rules Normalization Doc See all Topics access <Doug Klippert@ 6:59 AM
Comments:
Post a Comment
Saturday, October 13, 2007 – Permalink – Send Access to WordReformat reportsNot everyone has Access installed on his or her machine. Access is not the most versatile instrument for complex formatting.
Labels: General <Doug Klippert@ 7:55 AM
Comments:
Post a Comment
Wednesday, October 03, 2007 – Permalink – Update Data to DefaultJust a keystroke awayYou probably know that you can set up a default value for Access to enter into a field when a new record is created. This can be done in the Design view for a table or form by setting the Default Value property. Unfortunately, you sometimes may set a default value after you've already entered records into the database. When you do so, the existing records aren't automatically updated to equal the new default. However, if you're editing a record and you want to update the field to the current default, you can do so with a keystroke shortcut. To do so, simply select the appropriate field and press [Ctrl][Alt][Spacebar] See all Topics access <Doug Klippert@ 7:59 AM
Comments:
Post a Comment
Wednesday, September 26, 2007 – Permalink – Send Your Template to MSGeek fameAccording to the Inside Office Blog, over 1 million people have downloaded free templates from Microsoft.
Upload your template See all Topics access Labels: General <Doug Klippert@ 7:11 AM
Comments:
Post a Comment
Tuesday, September 25, 2007 – Permalink – Print Raw DataFrom reports and forms
<Doug Klippert@ 8:06 AM
Comments:
Post a Comment
Monday, September 17, 2007 – Permalink – Runtime and PDFAdd-in's completeGreat news, you can now redistribute and use the PDF and XPS add-in with your Runtime solution. You may copy and distribute the object code form of the add-in listed below together and for use only with the Microsoft Office Access 2007 Runtime software, subject to the license terms accompanying the Microsoft Office Access 2007 Runtime software download: Runtime for Access 2007 See all Topics access <Doug Klippert@ 7:13 AM
Comments:
Post a Comment
Saturday, August 25, 2007 – Permalink – Zoom BoxBetter viewAccess does not provide much room to enter long expressions in queries, forms, or reports. You can drag the column wider, but there is a neater, quicker method.
<Doug Klippert@ 7:48 AM
Comments:
Post a Comment
Friday, August 10, 2007 – Permalink – Hardcopy RelationshipsDocument database
In Access 2000 thru 2003, this is easy. Simply display the Relationships window as usual and then choose File>Print Relationships from the menu bar. Doing so displays a report preview that you can then print or save.
Labels: General, Properties <Doug Klippert@ 6:32 AM
Comments:
Post a Comment
Tuesday, July 31, 2007 – Permalink – Startup Switches for AccessYour choice"This article shows you how to customize the way that Microsoft Office Access 2007 starts by adding switches and parameters to the startup command. For example, you can have Office Access 2007 open a specific file or run a specific macro when it starts." Office.Microsoft.com Also: Support.Microsoft.com VB123.com See all Topics access <Doug Klippert@ 6:28 AM
Comments:
Post a Comment
Saturday, July 21, 2007 – Permalink – Access TutorialsLearning SitesMicrosoft has created a web site for Office 2003 and 2007. Part of the site is devoted to tutorials touching on: Word, Access, Publisher , Outlook, PowerPoint, InfoPath , Excel, Visio, OneNote, FrontPage/Expression, and Project. The Access lessons are located here: 2003 Access Tutorials (You will see something different if Office 2003 or 2007 is not installed) Here are some other sites:
Access Resources <Doug Klippert@ 7:05 AM
Comments:
Post a Comment
Saturday, June 30, 2007 – Permalink – Split Access DatabaseSeparate tablesYou don't need to keep all of your data in one file. You can split your MDB file into data and application files.
In some cases you will link additional files:
In Access 2007:
<Doug Klippert@ 7:37 AM
Comments:
Post a Comment
Saturday, June 02, 2007 – Permalink – Zeros - Before and AfterNothing's a problem
Also:
<Doug Klippert@ 7:23 AM
Comments:
Post a Comment
Thursday, May 10, 2007 – Permalink – Hiding columnsIn Datasheet view
<Doug Klippert@ 6:16 AM
Comments:
Post a Comment
Sunday, April 29, 2007 – Permalink – 5 of 10 Commandments of AccessWrit on tables
Labels: General <Doug Klippert@ 7:01 AM
Comments:
Post a Comment
Thursday, March 29, 2007 – Permalink – System InformationMore than you wanted to know![]() You can check which version of the Microsoft Office program is installed on your computer, and you can determine the product ID number of your copy of the program. You can also get information about your computer. In Office 2007, using Access, Excel, PowerPoint, or Word:
In Word it's easier, just hit Ctrl + Alt + F1. See all Topics access Labels: General <Doug Klippert@ 7:25 AM
Comments:
Post a Comment
Friday, March 23, 2007 – Permalink – Access or ExcelWhen to use one or the other
Use Access or Excel to manage your data See all Topics access Labels: General <Doug Klippert@ 7:52 AM
Comments:
Post a Comment
|