ms access all knowledge

The following articles were made with Access 2016.

Databases

• Create a Blank Database
• Create a Database from a Template
• Save a Database as a Template
• Open a Database in Exclusive Mode
• Password Protect a Database
• Encrypt a Split Database
• Remove the Password from a Database
• Import a SQL Server Database into Access
• How to do a Mail Merge

Tables

• Create a Table in Datasheet View
• Create a Table in Design View
• Create a Linked Table
• Create a Linked Table to SQL Server
• How to use the Linked Table Manager
• Update Linked Tables after the Backend Changes Location
• Export a list of Linked Tables to Excel
• Create a Totals Row
• Create a Calculated Field

Queries

• Create a Simple Query in Design View
• Create a Parameter Query
• Find Duplicate Records
• How to use the Crosstab Query Wizard
• Create a Crosstab Query in Design View
• Convert a Normal Query to a Crosstab Query
• Convert a Crosstab Query to a Normal Query
• Fix Missing Fields in a Crosstab Query

Forms

• How to Create a Blank Form
• Create a Form from a Table
• Add a Lookup Control to a Form
• How to Resize Form Controls
• How to Change a Form's Background Color
• How to Change a Form Header's Background Color
• Add a Subform to an existing Form
• How to Create a Subform from a Table

Reports

• Create a Report from a Table
• How to Group a Report
• Create a Grouped Report using the Report Wizard
• Group a Report by Multiple Fields

• Database Tools

  • Create a Database Diagram
  • How to use the Database Documenter
  • Compact & Repair a Database Manually
  • Compact & Repair a Database Automatically
  • How to Display an Object's Dependencies