These practical tips help you work faster in Microsoft Access whether you are a daily user or an occasional database administrator.

Keyboard Shortcuts

• Ctrl+;Insert today's date in the current field.
• Ctrl+':Copy the value from the same field in the previous record.
• F11:Toggle the Navigation Pane on and off.
• Ctrl+F6:Cycle between open objects (forms, queries, reports).
• Alt+F11:Open the VBA editor from anywhere in Access.

Filter by Form

Open any table or form in Form View, then click Home → Advanced → Filter by Form. Enter criteria in any field (use * as wildcard) and click Toggle Filter. This is faster than building a query for simple searches like "all customers in North Carolina."

Quick Sort and Filter

Right-click any field value in Datasheet View and choose equals, contains, or does not contain to instantly filter. Click the filter icon in the column header for additional options.

Use the Immediate Window

In the VBA editor, press Ctrl+G to open the Immediate Window. Test expressions instantly: type ?DLookup("LastName", "tblCustomers", "CustomerID=5") and press Enter to see the result without running a full procedure.

Datasheet Totals Row

In any table or query Datasheet View, click Home → Totals to add a summary row at the bottom. Choose Sum, Count, Average, or other aggregations per column without writing a query.

Attachment Handling

• Use hyperlink fields instead of attachment fields when possible — attachments bloat the database.
• Store files on a network share and save the path in Access.
• Compact and Repair after bulk attachment operations.

Performance Tips

• Close unused forms and reports — each open object consumes memory.
• Use pass-through queries when connected to SQL Server back-ends.
• Set Subdatasheet Name to [None] on tables to prevent automatic subdatasheet loading.