Meet the Guide Editor
Microsoft Access Contributors

The Complete Guide to Access Databases

Access Database LogoAn Access Database is used to store information created by Microsoft Access or third party applications. Access Databases usually have the file extension MDB or MDBX. They are sometimes known as a Joint Engine Technology (JET) database.

Access Databases store all database tables, queries, forms, reports, macros, and modules. The database also provides support for security, referential integrity, transaction processing, indexing, record and page locking, and data replication.

This guide introduces you to fundamental concepts of Access Databases, and provides a number of tips, tutorials and examples to get you you started with your first Access Database.

Latest Articles on Microsoft Access
A Comprehensive Guide to Using Microsoft Access on Your Mac Pro

Your powerful Mac Pro is capable of doing many tasks but a solution has to be found when you want to run Windows apps, such as Microsoft Access. Read on for all the options on getting...

Access Tips & Tricks

Microsoft Access is an extremely powerful database creation tool. To get the most out of your database, take a look at some Access tips for users of all levels....

Running Microsoft Access on a Mac

Looking for a way to use Microsoft Access on your Mac? Here are some options you have, as well as alternatives to the program that will (hopefully) suit your needs just...

How to Capture the Network Name of a Microsoft Access User

A multiuser, networked implementation of a Microsoft Access database can become challenging when you need to find out who entered particular data. By creating a Microsoft Access network...

Most Popular Articles on Microsoft Access
  •  
    How to Capture the Network Name of a Microsoft Access User

    A multiuser, networked implementation of a Microsoft Access database can become challenging when you need to find out who entered particular data. By creating a Microsoft Access network name function,...

  •  
    Using Microsoft Access to Connect to a SQL Database

    Have you outgrown Microsoft Access and upgraded to SQL? Microsoft Access still plays a critical role and can be used for specialized queries. No matter how many 'built in' queries database...

  •  
    MS Access - its Advantages and Disadvantages

    There are very strong views about MS Access. Its detractors call it a toy database; good for playing with but not for serious corporate use. Yet there are people with equally strong opinions who swear...

  •  
    Importing Excel Spreadsheets into Access 2007

    The Import Spreadsheet Wizard in Microsoft Access 2007 greatly simplifies the process of importing Excel worksheets into Access tables. Read on to find out how to use this tool....

  •  
    How to Make a Subform in Access

    A subform is just what it sounds like - a form inside of another form. When you want to show data from several tables with a relationship, subforms can help get the job done....

More About Microsoft Access
Using Scientific Notation in Microsoft Access

Microsoft access Scientific notation brings the power of exponential notation to the powerful database program. Microsoft Access scientific notation can simplify data entry as well...

Optimizing Microsoft Access by Using Compact on Close

Is your Access database slowing down or taking up too much space? Microsoft Access is one of the most powerful databases in use today. MS Access grows with every transaction and...