Access Links

Access Links

Access General Tips and Tricks

  • Hits: 2148
    Access WIKI at Utter Access
  • Hits: 2636
    Split your Access database into data and application
    There are significant advantages to splitting your application.
  • Hits: 3196
    Allen Browne's tips for Microsoft Access
    Tips for Casual Users: If you don't know how to write code, these may help. Tips for Serious Users: Solutions for developers.
  • Hits: 2333
    Order of events for database objects

    Applies To: Access 2016 Access 2013 Access 2010 Access 2007

    A single action, such as moving from one control on an object to another control, can trigger several different events, which occur in a particular sequence. Knowing when events occur and in what order they occur is important, because it can affect how and when your macros or event procedures run. For example, if there are two event procedures that are to be run in a certain order, you want to make sure that the events that they are associated with occur in that same order.

    In this article

    Order of events for controls on forms

    Order of events for records on forms

    Order of events for forms and subforms

    Order of events for keystrokes and mouse clicks

    Order of events for reports and report sections

     

  • Hits: 2228
    Problem names and reserved words in Access
    This list, from the Database Issue Checker Utility, is a quick reference of words that may cause problems as field or table names in Microsoft Access.
  • Hits: 3759
    Jet Replication Wiki
    Jet Replication is the technology behind Microsoft Office Access's Replication feature. This Wiki is an attempt to bring together in one place all the best advice and resources on how to use Jet Replication, and to incorporate the experiences of developers who use Jet Replication regularly.
  • Hits: 2419
    CSD Tools Database Documentation
    Here is a *brief* overview of features: - Document your table structure. The tables area of the report will provide a listing of all the table fields and several properties of those fields. - Document the queries. Several properties of each query will be listed in this report. - Document the Indexes. This report will even locate possible duplicate and/or unnecessary Indexes. - Lookup Fields. This report will list all Lookup Fields in every table of the database. - Relationships. This report will list all the Relationships defined in your database. - Procedure List. This report will list each procedure name in every Form, Report, and Module in your database - Lines of Code. This report will list the total number of lines of code in each Form, Report, and Module. - Object List. This report will give a nice compact list of all the database object names. - Macro List. This report will give a listing of all the Macro objects in the database. - Forms/Reports. This report will document all of the Forms and Reports in the database. - Statistics. There are three different types of reports here. These reports will produce various statistics on your database including Object Count, Record Count, and References. - Users/Groups. These reports will produce various User and Group reports on your database that has been secured using Access User Level Security. - Permissions. These reports will document the permissions for any object(s) you select.
  • Hits: 4080
    Sharing your database

    This article is meant to provide the best practices for sharing a database with others. Incorporated into these best practices are the concepts of maximum security, future manageability, and higher degrees of scalability. Simply put, your database will be as secure as possible, as easy to modify as possible, and as easy to migrate to a larger platform when and if you ever outgrow Access.

  • Hits: 1997
    Description of database normalization basics
    This article explains database normalization terminology for beginners. A basic understanding of this terminology is helpful when discussing the design of a relational database.
  • Hits: 2069
    How to Start Access by Using the Windows Schedule Service
  • Hits: 1928
    Information about query performance in an Access database
    Microsoft KB Article ID: 209126 This article discusses how to optimize query performance in Microsoft Access 2000, in Microsoft Access 2002, and in Microsoft Office Access 2003.
  • Hits: 2518
    Microsoft's Access Team Bolg
  • Hits: 2010
    Preparing Your Access 2003 Database for Deployment, Part 1
    Summary: While planning and creating your Access application, there are decisions to make and additional options to consider when preparing for deployment. This is part one of a two-part series designed to help you prepare your database application for release. (20 printed pages)
  • Hits: 5940
    Add Trusted Location with VBA
    Access 2007 and Access 2010 use trusted locations as a security measure to help prevent users opening a database from an unknown source which could include malicious code. Typically, if you open a database that is not in a trusted location, Access will display a security message asking if you want to open the file.
  • Hits: 2012
    Access Database Design
    Some great information about database design theory, normalization, and data models.
  • Hits: 3795
    How to: Create a Shortcut Menu for a Form, Form Control, or Report

    When you're designing a form or report, you may want to provide a method for a user to easily use a command that applies only to the currect context. One way to do this is to create a custom shortcut menu and apply it to a form report, or control. The shortcut menu appears when the user right-clicks the object to which the shortcut menu is applied.

  • Hits: 5289
    How to manually split a Access database in Microsoft Access
    For various reasons, you may decide to split the database into either a front-end application or a back-end application. The back-end database contains the tables and is stored on a file server. The front-end database that links to the back-end tables contains all the forms, the queries, the reports, the macros, and the modules. The front-end database is distributed to the workstations of the users. This article describes how to split the database manually instead of by using the Database Splitter utility.
  • Hits: 1960
    Inventory Control: Quantity on Hand

    "How do I update the Quantity On Hand each time an item is sold/used?" The simple answer is: You don't! You calculate the value when you need it.

  • Hits: 2112
    Recovering from corruption
    This article may help if your database is already corrupt.
  • Hits: 3906
    Using a wan with ms-access? How fast, how far?
    By Albert D. Kallal Using a wan with ms-access. - a instant network primer.

Latest News