PAUG...The Portland Oregon MS Access Database User Group
| Access 2010 |
Access Junkie |
Access FAQ, articles and even online training. A great site for information for Access 2010 and 2007. |
| Access Runtime | Microsoft's royalty-free runtime for Access 2010 | |
| Compatibility Between 32-bit and 64-bit Access | With the intro of the 64-bit version of Microsoft Office 2010, a new version of Microsoft Visual Basic for Applications (VBA), known as Microsoft Visual Basic for Applications 7.0 (VBA 7), is being released to work with both 32-bit and 64-bit apps. | |
| Microsoft Access Services 2010 Hosting | Access 2010 Tutorials and free 30 day SharePoint 2010 hosting. | |
| Microsoft Office Code Compatibility Inspector | Tool to inspect VBA code that you created in 32-bit MS Office and helps you to make any Windows Application Programming Interface (API) calls in your code compatible with the 64-bit edition of MS Office 2010. | |
| Access2007 |
Access Team Blog |
Your outlet for keeping abreast of what's taking place in the world of Microsoft® Office Access directly from the members of the Access Team. |
| Converting to Access 2007 | Microsoft Access Tips for Serious Users by Allen Browne | |
| Developer Extensions | Microsoft's Access 2007 Developer Extensions | |
| Locations of Access 2003 Commands | Where did the commands go in the new Microsoft Office Fluent user interface. | |
| MSDN | Transitioning Your Existing Access Applications to Access 2007. | |
| Ribbon Customizer | This tool will help you to customize your Database with Ribbons without writing a single line of XML code, this application will write all the code that is needed for you. The best part of this app is that it is FREE. | |
| Security Considerations and Guidance | Find out how you can use Access 2007 to protect the information in your databases. Learn about encrypting files, administering passwords, converting databases to the new ACCDB and ACCDE formats, and using other security options such as SQL Server. | |
| Code(VBA) |
4tops.com |
Add-ins and libraries for MS Access: import and export to Word and Excel, filtering, document management, data analysis and others. |
| Allen Browne, VBA Function List | Index list of the VBA code (Functions and Subs), found on site | |
| Allen Browne's Tips | Lots of tips--10 years of Usenet prowling--Beginner to Advanced | |
| Database Solutions for Microsoft Access | Database design and implementation tutorials, articles, tips, tricks, code samples, Microsoft Access Help and FAQ's and Microsoft Access database samples and examples available to download. | |
| devhut.net | Another source of well written VBA code samples | |
| Fabalou Web | Lots of solutions for Microsoft Office Products (specializing in Access) and have lots of easy to understand examples for beginners and experts alike. | |
| Gaining Access | Code samples by Patrick Wood Access MVP | |
| GPC Data Home of Smart Tools© | PAUG member George Hepworth MVP site. | |
| Granite Consulting | Tony's Microsoft Access tips, hints and links including Email FAQ and Access based accounting systems. One of the oldest Microsoft Access websites. | |
| Helen Feddema | Code samples and newsletter | |
| Hook'D on Access | Duane Hookom MS Access MVP 2001 to Present website. Many tips and samples. | |
| Importing from EXCEL Files and Workbooks | Many different code samples for importing Excel files into Access. | |
| Lebans Holdings Ltd. | Lebans efforts lie in enhancing Form, Control and Report Objects. | |
| MVP Web Sites | Directory of all of the folks who are now, or have been in the past, designated as Microsoft MVP's. | |
| Portland Visual Basic User Group | Lots of links | |
| Roger`s Access Library | Great source for demo samples of how to. | |
| SQL Formatter / SQLinForm | This will let you paste in a SQL string and it will format it to your specifications (which you can set up). | |
| The Access Web | Valuable resources from Access Guru Dev Ashish. | |
| vb123.com | There are 200+ articles, newsletters and tips to read and search. Hosted by Access developer Garry Robinson. | |
| Visual Basic Resource | A comprehensive set of tutorials, links, downloadable samples plus a chat room and message board for developers at all levels of experience. | |
| Zip file or files with the default Windows zip | If you ever need to zip on unzip files using VBA give a look here. | |
| Microsoft |
Microsoft Access fan page on Facebook |
|
| MS Knowledge Base | How to query the Microsoft Knowledge Base by using keywords and query words | |
| MS Office | Product updates, free trials, and third-party downloads | |
| MSMVPS.COM | The Ultimate Destination for Blogs by Current and Former Microsoft Most Valuable Professionals. | |
| SQL Server Migration for Access | Microsoft SQL Server Migration Assistant (SSMA) is a toolkit that dramatically cuts the effort, cost, and risk of migrating from Access to SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 and SQL Azure. | |
| Templates / Access databases | List of all Microsoft Access Template, current versions and past. | |
| Other |
Access to MSSQL |
Try free demo version, it allows you to convert five records for each database table. (Do the rest with a append query.) |
| Access to MySQL | This utility will help you move the content of an Access database into a MySQL database. You can move the data and table definitions directly or you can create dump files for later use. | |
| Easy web page capture | Save full or partial web page to file (jpeg, png or bmp) or to the clipboard. | |
| FMS Developer Help Center | Resources to help you better understand and use Microsoft Access; Strategically, Best Practices, Table Form and Report Design, VBA and much more. | |
| FMS Inc | Leading provider of developer tools and applications for the Microsoft Access. | |
| Juan Soto's Access Tips and Tricks Blog | Access Help and Tips by AccessExperts.net | |
| Leigh Purvis's www.databasedevelopment.co.uk | One of the top Access minds on the planet, has many example of different functionalities for Access MDBs | |
| Microsoft SQL Server Express Edition Download | SQL Server Express is a free edition of SQL Server ideal for developing and powering desktop, web and small server applications. | |
| MZ Tools (free) | MZ-Tools allows you to write code, find code, design your forms, document your applications, and review their quality much faster than you do it today. It saves you valuable time each and every time you use it. | |
| Smart Indenter (free) | The Smart Indenter is a utility to tidy up VBA code by rebuilding the indentation of each line. | |
| SSW Upsizing PRO! | As an Upsizing Tool, SSW Upsizing PRO! checks your database the way the `Microsoft Upsizing Wizard` should have done. After you use the generated reports, and made the recommended changes, you can upsize to SQL Server without any worries. | |
| V-Tools (free) | Tools like - Total Search, Personal Object Library, Internal Pictures, Work on Queries, Import/export Specifications, System Colors, Form Templates, Container Objects Explorer | |
| Periodicals |
AppDev |
Award-winning learning solutions for developers, IT pros and computer users. |
| Training |
BTAB Development - Free Samples / Quick Tutorials |
A great resource for quick visuals on how to do several things in Access and also several samples geared towards beginners. Bob Larson |
| Computer Training Schools | Featured Microsoft Access Schools in Oregon | |
| DataPig Technologies | Access Tutorials, Freeware and Video Downloads by Mike Alexander MVP. | |
| FreeSkills | Unlimited Access Training | |
| FunctionX Tutorials (free) | Several great tutorials on Microsoft Access 2003/2007 as well as other technologies. All training on their site is free. | |
| PCC Class Search | Portland Community College | |
| UserGroups |
Chicago Access Users Group |
CAUG is an independent group of software developers and users of Microsoft Access and related products. Our mission is to meet and share information, techniques, and ideas, the fourth Thursday of each month. |
| Denver Area Access Users Group | The Denver Area Access Users Group helps Access users (from novice to professional) get the most out of Access through sharing current methods and techniques. | |
| Oregon Computer Consultants Association | The OCCA seeks to provide a structure and forum for independent computer consultants working to share their knowledge, skills, and resources; and to promote the highest standards of professional and ethical conduct. | |
| Oregon SQL | The Oregon SQL user group provides opportunities for SQL Server developers, .NET developers, and SQL Server administrators to meet and discuss SQL Server technologies that have a focus on the needs of the development community. | |
| Seattle Access Group/PNADG | Our goal is to provide a comfortable environment where beginning to intermediate level Access developers and users can ask questions, find solutions to their problems and learn new tips and skills. |