This sample database template demonstrates how Access can manage small business customers, orders, inventory, purchasing, suppliers, shipping, and employees. The database can generate 15 …

Access provides several tools that you can use to familiarize yourself with the structure of a particular database. This article also explains how, when, and why you use each tool.

With Access, you can build a database without writing code or being a database expert. Well-designed templates help you quickly build databases. Easily find just the data you want with queries. Instantly …

It explains how to create a desktop database by using a template, and how to build a database from scratch by creating your own tables, forms, reports, and other database objects.

Let's take a walk through the paths you can take to create an Access desktop database, add data to it, and then learn about next steps towards customizing and using your new database.

Access organizes your information into tables: lists of rows and columns reminiscent of an accountant's pad or a spreadsheet. In a simple database, you might have only one table.

If your Access desktop database is going to be used by multiple users, well-designed forms is essential for efficiency and data entry accuracy. There are several ways of creating a form in an Access …

Relational database programs, such as Microsoft Office Access, use SQL to work with data. Unlike many computer languages, SQL is not difficult to read and understand, even for a novice.

In Access desktop databases you can use the DLookup function to get the value of a particular field from a specified set of records (a domain). Use the DLookup function in a Visual Basic for Applications …

Get help with your questions about Microsoft Access with our how-to articles, training videos, and support content.