Microsoft Office Tips, Tricks, and How-to's to help you use MS Office like a pro!

Carol's Corner Office

Category Archives: Microsoft Access

Commonly Used Microsoft Access Shortcuts

Posted on by Posted in Microsoft Access

Who doesn’t like a good shortcut? You know, saving time and keystrokes? Nobody, that’s who!

Follow the steps below:

Alt + H Opens the Home tab

Alt +Q + enter search word opens the Tell Me box on your Ribbon

Shift + F10 will display the shortcut menu for the selected item

F6 moves the focus to a different pane of your window

Ctrl + O or Ctrl + F12 opens an existing database

F11 shows or hides the navigation pane

F4 Shows or hides a property sheet

F12 Switches between Edit mode (with insertion point displayed) and Navigation mode in the Datasheet or Design view

F5 switches from Design view to Form view

CTRL + P opens the print dialog box for data sheets, forms and reports

CTRL + Z zooms in or out on a part of your page

F1 opens the Help window

Alt + F4 exits Access

These are by no means all of the shortcuts but definitely enough to make you happy!

 

 

How to Find Duplicate Records in Access

Posted on by Posted in Microsoft Access

Follow the steps below to learn how to find duplicate records in your MS Access database:

  1. Click the Create tab.
  2. Click Query Wizard.
  3. Click Find Duplicates Query Wizard.
  4. Click OK.
  5. Click the table in which you want to find duplicate information.
  6. Click Next.
  7. Click the field that might contain duplicate information.
  8. Click Add.
  9. Repeate steps 7 and 8 to add any other fields you wish to the query.
  10. Click Next.
  11. Click any other field to display in the query results.
  12. Click Add.
  13. Repeat steps 11 and 12 as necessary.
  14. Click Next.
  15. Key in a name for the query.
  16. Click Finish.

There you have it!

Make Access Reports More Readable with Numbering

Posted on by Posted in Microsoft Access

There is a simple way to improve your MS Access report design and that is by numbering each item.

Long reports are easier to reference by sequentially numbering the line items.

Follow the steps below to learn how:

  1. Open your report in Design View.
  2. Place a text box named txtRunningSum at the left side of the detail section of the report.
  3. Click in the Control Source Property and enter =1.
  4. Click in the Visible property and select No.
  5. Click in the Running Sum property and select Over All.
  6. Add another text box next to txtRunningSum.
  7. Enter this code in the Control Source property:

=[txtRunningSum]&”.”

It is always easier once you know how isn’t it?