Get started
Basic tasks for an Access desktop database
Troubleshoot problems
Fixes or workarounds for recent issues in Access
How do I compact and repair an Access desktop database?
How do I address errors when running append queries?
What do I do if I get an error message about not being able to delete from the specified tables?
How do I fix ambiguous outer join errors?
Design tables
Guidelines for naming fields, controls, and objects
Control data entry formats with input masks
Normalize your data using the Table Analyzer
Add or change a table's primary key
Restrict data input by using a validation rule
Add a calculated field to a table
Data types for Access desktop databases
Create and use an index to improve performance
Understand queries
Examples of using dates as criteria in Access queries
Examples of Access query criteria
Create and run an update query
Use parameters to ask for input when running a query
Add records to a table by using an append query
Create forms
Create a list of choices by using a list box or combo box
Create a form that contains a subform (a one-to-many form)
Set default values for fields or controls
Display column totals in a datasheet using a Totals row
Apply a filter to view select records in an Access database
Create a form by using the Form Wizard
Create a form by using the Form tool
Why does Access want me to enter a parameter value?
Create reports
Introduction to reports in Access
Create a grouped or summary report
Insert a page break control in an Access report
Video: Use conditional formatting on reports
Set the record source for a report
Use expressions
String functions and how to use them
Access Functions (by category)
Work with external data
Import or link to data in another Access database
Import or link to data in an Excel workbook
Link to or import from an SQL Server database
Import from or link data to a SharePoint list
Import or link to data in a text file
Use mail merge to send data to Word
Set global options
Decide whether to trust a database
Protect your data with backup and restore processes
Set user options for the current database
Encrypt a database by using a database password
Show or hide the Navigation Pane in Access