databasedev.co.uk - database solutions and downloads for microsoft access
Microsoft Access Articles
General Microsoft Access Articles
Microsoft Access 2007 Articles
Tables
Queries
SQL
Forms
Reports
Macros
Modules & VBA
Data Models
Downloads
GUI Design
GUI Design Examples
Submit Your Examples
Resources
Resources
Database News
Knowledge Base
Microsoft Access Products, Tools & Add-In's
Online Shop
UK Visitors
US Visitors
Info
Contact Us
Advertise With Us
Link To Us
Write For Us
Competitions
Sitemap for databasedev.co.uk
Microsoft Access General Database Articles:
Microsoft Access General Articles
Planning The Database
Designing Good Databases
Normalising Your Database - First Normal Form (1NF)
Normalising Your Database - Second Normal Form (2NF)
Normalising Your Database - Third Normal Form (3NF)
Normalising Your Database - Higher Normal Forms
Naming Conventions
Database Design - Basic Steps
Simple Database Design Tips
Objectives of Good Database Design
User Interface Design Tips
Null Values Defined
Storing Unique Database Information
Relational Database Design Glossary
Relational Database Normalisation Process
Database Design Guidelines
Database Design Requirements
Database Normalization Basics
What Does NULL Mean?
When to Use Denormalization
Defining an Attribute Makeup
Microsoft Access Specifications and Limitations
What Makes a Good Primary Key?
Database Normalization Primer
A Guide To First Normal Form (1NF)
Microsoft Access Database Security - Security Overview
Access Database Security - Steps to Securing an Access Database by Using User-level Security
Access Database Repair and Recovery Software
Normalizing Your Data
Splitting a Microsoft Access Database
Repairing & Recovering a Corrupt Microsoft Access Database
Compact and Repair a Microsoft Access Database file
Naming Conventions - Hungarian Notation
Introduction to Data Modeling
Microsoft Access Development - HTML Help Generator
Microsoft Access vs. Microsoft SQL Server
Database Corruption and Prevention
Database Corruption & Repair
List of reserved words in Microsoft Access 97, 2002, 2002 and Access 2003
Benefits of Splitting Your Microsoft Access Database
Flat File Database Design vs. Relational Database Design
Data Redundancy Defined - Relational Database Design
Reasons for Converting Your .mdb Files to .mde Files
Why Compact and Repair your Microsoft Access Database?
The Jet Sandbox - Microsoft Access 2003 Security Innovations
The Jet Database Engine
Turning Good Data into Good Information
What is Microsoft Access?
Planning a Microsoft Access Database Application
Creating a Microsoft Access Application
Establishing an OleDB Connection to an Access database
Resetting a Microsoft Access 2003 AutoNumber
Converting a Microsoft Access Database to an MDE File
Validating Data in Microsoft Access
Creating Event Procedures in Microsoft Access
Convert Microsoft Access data to Microsoft SQL Server
Microsoft Access Password Recovery Tools & Downloads
Mail Merging Microsoft Access Data with a Microsoft Word Document
Combo Boxes in Microsoft Access
The SendObject Method of Microsoft Access
Convert databases from MS Access to MySQL
Select Case Statement
Date Functions in Microsoft Access
DLookup Function in Microsoft Access
Data Integrity Techniques
Using Microsoft Access Visual Basic Procedures
Convert Microsoft Access .mdb files to XML
Preventing Changes to your Access VBA Code
Microsoft Access and PHP
Using Microsoft Access with Borland Delphi
Splitting Name Fields
The Printers Collection and Printer Object
Creating a Simple Microsoft Access Add-In
Using Microsoft Access on the Web
Microsoft Access Multi-User Applications
Microsoft Access Multi-User Applications – Record Locking
Import XML Data into an Access Database
Methods for Optimizing Multi-user Microsoft Access Applications
Optimizing Multi-user Microsoft Access Applications
Working with ADO.NET [Part I]
Working with ADO.NET [Part II]
Working with ADO.NET [Part III]
Best Practices of ADO.NET
Designing and Implementing a Data Access Layer
Working with the New Data Source Controls in ASP.NET (Part I)
Working with the New Data Source Controls in ASP.NET (Part II)
Understanding ADO.NET Entity Framework
Database recovery - how to repair a Microsoft Access file
Creating Hyperlinks With Microsoft Access
Using the DoCmd object
Introducing the Microsoft Sync Framework
Exporting a table from Microsoft Access to EnterpriseDB
Why And How To Create A Many-To-Many Relationship
Microsoft Access ADO vs. DAO
Creating An Audit Trail In Microsoft Access
What's New in Microsoft Access 2010
What's New in Microsoft Access 2010 - part 2
What’s New For Access 2010’s Ribbon
Backup and Restore Process In Microsoft Access 2010
MySQL Workbench For Database Migration
Microsoft Access 2007 Articles and Tutorials:
Microsoft Access 2007: The latest articles, tutorials and topics on Microsoft Access 2007
Your Guide to the Benefits of Microsoft Access 2007
The Powerful New Features of Microsoft Access 2007
Information Sharing is a Key Feature of the New Access 2007
Access 2007 Makes Working With Data Easier
Four Things to Love About Microsoft Access 2007
Microsoft Access 2007 – Which File Format is Right for Me?
Understanding the Field and File Formats of Access 2007
Understanding the New Features of Microsoft Access 2007
Access 2007 Security Options
Importing and Linking Data from a Text File in Access 2007
The Power of Import Specifications in Access 2007
Access 2007 - Understanding the Changes
Access 2007 Decisions – Factors to Consider Before the Upgrade
Access 2007 – Deciding Whether to Change Database Formats
Microsoft Access 2007 Installation
Microsoft Access 2007 - Table Field Data Types
Security Considerations and Guidance for Access 2007
Displaying the Classic Microsoft Access Menu and the New Ribbon in Microsoft Access 2007
Creating Alternate Row Colours in a Microsoft Access 2007 Report
Converting an Access Database to ACCDE File Format
Automate Applications with Macros in Access 2007
Understanding and working with Microsoft Access 2007 Projects
Guide to multivalued fields in Access 2007
Customize the Ribbon in Microsoft Access 2007
Attachment feature in Microsoft Office Access 2007
Export Access 2007 Data to XML Format
Import XML Data into a Microsoft Access 2007 Database
Create and use subreports in Microsoft Access 2007
Counting in a Microsoft Access 2007 Report
Summing in a Microsoft Access 2007 Report
Creating a Mail Merge from Microsoft Access 2007 Data
Backing up a Microsoft Access 2007 Database
Collect data by using e-mail messages in Microsoft Access 2007
Access 2007 Pure SQL
Microsoft Access Database Table Articles:
Microsoft Access Table Articles
Good Table Designs
Resetting an Access Counter (AutoNumber) Field
Adding a prefix to an Access AutoNumber Field
Primary Keys
Tables & Fields
Table Performance Tips
Selecting Primary Key Fields
Identifying Table Relationships
Managing Many-To-Many Relationships
Referential Integrity
Using an Append Query to set the initial value of an AutoNumber Field
Example of Many-To-Many Relationships
Working with Fields & Datatypes
Primary and Foreign Keys
What is a Key and How should I choose one?
Primary and Foreign key constraints are and what they are used for
Do I need a Primary Key and what happens if I don't define one ?
Domain Integrity
Entity Integrity
Avoid multiple fields that contain similar data in Access
A Natural Key vs. a Meaningful Key
AutoNumber Data Type
Too Many Fields Defined in a Microsoft Access Database Table
Descriptive and Meaningful Field Names in your Database Design
Enforce Referential Integrity
Data Integrity - Relational Database Design
Table Level (Entity) Integrity - Relational Database Design
Creating a new table using an Excel file
Auto Numbering In Microsoft Access
Benefits of a Primary Key
A Naming Scheme for Database Tables and Fields
Microsoft Access Query Articles:
Microsoft Access Query Articles
Query Basics
Creating a Progress Meter
How to return all records when a parameter is left blank
Planning for Null responses in your parameter queries
Selecting birthdays in the next 30 days
Using an Append Query to set the initial value of an AutoNumber Field
Filtering the results of a query using a Drop-Down combo box
Optimizing Query Performance
A handy tip on Concatenation
Using a Microsoft Access Listbox to pass criteria to a query
Easily retrieve data for the Current Month or Year
Splitting a Single Field into Multiple Fields
Suppress Microsoft Access Action Query Warning Messages
Query Day from Date
Query a Date Field to Return all records within a month period
Show only records from the last 'x' months
Using the MAX() function in Microsoft Access
Calculating future Dates using the DateAdd function
IIF Function use in Microsoft Access
Creating a Self-Join Query to relate data within a table in Microsoft Access
Multiple Table Queries
Query Joins - Inner & Outer Joins
Creating Action Queries - Update, Append and Delete Queries
Creating an Append Query in Microsoft Access
Creating a Delete Query in Microsoft Access
Creating Crosstab Queries in Microsoft Access
How to create a Microsoft Access Append query with criteria
Microsoft Access and Boolean Operators
Microsoft Access Query Types: Select, Action, Parameter and Aggregate
Aggregate Functions in SQL and Microsoft Access
Using an Update Query to Convert Text to Proper Case
Creating Microsoft Access Parameter Queries
Use of the Where Clause in Microsoft Access
Microsoft Access Query to display Birthdays for the Current Month
Find Duplicates Query Wizard
Create a New Table using a Make-Table Query
Updating Records in Microsoft Access with an Update Query
Sorting database entries beginning with 'The'
Creating Microsoft Access Queries using the Query Wizards
Using a Query to display Random Records
Using the DatePart Function in a Microsoft Access Query
Creating Queries using QueryDef
Comparing Records In Microsoft Access
Microsoft Access SQL Articles:
Microsoft Access SQL Articles
What is SQL?
The Basics of SQL - Structured Query Language
The SQL Select Statement
Why Use SQL?
Aggregate Functions of SQL For Beginners
Data Manipulation Language Commands - INSERTing Data using SQL
Data Manipulation Language Commands - DELETE and UPDATE Data using SQL
Creating Union Queries
Eliminating Duplicates with SQL SELECT DISTINCT
Using the WHERE clause with the SQL SELECT Statement
Multiple Conditions using the SQL AND and OR conditions
Using SQL in Access: Changes in Data Groups
Logical Operators in Access SQL
The DELETE Operand in SQL for MS ACCESS
SQL GROUP BY Clause
SQL IN/BETWEEN Condition
Using the WHERE clause in SQL
SQL Subqueries
SQL Count Function
SQL Queries in Microsoft Access
SQL - Using GROUP BY with HAVING
Using String Functions in your Access SQL Queries
Conditional Concatenation with the iif() function
SQL Recovery Tool: Testing Its Functionality
Microsoft Access Forms :
Microsoft Access Forms
Adding a working clock to your forms
Add a Welcome User message to your database
Adding a security password to a command button on your form
How to include a Bound Picture on your forms
Hiding Microsoft Access Forms
Making a Flashing Label or Text Box
Printing a single record from your form into your report
Adding a Macromedia™ Flash Movie to a start-up form
How to open Microsoft Word documents from an Access form
How to create a Login Form
How to create a simple text search facility
How to create a Start-Up Form
Create a Splash Screen to replace the default Access Splash Screen
Sending E-Mails From Microsoft Access
Generating a List from Microsoft Access System Table
Filter one combobox based on another combobox selection
Automatically Increment a Fields Value
Controlling when Scroll Bars are displayed on a SubForm
Searching Records using a Microsoft Access List Box
Sorting Columns in a Microsoft Access Listbox
Filter to only view Current User's Records in a form or query
Viewing a Live Web Site on a Microsoft Access Form
Using an Option Group to Filter Records Displayed in a Form
Undo changes made to current record
Checkboxes and using the Triple State Property
Counting Used Characters in a Text Field
Spell Checking in an Access Form
Conditional Formatting and Continuous Forms
How to use the Not In List event of a combo box
Automatically display an Access combobox list
Creating Custom Command Buttons
How to Clear a Multi-Select Listbox
Preventing Duplicate Records from being entered via a form
Popping Up Reminders in Microsoft Access
Display Welcome Message at database Start-Up
Automating Archiving Records in Microsoft Access, using Append and Delete Queries
Showing or Hiding Microsoft Access Subforms
Record Counter, Record X of Y, using custom form navigation in Microsoft Access
Sending E-Mails from a Microsoft Access Form
Switchboard Forms in Microsoft Access
Confirm Changes using the Before Update Event
Validate A Forms Textbox To Ensure Only Text Is Entered
Replacing a Standard Microsoft Access Error Message with a Custom Error Message
Using a Microsoft Access Combo Box to Search for a Record
Validating Missing Data by Responding to Data Entry Events
Conditionally Formatting Microsoft Access Form Data
Displaying an Image in a Microsoft Access Form
Displaying Subform Totals in a Main Form in Microsoft Access
Protect Form Data from Being Accidentally Changed
Using the Combo Box's NotInList event with multiple fields
Creating a Microsoft Access Splash Screen
Moving the Cursor To The End Of A Microsoft Access Textbox
Passing Multiple Parameters to a Microsoft Access Form
Password Protecting A Microsoft Access Tab Control
Unbound Forms in Microsoft Access
Adding Data with Unbound Forms in Microsoft Access
Editing Data with Unbound Forms in Microsoft Access
A Standard Set of Form Navigation Buttons In Microsoft Access 2010
Microsoft Access Report Articles:
Microsoft Access Report Articles
Printing parameters on to your report
Including Bound Images on the report
Alternate row colors on reports with Microsoft Access
Sorting Report Fields on the Fly
Create a Border around Report Page
Conditionally Format Report Rows
Add the database name to a report in Access
Print multiple copies of a report in Microsoft Access
Printing the Record on the Form to a Report
Counting field values in a Database Report using the Count and IIF expressions
Date Parameters for generating Microsoft Access Reports
Creating a Multiple-Column Report in Microsoft Access
Previewing a Microsoft Access report sized using acCmdZoom
Creating Mailing Labels in Microsoft Access
Grouping Data in a Microsoft Access Report
Alternating Report Group Colours in a Microsoft Access Report
Printing Two Records Per Page on a Microsoft Access Report
Microsoft Access Macro Articles:
Microsoft Access Macro Articles
Macros: Tricks and Tips
Showing a Please Wait action message
Microsoft Access Macros vs. VBA - Why Use Macros?
How to Create a Microsoft Access Macro to Import Information from a Text (.txt) File
How To Create a Microsoft Access Macro to Export Information to Excel or Word
How To Create a Microsoft Access Macro that Opens/Runs a Query
How to Create a Microsoft Access Macro that will link Tables to External Databases
What Are Macros and Why Would You Use Them?
Types of Macros in Microsoft Access
Require Data Entry with a Macro
Using Macros to Automate Data Entry
Cancel Printing of a Blank Report
AutoExec Macro in Microsoft Access
Microsoft Access Module and VBA Articles:
Module and Access VBA Articles
Capturing the Network User Name
Creating a Progress Meter
How to Disable/Enable the Shift Bypass Key
How to use the Common Dialog API in an Access Database
Convert Text to Proper Case or Upper Case
How to list All tables contained in a Database
Requiring Data Entry into Form Fields
Recover a Deleted Database Table
Stop mouse wheel from scrolling through records in a Microsoft Access form
Get UserName of User logged into the network or retrieve the current ComputerName
Preventing Numeric Data from being entered into a Text field
Validating Required Data in Microsoft Access Text boxes
Exporting Data from Microsoft Access with VBA Code
Importing Data into Microsoft Access using VBA
Input validation with VBA
Using Text Files with Microsoft Access
Control Structures in VBA
Prompt For Saving a Record in VBA
Calculating Working Days in Microsoft Access
Error Handling In Microsoft Access
Microsoft Access Database User Interface Design Articles:
User Interface Designs
User Interface Design Submissions
Student/Course Logging Database Example
Book Collection Database Example
Football/Soccer Fixture Database
Stock & Performance Management Of The IT Department
Personal Organiser Database
Aquarium Management Database System
Point of Sale Software
In-House Inventory Tracking
Job Estimation Database
Student Base v1
Microsoft Access Data Models
Database Design Data Models
Data Model for Book Collection
Data Model for Employees and Projects
Data Model for Customer Product Orders
Data Model for Video Rentals Store
Data Model for Holiday Cottage Bookings
Data Model for Fishing Lakes and Members
Data Model for Motor Vehicle Insurance Policy Management
Data Model for Golf Clubs and Membership Handicaps
Data Model for Personal Contacts and Addresses
Data Model for Vehicle Details and Information
Data Model for Football or Soccer Team Players and Fixtures
Data Model for Students, Courses and Tutors
Data Model for Employees and Qualifications
Data Model for Hotel Room Booking System
Nursery/Childs Playgroup Scenario
Data Model for a DVD Collection Scenario
Microsoft Access Database Downloads and Samples:
Microsoft Access Downloads and Samples
Example of Many-To-Many Relationships
Example of creating a Login Form
How to create a simple text search facility
Example of creating a Start-Up Form
Example of using the Common Dialog API in an Access Database
Example of opening Microsoft Word documents from an Access Database
Where can I see some sample forms/reports/queries etc?
Filtering the results of a query using a Drop-Down combo box
Sending E-Mails From Microsoft Access
Generating a List from Microsoft Access System Table
Filter one combobox based on another combobox selection
Automatically Increment a Fields Value
Using a Microsoft Access Listbox to pass criteria to a query
Searching Records using a Microsoft Access List Box
Sorting Columns in a Microsoft Access Listbox
Filter to only view Current User's Records in a form or query
Viewing a Live Web Site on a Microsoft Access Form
Using an Option Group to Filter Records Displayed in a Form
Sorting Report Fields on the Fly
Checkboxes and using the Triple State Property
How to use the Not In List event of a combo box
Preventing Duplicate Records from being entered via a form
Popping Up Reminders in Microsoft Access
Stop mouse wheel from scrolling through records in a Microsoft Access form
Printing the Record on the Form to a Report
Date Parameters for generating Microsoft Access Reports
Automating Archiving Records in Microsoft Access, using Append and Delete Queries
Showing or Hiding Microsoft Access Subforms
Sending E-Mails from a Microsoft Access Form
Grouping Data in a Microsoft Access Report
Alternating Report Group Colours in a Microsoft Access Report
Displaying an Image in a Microsoft Access Form
Using the Combo Box's NotInList event with multiple fields
Creating a Microsoft Access Splash Screen
Passing Multiple Parameters to a Microsoft Access Form
Password Protecting A Microsoft Access Tab Control
Changing Themes in Microsoft Access 2003
Microsoft Access Industry News and Articles:
Microsoft Access Industry News and Articles
Microsoft Access Knowledge Base Articles:
Microsoft Access Knowledge Base Articles
Microsoft Access Database Links and Resources:
Microsoft Access Links and Resources
Link To Us
Microsoft Access Products, Tools and Ad-Ins:
Microsoft Access Products, Tools and Ad-Ins
DatabaseDev OnLine Shops
UK Visitors
US Visitors
Site Feedback and Contact Information
Database Solutions Feedback
Database Solutions for Microsoft Access - Write For Us
Database Solutions for Microsoft Access: Write For Us
Database Solutions for Microsoft Access: Writers
Database Solutions Website Competitions
Database Solutions Website Competitions
Database Solutions Advertiser Solutions - Advertise with Us
Advertise with Database Solutions for Microsoft Access
Site Map
Privacy Policy
Terms & Conditions