액세스/엑세스파워업 - 지능형vms 영상보안,Access2007 2010 2013,MySQL,MS-SQL,DATABASE 활용 VBA활용,
Home 국외사이트총정리       공개된 모든 글내용을 검색하실때
  • Home
  • 뉴스꺼리
  • 읽을꺼리
  • 추천 사이트
  • DownLoad
  • Ms Access ?
  • 개발App.소개
  • MS뉴스그룹
  • 국외사이트총정리
  • 컴퓨터활용 퀴즈
  • CCTV관련

    Latest News
    양치질 헛구역질을 하신다면?
    당뇨병환자 췌장암 발생률 2 배 췌장암 환자 50%이상 당뇨동반...
    윈도8.1 버전의 정식 출시일이 오는 10월 18일로 결정됐다
    카메라 빅5의 플래그쉽 모델들
    “비스타 가장 후회“ 스티브 발머 은퇴 심경

    최근 기사(읽을꺼리)
    -자동차 지붕위 눈 꼭치워야 하는 이유!
    -[퀴즈] 영문 F자를 찿아보세요~ 몇개?
    -그렇게 졸렸쪄요!~~
    -도메인 만료 관련 정보
    -Microsoft Access Object Model/Access 2003 엑세스 오브젝트 모델


    SourceForge.net
  • 국외 Ms Access 사이트 총정리

    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 versionsDevelopers 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.)




         
     
    :: 반짝정보 !

    Past Articles
    이전 글들을 검색하시려면 여기를 클릭하세요

    Past News
    이전 뉴스들을 검색하시려면 여기를 클릭하세요


    FreeCurrencyRates.com
    CMS as it should be - easy quick and multi platform compatible
    본 사이트에 모든로고들과 상표들은 각저작권자의 소유입니다.사이트 표현된 내용은 자신의 견해로 본 사이트의 견해와 다를수 있습니다.