Essential MS Office & Access Commands and Functions

Posted on Mar 18, 2025 in Computers

1. Essential Keyboard Shortcuts

  • Shift + Ctrl + M: Change font size
  • Shift + Ctrl + F: Change font type
  • Shift + Ctrl + D: Double underline text
  • Shift + Ctrl + L: Convert lowercase to uppercase
  • Ctrl + Alt + I: View document in Print Preview
  • Ctrl + M: Change font, font style, font size
  • Shift + Ctrl + U: Convert uppercase to lowercase
  • Ctrl + R: Close the existing document
  • F12: Show the “Save As” window

2. Formula for Table of Letters Results

Formula to display results for “PASA YEAR’S LOSE THE YEAR, SUPLETORIO”:

=IF(f < 25, "lose year", IF(f >= 40, "passing year", "residual"))

3. Creating a Macro with Message and Invoice Report

Steps to create a macro displaying a message and invoice report:

  1. Macro
  2. New Macro
  3. Enter a Macro name
  4. Running macro
  5. Make MSG
  6. Record Macro

4. Making an Object Invisible on Mouse Hover

Program to make an object invisible on mouse hover and load another object:

Objet1.Mousemove = true

5. MS Access Function Definitions

  • VISIBLE: true or false to display an object
  • MouseMove: Program a moving mouse action
  • CLICK: Perform a function on a click event
  • OpenForm: Open a form
  • DoCmd.Close: Close a form

6. Visual Basic Function Definitions

  • STR: Display a value in a message box
  • MID $: Assign a value for a moving object
  • UCASE: Assign a value to a textbox (uppercase)
  • KeyAscii: Turn the taps of the text box
  • RND: Change a value or randomize
  • Vdoleshow: Run or open an OLE object
  • QBColor: Change the value of an object
  • CASE: Choose a menu function
  • INTERVAL: Give a time value to a timer object
  • KeyPress: Write numeric and alphanumeric values in a textbox

7. Creating a Mail Merge in MS Word

Steps to create a mail merge for a merchandise request:

  1. Tools
  2. Letters and Mailings
  3. Mail Merge
  4. Select Letters
  5. Use the current document
  6. Type a new list
  7. Fill the required data
  8. Save
  9. OK
  10. Merge
  11. Insert Merged Fields
  12. Click to complete

8. Visual Basic Commands

  • RELEASE:
  • 4 + 16: Display a window with Accept, Decline, or Error options
  • 1 + 32: (Description missing)
  • 8 + 64: Display a window with information and close/cancel buttons
  • CLOSE ALL: Close all types of objects
  • SELECT: Select a table
  • THISFORM: Select a form for scheduling
  • ENABLED: Lock and unlock textboxes
  • VALUE: Assign a value to a textbox

9. SQL Queries and Results

Customer Data Query

SELECT CODE, NAME, SOCIAL SECURITY NUMBER FROM CUSTOMER;

R = This query displays the code, name, and social security number fields from the customer table.

Sales Data Query 1

SELECT * FROM SALES WHILE PRECIO_U <> 400 OR PRECIO_U <> 500;

R =

Price
400
0
500

Sales Data Query 2

SELECT PRICE FROM SALES WHILE PRICE <= 800 AND PRICE >= 1200;

R =

Price
800
1200