بوطيبة يوسف قام بنشر سبتمبر 2, 2009 مشاركة قام بنشر سبتمبر 2, 2009 Starting Out with Access: Number One on your start list for comprehensive Access help: http://www.mvps.org/access/ Top Top Access Ten Commandments: Follow the wisdom and do not stray towards the Dark Side. "...fear leads to anger, anger leads to hate, hate leads to Lookup Fields." http://www.mvps.org/access/tencommandments.htm http://www.accessmvp.com/djsteele/AccessTenCommandments.html http://www.3nf-inc.com/Access10.htm Top Top Microsoft Knowledge Base Articles: Main Page for searching: http://search.support.microsoft.com/search/?adv=1 How to use the Knowledge Base: List of Access KB Articles: http://www.aadconsulting.com/kb/kbarticles.htm Top Top Netiquette for newsgroup postings: Netiquette: http://www.mvps.org/access/netiquette.htm How to ask a question: http://support.microsoft.com/kb/555375 mvp.jpg (771 bytes) Making Good Newsgroup Posts: http://dts-l.org/goodpost.htm How to ask in a newsgroup: http://www.michna.com/kb/Newsgroups.htm The Lost Art of Etiquette: http://www.clintonfitch.com/editorials/102005/lostart.asp Why and How to Crosspost: http://www.cs.tut.fi/~jkorpela/usenet/xpost.html Using the Newsgroups Effectively: http://tc2.atspace.com/0012-UsingUsenet.htm'>http://tc2.atspace.com/0012-UsingUsenet.htm Top Top Database Design 101: Understanding Normalization by Michael Hernandez: http://www.formeremortals.com/Downloads/UnderstandingNormalization.pdf Database Design Tips by Michael Hernandez: Database Design Tips.zip ACC: Database Normalization Basics Glossary of database terms: http://www.dhdursoassociates.com/database-glossary-3.html Where to find information about designing a database in Microsoft Access: "Understanding Relational Database Design" Document Available in Download Center: ACC2000: "Understanding Relational Database Design" Fundamentals of Relational Database Design: http://support.microsoft.com/?id=129519 http://www.oreilly.com/catalog/accessdata3/chapter/ch04.html Database Normalization Tips by Luke Chung http://www.fmsinc.com/tpapers/genaccess/databasenorm.html'>http://www.fmsinc.com/tpapers/genaccess/databasenorm.html Data Normalization Fundamentals by Luke Chung: http://www.fmsinc.com/tpapers/datanorm/index.html'>http://www.fmsinc.com/tpapers/datanorm/index.html Support WebCast: Database Normalization Basics http://support.microsoft.com/default.aspx?scid=/servicedesks/ webcasts/wc060600/wcblurb060600.asp Concepts Of Database Design And Management: http://www.sitepoint.com/article/database-design-management Database Design And Normalization (aimed at dBase, but still valid): http://www.jpmartel.com/bu12_c.htm Database Normalization: http://burks.bton.ac.uk/burks/foldoc/35/28.htm Introduction To Data Modeling: http://www.utexas.edu/its/windows/database/datamodeling/index.html Access Data "Clean-up" Tips: http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=182 Defining relationships between tables in a Microsoft Access database: http://support.microsoft.com/?id=304466 http://support.microsoft.com/kb/304467/ http://support.microsoft.com/kb/304468/ Database Normalization Techniques: http://databases.about.com/od/specificproducts/a/normalization.htm Introduction to Database Normalization: http://dev.mysql.com/tech-resources/articles/intro-to-normalization.html Database Normalization: http://en.wikipedia.org/wiki/Database_normalization MVP Crystal Long's Access Basics document: http://www.allenbrowne.com/casu-22.html Data Modeling 101 by George Hepworth: http://www.gpcdata.com/downloads/normalizationgpgonaccess.pdf A Little Treatise on Normalization by Access MVP Jerry Dennison: http://tinyurl.com/hczcd Fully Qualified Naming - The First Step To Normalization by Access MVP Jerry Dennison: http://tinyurl.com/frgb3 Glossary of Terms and Definitions by Access MVP Jerry Dennison: http://tinyurl.com/jow3q General Database Design Topics and Articles: http://www.databasedev.co.uk/general.html'>http://www.databasedev.co.uk/general.html Rules of Data Normalization: http://www.datamodel.org/NormalizationRules.html Normalization Rules - Beyond The Third Normal Form http://www.curlingstone.com/Normalization2.html Normalization: http://www.cs.jcu.edu.au/Subjects/cp1500/1998/Lecture_Notes/normalisation/contents.html Normalization: http://www.utexas.edu/its/windows/database/datamodeling/rm/rm7.html Advanced Normalization: http://www.utexas.edu/its/windows/database/datamodeling/rm/rm8.html Overview of Normalization: http://www.gslis.utexas.edu/~wyllys/DMPAMaterials/normover.html Normalization: http://db.grussell.org/section008.html Normalization – BCNF: http://db.grussell.org/section009.html A Simple Guide to Five Normal Forms in Relational Database Theory: http://www.bkent.net/Doc/simple5.htm Introduction to Relational Databases - Part 1: Theoretical Foundation: http://www.15seconds.com/issue/020522.htm On DK/NF Normal Form: http://www.dbdebunk.com/page/page/621935.htm Database eLearning: http://db.grussell.org/index.html ACC: General Initial Planning Phase For A New Database Part I: http://www.utteraccess.com/forums/showflat.php?Cat=&Board=68&Number=290041'>http://www.utteraccess.com/forums/showflat.php?Cat=&Board=68&Number=290041 ACC: General Planning a database – Part 2: http://www.utteraccess.com/forums/showflat.php?Cat=&Board=68&Number=309586'>http://www.utteraccess.com/forums/showflat.php?Cat=&Board=68&Number=309586 Database Design Strategies: http://www.utteraccess.com/forums/showflat.php?Cat=&Board=53&Number=130932'>http://www.utteraccess.com/forums/showflat.php?Cat=&Board=53&Number=130932 Normalizing a Database: http://www.utteraccess.com/forums/showflat.php?Cat=&Board=53&Number=343208'>http://www.utteraccess.com/forums/showflat.php?Cat=&Board=53&Number=343208 Indexes - Info and Links: http://www.utteraccess.com/forums/showflat.php?Board=8&Number=1211994'>http://www.utteraccess.com/forums/showflat.php?Board=8&Number=1211994 SQL Tutorial: http://www.1keydata.com/sql/sql.html Data Warehousing and Business Intelligence: http://www.1keydata.com/datawarehousing/datawarehouse.html Top Top Naming Conventions: http://www.xoc.net/standards/rvbanc.asp mvp.jpg (771 bytes) http://www.mvps.org/access/general/gen0012.htm http://msdn.microsoft.com/archive/default.asp?url=/archive/en-us/ dnaraccess/html/msdn_20naming.asp http://infocom.cqu.edu.au/Courses/2001/T5/COIT13143/Resources/lrnamstd.rtf http://www.granite.ab.ca/access/tablefieldnaming.htm Object Hungarian Notation Naming Conventions for VB: http://support.microsoft.com/kb/q173738/ Top Top Reserved Words: Problem names and reserved words in Access: http://allenbrowne.com/AppIssueBadWord.html Validate Names to Make Sure They Aren't VBA Keywords: http://www.trigeminal.com/codes.asp?ItemID=18#18 Special characters that you must avoid when you work with Access databases http://support.microsoft.com/?id=826763 Reserved Words in Microsoft Access http://support.microsoft.com/?id=109312 http://support.microsoft.com/?id=209187 http://support.microsoft.com/?id=286335 List of Reserved words in Jet 4.0 http://support.microsoft.com/?id=321266 http://geocities.com/jholimpo/ (Click on PDFs on the left side and select “Reserved Words”) http://tinyurl.com/ze6q8 Top Top Interface Design Topics: http://www.isii.com/ui_design.html http://www.jstreettech.com/cartgenie/pg_developerDownloads.asp (User Interface Guidelines) Official Guidelines for User Interface Developers and Designers: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnwue/html/welcome.asp'>http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnwue/html/welcome.asp http://www.databasedev.co.uk/user_interface_design.html'>http://www.databasedev.co.uk/user_interface_design.html Top Top Microsoft Database Templates: http://office.microsoft.com/en-us/results.aspx?Scope=TC&Query=database Top Top Tutorial Style: http://www.rogersaccesslibrary.com/Tutorials.html http://allenbrowne.com/casu-01.html Solutions and Orders Sample Databases: http://www.mvps.org/access/downloads/bapp2000.exe Building Microsoft Access Applications by MVP John Viescas: http://msdn.microsoft.com/office/default.aspx?pull=/library/en-us/dndbdes/html/ OfficeAccessBuildingApplicationsCh4_Book.asp Bob Larson's Tutorials and samples: http://www.btabdevelopment.com Microsoft Access 2000: Building Applications with Forms and Reports http://tinyurl.com/2szmm http://www.geekgirls.com/databasics_01.htm http://www.microsoft.com/office/previous/xp/columns/column06.asp http://www.functionx.com/access/ http://www.bcschools.net/staff/AccessHelp.htm#Top http://www.fontstuff.com/access/index.htm http://www.fgcu.edu/support/office2000/access/ http://www.oit.duke.edu/ats/training/docs/access1/ http://cisnet.baruch.cuny.edu/holowczak/classes/2200/ access/accessall.html#sec_intro https://secure.vtc.com/cd/access2003.htm http://simply-access.com/index.php?module=Website&action= Text&content=1103189759765-9716 http://www.datapigtechnologies.com/AccessMain.htm SQL Tutorial: http://www.w3schools.com/sql/default.asp Tutorial: Analyzing Data Using Access http://www.microsoft.com/education/AccessTutorial.aspx http://www.accessmonster.com/Uwe/DirCat.aspx/ Access-Directory/Tutorials http://tutorials.freeskills.com/index/category/104 List of resources that are available to help you learn Visual Basic for Applications programming: http://support.microsoft.com/?id=226118 http://www.profsr.com/home3.html Intermediate Microsoft Jet SQL for Access 2000: http://msdn.microsoft.com/library/default.asp?url=/library/ en-us/dnacc2k/html/acintsql.asp http://www.majorsoftware.com.au/Orderform.htm http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ bapp2000/html/mdbdownload.asp http://www.microsoft.com/resources/documentation/sql/7/ all/proddocs/en-us/msjet/jetch02.mspx http://databases.about.com/cs/tutorials/ http://office.microsoft.com/en-us/officeupdate/CD011124301033.aspx http://c85.cemi.rssi.ru/access/Books/A97ExSol/contents.htm Tutorial in Spanish: http://www.aulafacil.com/Access/CursoAccess/CursoAccess.htm http://office.microsoft.com/training/training.aspx?AssetID=RC061181381033&CTT =6&Origin=RP061182801033 http://www.ehow.com/how_13626_define-many-many.html Interactive Online SQL Training: http://www.sqlcourse.com/ Fundamental Microsoft Jet SQL for Access 2000: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k/html/acfundsql.asp Intermediate Microsoft Jet SQL for Access 2000: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k/html/acintsql.asp Advanced Microsoft Jet SQL for Access 2000: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k/html/acadvsql.asp Microsoft Access 2000 CD-ROM Training from AppDev: http://www.appdev.com/prodfamily.asp?catalog%5Fname=AppDevCatalog&category%5Fname=AC00Product http://www.database-design-2000.com/lesson1.htm http://customguide.com/certification/access_training_2002/mos.htm Access 2003 Courses: http://office.microsoft.com/en-us/training/CR061829401033.aspx Autonumbers - what they Are and Are Not... http://www.utteraccess.com/forums/showflat.php?Cat=&Board=53&Number=443604'>http://www.utteraccess.com/forums/showflat.php?Cat=&Board=53&Number=443604 https://www.microsoftelearning.com/eLearning/offerDetail.aspx?offerPriceId=73976 Access 2003 VBA Course: http://www.learnaccessvba.com Learn Access Now http://www.learnaccessnow.com Overview of Access: http://www.hitechcoach.com/resources.htm http://www.myaccessprogram.com/ Top Top Sample Database Models/Table Designs: http://www.databaseanswers.com/data_models/index.htm Top Top Download Samples: http://rogersaccesslibrary.com/TableOfContents3.asp http://www.datastrat.com/DataStrat2.html http://www.pointltd.com/Downloads/?p=Access http://www.accessmvp.com/KDSnell/SampleDBs.htm http://www.candace-tripp.com/pages/access_downloads.aspx http://members.shaw.ca/glenk/index.html http://www.freeaccess.de/downloads.asp (In German) http://www.weascend.com/Downloads/downloadpage.htm http://www.aleksoft.net/samples/ http://www.worksrite.com/ (Click on the News button) http://www.amazecreations.com/datafast/Download.aspx http://www.endprod.com/db.htm Newsgroup regular Fred Boer has graciously provided a fully-functioning library database that can be downloaded: http://www3.sympatico.ca/lornarourke/fred.html http://www.asken.com.au/downloads/accessdbs1.php http://www.enflow.com/Cases/SampleSoftware.htm http://www.databasedevelopment.co.uk/examples.htm Top Top MVP Stephen Leban's site: http://www.lebans.com/ Yes, Stephen's site deserves a category of its own. A couple of things I have learned from Stephen: 1. If you think something cannot be done with Access, check his site first. 2. If Stephen says it cannot be done, trust me, it cannot be done! Top Top Advanced Topics: http://www.trigeminal.com/utility.asp (Once an MVP, always an MVP in my book) http://www.mentalis.org/index2.shtml Top Top Misc: Downloads/Samples/Helpful Articles http://www.granite.ab.ca/accsmstr.htm http://allenbrowne.com.au/tips.html http://www.viescas.com http://www.accessmvp.com/SDaigle/index.htm http://www.users.bigpond.com/papwalker/ http://www.groupacg.com/ mvp.jpg (771 bytes) http://accdevel.tripod.com/ http://www.scobiz.com/Presentations.asp http://dnn.scobiz.com/ http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html http://btmtz.mvps.org/ http://tc2.atspace.com/ http://www.access.hookom.net/ http://www.jstreettech.com/cartgenie/pg_developerDownloads.asp http://home.comcast.net/~cccsolutions/accesstips.html http://www.applecore99.com/index.asp http://www.helenfeddema.com/access.htm http://www.aadconsulting.com/index.html http://ffdba.com/#downloads http://www.liquorman.net/Tips.html http://propertychampion.com/Developer_Tools/Addins/Addins.html 25 SQL Commandments: http://www.dbpd.com/vault/9801xtra.htm http://www.resources.intuidev.com/ http://www.knowhowtwo.com/Tips/access_tips.htm#Caps%20Lock%20Feature Top Top Helpful Articles/Code Samples: http://www.pacificdb.com.au/MVP/MVPCode.htm http://www.accessmvp.com/djsteele/AccessIndex.html http://www.ltcomputerdesigns.com http://accesstips.datamanagementsolutions.biz/index.htm http://vbnet.mvps.org http://brenreyn.brinkster.net mvp.jpg (771 bytes) http://www.mvp-access.com/buho/index.htm (In Spanish) mvp.jpg (771 bytes) http://www.mvp-access.com/juanmafan/ (In Spanish) http://accessvbafaq.mvps.org/ http://usuarios.lycos.es/jbchea/RptCp.htm (In Spanish) http://www.j.nurick.dial.pipex.com/Code/index.htm http://www.access.vis.pl/ (In Polish) http://www.access.qbuilt.com/ http://www.winsoft.sk/daofaq.htm http://www.calvinsmithsoftware.com/HardToFindTips.htm http://www.trevor.easynet.co.uk/AccFAQ/ http://www.theofficeexperts.com/access.htm http://www.databasedev.co.uk/ http://www.blueclaw-db.com/ms_access_examples/index.htm http://www.jamiessoftware.tk/ http://www.pdtech.co.uk/prod01.htm http://www.vbexplorer.com/VBExplorer/VBExplorer.asp http://www.heuveltop.nl/BasCB/msac_index.html http://www.vb123.com/search/toc.htm http://www.carlprothman.net/Default.aspx?tabid=100 http://www.logicielappui.com/tips/ (In French) http://c85.cemi.rssi.ru/Access/ListTips.idc?AccessID=3 (In Russian) http://www.donkarl.com/ (In German) http://www.sitocomune.com/ (In Italian) http://www.access.online.pt/ (In Portuguese) http://www.mcpegasus.net/content/faqs.htm (In Spanish) http://archive.baarns.com/software/ (Click Developer's FAQ Page) http://www.comriesoftware.net/codewidgets/browse.aspx?cat=1 http://www.tek-tips.com/faq.cfm?pid=702 http://www.hcts.net.au/tipsandtricks.htm http://www.accessfreak.net/ http://www.mantuanet.it/alessandro.baraldi/ (In Italian) http://members.cox.net/tulsaalstons/Documents/Microsoft%20Access% 20Developer%20Transition%20to%20Internet.htm. http://www.accessdatabasetips.com/ http://www.microsoft.com/accessdev/a-a&sa.htm http://custom-software.biz/Ezine.htm http://www.mile50.com/access/ http://cpcug.org/user/clemenzi/technical/Databases/MSAccess/ http://www.fabalou.com/access/access.asp http://www.amazecreations.com/datafast/article.aspx http://www.techonthenet.com/access/index.php http://www.columbia.edu/~jl2402/AccessTips.html http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dndbdes/html/ CHAPTER2AccessProtectionSecurity.asp http://www.databasejournal.com/features/msaccess/article.php/3437731 http://www.databasejournal.com/features/msaccess/article.php/3298161 http://www.nwarwick.co.uk/Access.htm Using MapPoint from Word, Access and Excel: http://www.mp2kmag.com/a39--word.access.excel.mappoint.html Tina’s Tips to Get You Going- Basic information that applies to all databases... http://home.att.net/~california.db/tips.html http://vb-helper.com/index_multimedia.html Top Top Run Command Constants: http://www.tkwickenden.clara.net/ Top Top A massive list of other Access links: http://groups.yahoo.com/group/MS_Access_Professionals/links'>http://groups.yahoo.com/group/MS_Access_Professionals/links (Have to be a member) http://www.datacomptech.com/links.html#acc http://www.access.qbuilt.com/html/links.html http://www22.brinkster.com/accessory/links.asp http://dmoz.org/Computers/Software/Databases/MS_Access/ http://www.directory-base.com/access/ http://www.cbel.com/ms_access/ http://www.aadconsulting.com/accessres.html http://www.utteraccess.com/links/'>http://www.utteraccess.com/links/ http://www.candace-tripp.com/pages/mainf.aspx# http://www.vbaexpress.com/resources.php#Access http://www.enflow.com/links.htm http://www.yaccess.com/alph.shtm Top Top Add-Ins/Utilities: "CSD Tools Database Documentation" http://www.accessmvp.com/JConrad/accessjunkie/csdtools.html "Doug Steele Object Documenter" http://www.accessmvp.com/djsteele/Documentor.html "Sandra Daigle Permissions Wizard" This is a re-write of MVP Sandra Daigle's DbUtilities which, as an Add-in, makes it easier to transfer the object permissions from a secured database to a new database container. The Zip file also includes a complete user guide which covers installation, usage and walk-through guides. Select the appropriate Zip file for whichever version of Access you are using. DBUtilitiesAddin97.zip DBUtilitiesAddin2000.zip (255 KB) (207 KB) http://www.fmsinc.com/ http://www.granite.ab.ca/access/thirdparty.htm (Big list here) http://www.appspro.com/Utilities/CodeCleaner.htm http://www.grahamwideman.com/gw/tech/access/permexpl/index.htm The ToolShed Access eBook: www.vb123.com/toolshed/ The WorkBench for Microsoft Access: www.vb123.com/workbench/ The ToolBox: http://www.vb123.com/toolbox/ http://groups.yahoo.com/group/MS_Access_Professionals/files/0_Utilities%20and%20Add-ins/'>http://groups.yahoo.com/group/MS_Access_Professionals/files/0_Utilities%20and%20Add-ins/ (Have to be a member) http://mphillipson.users.btopenworld.com/ http://www.moshannon.com/ http://www.rickworld.com http://www3.bc.sympatico.ca/starthere/findandreplace http://www.peterssoftware.com/index.htm http://www.dbi-tech.com/default.asp http://www.zada.com.au/accessaddins.htm http://www.mztools.com http://www.logico-solutions.com/ http://accesstools.narod.ru/ http://www.directory-base.com/access/index.php? inc=20&title=Add%20Ins http://www.skrol29.com/us/vaccess2.php http://www.infoplan.com.au http://www.appsplus.com/ http://www.devexpress.com/?section=/products/ActiveX/XSideBar http://www.accessmonster.com/Access-Directory/ Tools/Access-Resources.aspx http://www.databasecreations.com/devtools.htm http://www.fabalou.com/fullprograms/dbutilities.asp http://www.oaltd.co.uk/VBETools/Default.htm (Enhances References Dialog box) http://www.ammara.com/ http://www.exontrol.com/sg.jsp?content=products/excalendar http://www.ssw.com.au/SSW/Download/Download.aspx? GroupCategoryID=2ACCESS http://www.aylott.com.au/accver.htm http://www.osagecomputing.com/ http://www.prestosoft.com/ps.asp?page=edp_examdiff http://www.softwareaddins.com/ http://atroplan.com/AccMemReporter.htm http://www.compros.com.au/AS/ReadMe.html http://archive.baarns.com/software/ (Click On-Line Catalog then Access Software) http://www.submain.com/?nav=products.pcp http://www.bway.net/~dfassoc/download/Access/Reconnect.html http://www.jstarsoftware.com/index_files/ProductList.htm http://www.troisj.com/ http://www.winsite.com/bin/Info?1000000034270 http://www.cleandatasystems.com/ http://www.kliksoft.com/ http://www.bennet-tec.com/btproducts/tlist/TListScreenShots.htm http://www.accessui.com/ http://www.aislebyaisle.com/access/tools.htm http://www.mindwarp-consultancy-software.com/mdbsecure-free-trial-download.html http://www.dqwest.com/mdbartisan.htm Office Automation - Smart Indenter http://www.oaltd.co.uk/Indenter/Default.htm BMS Smart Indenter: http://www.utteraccess.com/forums/showflat.php?Cat=&Number=424894&Main=424894'>http://www.utteraccess.com/forums/showflat.php?Cat=&Number=424894&Main=424894 http://www.zexersoft.com/products.html http://www.vbaccelerator.com/home/Resources/Graphics_Library/Icons/Toolbar/Office/Access/article.asp http://www.oscorp.com/downloads.asp http://www.microtools.us/_product.aspx http://www.users.cloud9.net/~dfurman/code.htm http://www.devexpress.com/Downloads/ActiveX/XFreeLib/ Gnatt Chart Builder System: http://www.bandwood.com/gbs.htm Compare'EM Utility: http://home.gci.net/~mike-noel/CompareEM Access Auto Pilot: http://www.access-autopilot.com/ http://www.openaccess.co.za/BlackAndWhiteInc/AccessOpener.htm http://www.vbaexpress.com/cooltools.php Caller ID Software, Ms Access: http://www.yes-tele.com/access.html http://www.acc-technology.com/ http://www.kellermansoftware.com/ MDE Source Code Protector v1.02 for Microsoft® Access: http://www.everythingaccess.com/mdeprotector.htm SQL Formatter: http://www.sqlinform.com/ UI Builder for Microsoft Access http://opengatesw.com/uidownloads.aspx Headway Shortcut Builder http://www.headwaysystems.com:80/ShortcutBuilder.htm Top Top Access Chats: Live Access chats every Tuesday and Thursday: Tuesday 11am EDT - Thursday 3:30pm EDT http://community.compuserve.com/msdevapps Top Top Access User-Level Security: Security FAQ (the Security Bible): http://support.microsoft.com/?kbid=207793 Security FAQ On-line edition: http://support.microsoft.com/default.aspx?scid=%2Fsupport%2Faccess%2Fcontent%2Fsecfaq.asp Lynn Trapp's Ten Security Steps: http://www.ltcomputerdesigns.com/Security.htm Joan Wild's Tips: http://www.jmwild.com/security02.htm The Microsoft Access Security Apparatus: http://www.grahamwideman.com/gw/tech/access/accesssec/index.htm Real World Microsoft Access Protection And Security: http://www.vb123.com/toolshed/00_accvb/accesssecurity.htm Jack Macdonald's Security Document: http://www.geocities.com/jacksonmacd/AJMAccessSecurity.pdf The Security Whitepaper is also worth reading: http://support.microsoft.com/?id=148555 Keith Wilby's Instructions (See step-by-step link) http://www.keithwilby.com/ Other Good Information: http://www.access-experts.com/default.aspx?selection= TutorialSecurity&sm=18 Steps to Securing an Access Database by Using User-level Security: http://www.databasedev.co.uk/access_security.htm Other Microsoft KB articles of interest: Description of how to help protect a Access 2000 database: http://support.microsoft.com/?id=254372 Description of the role of workgroup information files in Access security: ACC97: http://support.microsoft.com/?id=303941 ACC2000: http://support.microsoft.com/?id=305541 ACC2002/2003: http://support.microsoft.com/?id=305542 Exploring Microsoft Access Security: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ dnacc2k2/html/odc_AcSecurity.asp?frame=true http://geocities.com/jholimpo/ (Click on PDFs on the left side and select “Access Security”) http://abcdataworks.com/security.htm http://www.moretools.com:80/lessons/access_security.htm Top Top Creating menu bars and tool bars: http://msdn.microsoft.com/library/default.asp?url=/archive/ en-us/dnaro97ta/html/ofcmdbar.asp http://msdn.microsoft.com/library/default.asp?url=/library/en-us /dno2k3ta/html/odc_ofcmdbarbest.asp http://www.access.qbuilt.com/html/forms.html#CustomCmdBar http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ off2000/html/achowCreateCustomMenuBarForCurrentDatabase.asp http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ off2000/html/ofdccCreateCustomMenu.asp http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ off2000/html/ofdccAddOrDeleteMenu.asp http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ off2000/html/ofhowAddCommandToMenu.asp Programming Microsoft Office Command Bars: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ dnofftalk/html/office04042002.asp http://www.jamiessoftware.tk/articles/menubars.html Top Top Access Replication: http://www.trigeminal.com/resources.asp?1033 http://www.trigeminal.com/replication/splitrep.asp?1033 How to un-replicate a database: http://www.pacificdb.com.au/MVP/Code/UnReplicate.htm Replication FAQ: http://support.microsoft.com/?id=282977 Replication White Paper: http://support.microsoft.com/?id=190766 http://www.access-experts.com/default.aspx?selection= TutorialReplication&sm=18 Jet 4.0 Replication: http://www.mvps.org/access/general/gen0033.htm TSI Synchronizer: http://www.mvps.org/access/modules/mdl0033.htm Synchronization without Replication: http://www.mvps.org/access/tables/tbl0015.htm Database Replication in Microsoft JET 4.0: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k/html/dbrepjet.asp http://geocities.com/jholimpo/ (Click on PDFs on the left side and select “Replication FAQ” and “Replication”) Sample files available here for study: http://www.utteraccess.com/forums/showflat.php?Cat=&Board=48&Number='>http://www.utteraccess.com/forums/showflat.php?Cat=&Board=48&Number= 723926&page=9&view=collapsed&sb=5&o=&fpart=1 David Fenton's Jet Replication Wiki: http://dfenton.com/DFA/Replication Top Top Additional Access Forums: http://www.mdbmakers.com/forums/ http://www.utteraccess.com http://www.access-programmers.co.uk/forums/ http://www.accessmonster.com/Uwe/ForumList.aspx http://groups.yahoo.com/group/MS_Access_Professionals/ http://www.tek-tips.com/threadminder.cfm?pid=702 http://www.everythingaccess.com/forums/ http://www.accessgroup.it/ (In Italian) http://www.officehelp.in/index/index.php/ http://groups.google.com/group/pl.comp.bazy-danych.msaccess?hl=en (In Polish) http://forums.devarticles.com/microsoft-access-development-49/ http://forums.microsoft.com/Technet/default.aspx?ForumGroupID=155&SiteID=17 Top Top Book Recommendations: http://www.developershandbook.com/ (A VERY good book to have) http://www.viescas.com/Info/books.htm (Anything written by MVP John Viescas is a keeper) http://www.fmsinc.com/toplevel/books.htm http://www.mvps.org/access/resources/books.htm Real World Microsoft Access Database Protection and Security by MVP Garry Robinson: http://www.vb123.com/map/ http://tinyurl.com/eyvr8 MVP Roger Carlson's list of recommended reading: http://www.rogersaccesslibrary.com/linksRecommededreading.html http://www.ForMereMortals.com http://www.wrox.com/WileyCDA/Section/id-105060.html http://www.bookpool.com/.x/RRRRRR/sm/1558609202 http://tinyurl.com/6j7xl http://www.oreilly.com/catalog/accessannoy/index.html http://www.awprofessional.com/title/0321245458 http://www.datapigtechnologies.com/AccessBook.htm http://safari.oreilly.com/?XmlId=1-56592-358-8&g=paidora05 http://www.mcwtech.com/Books.aspx http://www.databasedev.co.uk/reading.html Grover Park George on Access: Access 2000, Access 2002, Access 2003: http://www.amazon.com/gp/offer-listing/0972425896/ref=dp_olp_ 1/104-4187736-4625504?%5Fencoding=UTF8&condition=all http://www.programmingmsaccess.com/ Microsoft Access 2003 Forms, Reports, and Queries: http://tinyurl.com/qtur2 Automating Microsoft Access with VBA: http://www.amazon.com/gp/product/0789732440/ref=pd_rhf_f_2/104-4187736-4625504?%5Fencoding=UTF8 Programming Microsoft Office Access 2003: http://www.amazon.com/gp/product/0735619425/ref=pd_sim_b_5/104-4187736-4625504?%5Fencoding=UTF8&v=glance&n=283155 Access 2003 Programming by Example with VBA, XML, and ASP: http://www.amazon.com/gp/product/1556222238/ref=pd_sim_b_3/104-4187736-4625504?%5Fencoding=UTF8&v=glance&n=283155 Microsoft Access 2000/Visual Basic for Applications Fundamentals (Paperback): http://www.amazon.com/gp/product/0735605920/sr=8-1/qid=1151364032/ ref=pd_bbs_1/002-6087452-1377636?redirect=true&ie=UTF8 Access 2002 VBA Handbook (Paperback): http://www.amazon.com/gp/product/0782140130/ref=pd_bxgy_img_b/ 002-6087452-1377636?redirect=true&ie=UTF8 Sams Teach Yourself Microsoft Access 2002 Programming in 24 Hours (Paperback): http://www.amazon.com/gp/product/0672320983/sr=8-1/qid=1151363892/ ref=sr_1_1/002-6087452-1377636?redirect=true&ie=UTF8 Top Top Access Publications: http://www.smartaccessnewsletter.com/ME2/Audiences/default.asp http://accessvbsqladvisor.com/ http://www.intelligententerprise.com/info_centers/database/ http://www.dbmsmag.com/artindx.shtml Top Top Access BLOGS: http://alexdyb.blogspot.com/ http://vb123.blogspot.com/ http://msmvps.com/blogs/access/ http://blog.datamanagementsolutions.biz/dms.html http://pschmid.net/blog/index.php http://accessextra.blogspot.com/index.html http://blogs.msdn.com/access/ http://oakleafblog.blogspot.com/ http://blogs.msdn.com/thirdoffive/default.aspx http://blogs.msdn.com/clintcovington/ http://blogs.msdn.com/jensenh/default.aspx http://blogs.msdn.com/frice/ http://accesspro.blogspot.com/ Top Top Access User Groups/Special Interest Groups: http://www.paug.com http://www.pnwadg.org/ http://www.datadynamicsnw.com/accesssig/ http://www.DAAUG.org http://68.149.211.56:29994/ http://www.ravey.net/aug/ http://cpcug.org/user/access/ http://www.ukaug.co.uk/ http://members.tripod.com/ntaccess/ http://www.hal-pc.org/~SIG/ http://www.ssw.com.au/ssw/ http://www.arimsoft.ru/msaccess/ http://www.bostonaccessday.com/ Wellington Office User Group: http://www.woug.info/ Top Top Some of the MVP web sites: http://www.mvps.org/links.html Top Top Database Recovery: Fix Your Corrupt Access Database In 30 Minutes: http://www.vb123.com/fixaccess/ http://www.pksolutions.com/ http://www.atroplan.com/ AccessFix Software http://www.cimaware.com/accessfix.html http://www.accessdatabaserecovery.com/ http://www.msaccessrepair.com/ رابط هذا التعليق شارك More sharing options...
الردود الموصى بها
من فضلك سجل دخول لتتمكن من التعليق
ستتمكن من اضافه تعليقات بعد التسجيل
سجل دخولك الان