You are here: MS Access Products > Designer > Product Features

Designer for Microsoft Access

   Product Features

Designer for Microsoft Access helps you create Microsoft Access databases that are correctly normalized, without understanding the principles of relational database design.  After walking through Designer's Q&A wizard, Designer creates your tables, fields, relationships, and basic data entry forms...allowing you to focus on customizing your forms to your liking and creating reports.

  Evaluation Full License
Create new tables with one-to-many and many-to-many relationships
Easily define field formats, sizes, and how they should be displayed to users
Designate specific fields as lookup fields, which automatically creates a separate table to store values, and adds a dropdown list to your tables and forms to display that options
 Automatically creates table relationships, primary, and foreign keys based on your answers during the Q&A wizard process
Creates Visual Basic code automatically to support "Not In List" events, where users can add new values to a dropdown box if the value doesn't already exist.  The new value is then added to the corresponding lookup table.
Create a new database to your specifications, or begin with one of several templates to build upon
Unlimited tables and forms  
Unlimited databases  
Unlimited end users for the databases you create  
Integration with UI Builder for MS Access automatically places tables/forms into UI Builder, creates starter menus with your forms.  
Free access to OpenGate's Microsoft Access Consulting Network, a group of consulting professionals with experience deploying databases using OpenGate products  
Lifetime product support (no annual fee)  
Lifetime product updates (no annual fee)  



All editions of Designer are compatible with the following:

Microsoft Access 2000

Microsoft Access 2002

Microsoft Access 2003

Microsoft Access 2007

Microsoft Access 2010 (32- and 64-bit)

Microsoft Access 2013 (32- and 64-bit)

Microsoft Access 2016 (32- and 64-bit)

Microsoft Access 2019 (32- and 64-bit)



Installation and Distribution

When you order Designer, you receive a copy of Designer that you can download to your machine.  No installation is required on your end-user's machines for the databases you create with Designer (users must have one of the versions of Microsoft Access present on their PC, of course).  You simply give them access to the Designer-created database file(s).


More questions?  Read the Designer Frequently Asked Questions, or contact us via email (



Buy with Confidence
All OpenGate products are backed by a 30-day money back guarantee. If our product does not meet your project's specific needs, or you do not gain the benefit you expected, we stand by our guarantee for a full refund for 30 days after your purchase.