2017. 12. 5. 14:09
[카테고리 없음]
반응형
Ms Access Site List
국외 엑세스사이트를 정리해보았습니다.
인내심과 부지런함 가지고 계시다면 이곳에 가시면 거의 다 구하실수 있거나 많이 보았던 Source들도 눈에 보일겁니다.
영어라 문법에서 좀 딸리지만 컴터 하시는분들은 이런거 않가리죠? v^^ㆀ 대충 단어만 봐도 알듯히......
저도 이곳에서 자료많이 찿고 또 사용하고있죠. 자 한번 정말 넓고 넓은 정보의 바다를 향해 닻을 올리시죠?
| ite | Description and sub-links |
| Microsoft | Access for Developers (MSDN forum), Microsoft Answers (Office forum) |
| Utter Access | Discussion forums and wiki. |
| Access Programmers (UK) | Access discussions |
| Usenet | Requires a news reader, or use groups.google.com to search for comp.databases.ms-access |
Free Access sites
| Site | Description and sub-links |
| Microsoft | Knowledgebase. Template and sample databases. The Office Access and Access 2007 help sites (includes articles by Allen Browne) Access 2010 runtime. Access 2007 developer extensions, runtime, adding programs to 2007 deployment packages, Office 2010 developer references. Blogs by the Access Team and Clint Covington. SQL Server migration assistant for Access. |
| Access Web Page | Official site of the Microsoft Access MVPs: API, Bugs, Tables, Queries, Forms, Reports. |
| Stephen Lebans | Print PDF, Rich text and bold, Rotate text, lines/controls that grow, Mouse wheel off, Animated gif, Transparency, Save Relationship views. |
| QBuilt | Articles by Tom Wickerath and others, Gem Tips (VB Editor Options, etc), Unable to create an MDE, How-To (conversion, fixes, forms, queries, reports, security, VBA, and workarounds) |
| Tony Toews | Tips, downloads, fixes, user groups, Performance FAQ, Email FAQ, FE Updater, Runtime versions, Developers Edition fixes. |
| Jeff Conrad | Access Junkie: Database Documenter, Switchboard FAQ, Resources, Normalization links, Access 2007 info, Access 2007 Help Topics, Access 2007 FAQ |
| Access-Freak.com | Access 2007 site by Access MVP Oliver Stohr. Tutorials and blog. |
| Alex Dybenko | Tips and tricks, Access blog. |
| Doug Steele | Doug's articles for Smart Access. Extended DateDiff(), Reference problems, DSN-less connections, List fonts. |
| Graham Seach | Code such as fading forms. |
| Roger's Access Library | Sample databases from Roger and others. |
| Peters Software | Shareware, freeware, sample code. |
| John Nurick | Code for file/string handling, Regular Expressions in VBA, Perl scripts, sample to import Microsoft Works data. |
| John Viescas | Access author and MVP. Book selections, tips, downloads. |
| Arvin Meyer | Sample database solutions. |
| Hook'D on Access | Duane Hookom's sample databases, including simple calendar layouts built by setting MoveLayout to No. |
| Ken Snell | Sample databases, Excel import/export |
| Candia Computer Consulting | Al Campagna's tips and downloadable examples, e.g. "Continued" on report group headers, custom tool tips. |
| J Street Tech (Armen Stein) | Tools such as relinker for multiple back ends. Zip files for: Access and SQL Server, Security, Report selection, Tools, Data Dictionary, Converting flat files. |
| Drewslair | Microsoft Access and Visual Basic for Applications tutorials, from Andrew Comeau. |
| Trigeminal | Michael Kaplan on replication, internationalization, version conflicts, references. His blog also covers topics like What does DAO have that ADO/ADOx/JRO do not?, In case of conflict, dump the indexes!, How to get at Jet warnings that are not errors |
| Data Pig Technologies | Tutorials, demonstrating Access techniques. Uses Flash. |
| Steve Schapel | Blog and anecdotes of how Access is used in the real world. SMS and FTP from Access. |
| RVBA Naming Conventions | Naming conventions for objects and variables in Access. |
| AccessRibbon.com | How to create and manage ribbons for Access 2007, by Avenius Gunter. Also in German. |
| DB Container for Access 2007 | Database Window for Access 2007 (like previous versions), by Avenius Gunter. Also in German. |
| Asken.com | Free sample databases for Assess Tracking, Contact Management, Event Management, Expenses, Inventory Control, Ledger, Order Entry, Resource Scheduling, Service Call Management, Time and Billing. (Requires email address.) |
| MyAccessProgram | Tips and videos |
| Stuart McCall | Code and tips, downloads e.g. FTP client |
| Spell Checker (open source) | Spelling checker for Access 97, 2000 and 2007. Works with rich text, and runtime. Open Source. From PCE Soft. |
| Bob Larson | Samples and tutorials from BTAB Development. |
| Dev Hut | The Developer's Hut tips, tricks, resources. |
| Total Hero | Access tutorials |
| Other Access 2007 links | Other links for Access 2007 |
| David Fenton | JET Replication, class module to replace FileSearch object, ... |
| Tigeronomy | From John Mishefske: VBA/HTML converter, code samples, downloads to compare Access files, create wizards (A2007.) |
| Cypris’ lookout | Blog on Access and other topics, e.g. enhanced MsgBox, transparent modal dialog. |
| Regina Whipp | Access tips from Gina (MVP) |
| Andrew Plaisted | Tips and tutorials for Access 2000 and later. |
| Philipp Stiefel | German and English tips for MS Access, from Philipp Stiefel (MVP) |
Tutorials
| Site | Description and sub-links |
| FunctionX.com | Access tutorials (including Access 2007) |
| BCSchools.net | Introductory tutorials |
| Florida Gulf Coast Uni | Introductory course for Access 2007, or Access 2000 |
| Teachers on the Web | High-school student level tutorials. |
| Technology Tutorials | Basic tutorials in PDF format. |
| Access basics | 8 tutorials by Crystal (Access MVP) in PDF format. |
Access books on-line
| Title | Author | Description |
| Mastering Access 95 Development | Alison Balter | All 35 chapters. |
| Database Design Principles | Steven Roman | Chapter 4 of Access Database Design and Programming (2nd Ed) |
| Building Microsoft Access Applications | John L Viescas | Chapters 4 - 8 |
| Protecting Your Database with Startup Options | Garry Robinson | Chapter 2 of Real World Microsoft Access Database Protection and Security |
| Controlling Your Printer | Paul Litwin, Ken Getz | Chapter 10 of Microsoft Access 95 Developer's Handbook (This link is currently broken, but here's the sample database.) |
| Application Optimization | Paul Litwin, Ken Getz, Mike Gunderloy | Chapter 15 of Microsoft Access 2002 Desktop Developer's Handbook |
| Exploring a desktop database Create a database using templates Build forms using Design Tools Automate applications with macros |
John Viescas, Jeff Conrad | Excerpts from Access 2007 Inside Out |
| Hardcore Visual Basic | Bruce McKinney | VB techniques (not specifically VBA.) All 11 chapters. Link requires Java. |
| Creating Dynamic Ribbon Customizations Using Code to Add Advanced Functionality to Forms |
Rob Cooper, Michael Tucker | Excerpts from Expert Access 2007 Programming |
For understanding the query language in Access: SQL Queries for Mere Mortals by John Viescas and Michael Hernandez.
Commercial Access sites
| Site | Description and sub-links |
| EverythingAccess.com | Professional database repair service, MDE to MDB conversion, SimplyVBA global error handler, forums, tutorials e.g. avoid email security warning. |
| Access Emergency | Professional Access Recovery Services for damaged databases, with self-help. |
| FMS | White papers, tips, quality utilities, Error List. |
| Rick's Find And Replace | Add-in utility to identify/rename fields throughout the database. |
| Smart Access | Access developers newsletter, as archived by Garry Robinson. |
| Access Advisor | Developer magazine. Articles such as Bang vs. Dot |
| Superior Software for Windows | Focused on SQL Server and .NET, but includes an Access FAQ and products. |
| VB123 | Author Gary Robinson's articles on Access, security, programming, and the Access Unlimited newsletter. |
| ACG Soft | Access Design Tips and Utilities. |
| MCW Tech | Downloads for the Access Developer Handbook from Ken Getz et al. |
| K-Alliance | Microsoft Access courses. Videos (YouTube). |
Other related sites
| Site | Description and sub-links |
| Database Dev (UK) | Database design and implementation articles, tips, tricks, code samples. |
| Library of data models | Relational data structure examples for specific needs. |
| SQL Course | Tutorials in Structured Query Language (the query language in Access and other databases.) |
| VBnet | Visual Basic Developers Resource Centre. Code. Examples. FAQ. API calls. |
| Karl E Peterson's Classic VB | Visual Basic code samples. |
| Joel on Software | General software design principles and guidelines. |
| Usenet archive (Google) | Search for posts in these groups: comp.databases.ms-access or microsoft.public.access.* |
| MZTools | VBA utilities to automatically insert error handler code etc. |
Information that can be hard to find
| Topic | Description and sub-links |
| Startup options | Programmatically set the global options in Access 2000 or Access 2003. |
| Query ShowPlan | Application Optimization (MSDN, Microsoft) Use Microsoft Jet's ShowPlan to write more efficient queries (Susan Sales Harkins and Mike Gunderloy) White Paper for Jet 3.5 (Access 97) performance: v35perf |
| Updates/service packs | Service packs for Office, and JET 4. Listed separately, Office 97 and JET 3.5. |
| Wildcard characters | Access wildcard character reference |
| Solutions sample database | Download Orders and Developer Solutions |
| Order of events | Microsoft's explanation of the Order of events for database objects: controls on forms, records on forms, forms and subforms, keystrokes and clicks, reports and sections. |
Errors
| Topic | Description and sub-links |
| Dash character | Query Returns no Records with an Indexed Field That Contains Dashes |
| Solving Wizard problems | Error Message When Running Access Wizards |
| Function errors in queries | ACC2000: Cannot Use New Visual Basic for Application Functions as Expressions (Access 2000 only) |
| Can't add new record | Errors Adding Record to AutoLookup Form |
| Query fails to complete | Dual Processor Computer Hangs When Running Query (Access 97 only?) |
| Vertical text disappears | Text that is in a text box control of a report or a form may not appear correctly in Access (Workaround: use the Arial CYR font.) |
반응형