Changing the Number Format of a Field in computer

Changing the Number Format of a Field in computer

CTRL + SHIFT + ~

Apply the general number format.

CTRL + SHIFT + $

Apply the currency format.

CTRL + SHIFT + %

Apply the percentage format with no decimal places.

CTRL + SHIFT + ^

Apply the exponential number format with two decimal places.

CTRL + SHIFT + #

Apply the time format with day, month, and year.

CTRL + SHIFT + @

Apply the time format with hour, minute, and am/pm.

CTRL + SHIFT + !

Apply the numeric format with two decimal places.

ENTER

To restore the selected minimized window when all windows are minimized

CTRL+F6

To cycle between open windows

F11

To bring the Database window to the front

CTRL + N

To open a new database

CTRL + O

To open an existing database

ALT+F4

To quit Microsoft Access

CTRL + P

To print the current or selected object

S

To open the Page Setup dialog box from Print Preview

P

To open the Print dialog box from Print Preview

C or ESC

To cancel Print Preview or Layout Preview

CTRL +S or SHIFT+F12 or ALT+SHIFT+F2

To save a database object

F12 or ALT+F2


To open the Save As dialog box

F4 or ALT + DOWN ARROW

To open a combo box

F9

To refresh the contents of a Lookup field, list box, or combo box

DOWN ARROW

To move down one line

PAGE DOWN

To move down one page

UP ARROW

To move up one line

PAGE UP

To move up one page

TAB

To exit the combo box or list box

CTRL + F

To open the Find tab in the Find and Replace dialog box (Datasheet view and Form view only)

CTRL + H

To open the Replace tab in the Find and Replace dialog box (Datasheet

SHIFT + F4

To find the next occurrence of the text specified in the Find and Replace dialog box when the dialog box is closed (Datasheet view and Form view only)

F2

To switch between Edit mode (with insertion point displayed)

F4

To switch to the property sheet (Design view in forms and reports in databases and Access projects)

F5

To switch to Form view from form Design view

F6

To switch between the upper and lower portions of a window

F7

To switch to the Code Builder from form or report Design view

SHIFT+F7

To switch from the Visual Basic Editor to form or report Design view

ALT + V, P

To open property sheet for a selected object

SHIFT + ENTER

To add a control to a section

CTRL + C

To copy the selected control to the Clipboard

CTRL + X

To cut the selected control and copy it to the Clipboard

CTRL + V

To paste the contents of the Clipboard in the upper-left corner of the selected section

CTRL + RIGHT ARROW

To move the selected control to the right

CTRL + LEFT ARROW

To move the selected control to the left

CTRL + UP ARROW

To move the selected control up

CTRL + DOWN ARROW

To move the selected control down

SHIFT + DOWN ARROW

To increase the height of the selected control

SHIFT + RIGHT ARROW

To increase the width of the selected control

SHIFT + UP ARROW

To reduce the height of the selected control

SHIFT + LEFT ARROW

To reduce the width of the selected control


TAB

To move to the Help button in the wizard

ALT + N

To move to the next window in the wizard

ALT + B

To move to the previous window in the wizard

ALT + F

To close the wizard window

ALT + F, D, A

To send the active database object as an e-mail message

CTRL + SHIFT + B

To open the Address Book

ALT + K

To check the names in the To, Cc, and Bcc boxes against the Address Book

TAB

To select the next box in the e-mail header or the body of the message when the last box in the e-mail header is a

SHIFT + TAB

To select the previous field or button in the e-mail header

F2

To display the complete hyperlink address for a selected hyperlink

F7

To check spelling

SHIFT+F2

To open the Zoom box to conveniently enter expressions and other text in small input areas

ALT + ENTER

To display a property sheet in Design view

ALT+F4

To quit Microsoft Access, close a dialog box, or close a property sheet

CTRL+F2

To invoke a Builder

CTRL+F11

To toggle between a custom menu bar and a built-in menu bar

CTRL + RIGHT ARROW or CTRL +, (COMMA

To toggle forward between views when in a table, query, form, report, page, view, PivotTable list

CTRL + LEFT ARROW or CTRL+. (PERIOD)

To toggle back between views when in a table, query, form, report, page, view, PivotTable list, PivotChart report.

F6/Shift-F6

Cycle through sections

Ctrl-Tab

Cycle through tab of each object's type (forward)

F11

Database window

F2

Edit/Navigation mode (toggle)

Ctrl-Alt-spacebar

Insert default value

Ctrl-Home/End

Move to beginning/end of multiple-line field

Home/End

Move to first/last field in current record (Navigation mode)

End or Ctrl-Right

Move to right edge of page

Ctrl-Enter

Open in Design view

Alt-Enter

Property sheet

F9

Refresh combo box

Shift-Enter

Save current record

Ctrl-spacebar

Select/unselect column (Navigation mode)

Shift-F8

Undo previous extension

Shift-F2

Zoom box

Displaying, Hiding, Sorting, and Filtering Data

CTRL + 8

Toggle the display of the expand indicators beside items.

CTRL + =

Expand the selected item.

CTRL + -

Hide the current item.

CTRL + SHIFT + A

Sort the selected field's data in ascending order.

CTRL + SHIFT + Z

Sort the selected field's data in descending order.

ALT + SHIFT + ↑

Move the selected item up.

ALT + SHIFT + ←

Move the selected item to the left.

ALT + SHIFT + ↓

Move the selected item down.

ALT + SHIFT + →

Move the selected item to the right.

if u like the post please like and shear