Get help with your questions about Microsoft Access with our how-to articles, training videos, and support content.
Becoming familiar with the tables, forms, queries, and other objects in an Access database can make it easier to perform a wide variety of tasks, such as entering data into a form, adding or removing tables, finding and replacing data, and running queries. This article provides a basic overview of the structure of an Access database.
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 create forms for simple data entry. Summarize data in grouped and summary reports. Dozens of Wizards make it easy to get started and get productive.
Find how-to content, sample code, SDK and API documentation, VBA references, training, and technical articles for developing solutions and customizing Access.
Get started with basic tasks for an Access database. An Access database can help you store and track just about any kind of information, such as inventory, contacts, or business processes.
Create a database without using a template Copy data from another source into an Access table Import, append, or link to data from another source Add an application part Open an existing Access database Overview When you first start Access, or if you close a database without closing Access, the MicrosoftOffice Backstage view is displayed.
Create a query, form, or report in Access Create a select query Create a query to focus on specific data. Select Create > Query Wizard . Select Simple Query, and then OK. Select the table that contains the field, add the Available Fields you want to Selected Fields, and select Next.
In Access, programming is the process of adding functionality to your database by using Access macros or Visual Basic for Applications (VBA) code. For example, suppose that you have created a form and a report, and you want to add a command button to the form that, when clicked, opens the report.