Wednesday, July 23, 2014

AUTO SAVE IN MS WORD

1. Select The File Menu and Choose Save As.
2. Click On The tools and Select Save As option .
3. In Save click on the Save Auto Recovery into every--- Minute and
4. Getting the timing as you want to save your document.
5. Click on the OK button
6. Click on the Save button.

Create Table by Using Wizard

Create Table by Using Wizard -
1. Select File menu and Choose New.
2. Click on the Blank Database.
3. In File New Database – File name db1 Create.
4. Double Click on the table Using Wizard Option.
5. The Table Wizard dialog box appears
6. Choose a table Business or Personal.
7. Select the fields that you want to include in your table and click on the > button. This Step for all the fields that you choose. You would notice that all these field has been added to your new table.
8. If you need to delete any field in your new table, then Select the field you to delete and Click on the < Button, that field will no longer be present in the New Table.
9. Click on the Next button.
10. In Table Wizard, you want to name your table.
11. And Set a Primary key or not. (A Primary Key is a field that uniquely identify a Record)
12. Click on the Next button.
13. Click on the Finish button.
14. Now Create a Table.
15. Now Right Click on the table and Select Deign View.

Creating Table in Design View

1. Click on the File menu and Select New.
2. Click on the Blank Database.
3. In File New Database, File name db1  Create.
4. In Tables, Create table in Design View.
5. In Table1:Table, File Field Name and Datatype.
6. Close Table1: Table
7. Do you want to save changes to the design of table’Table1’?
8. Click on the Yes
9. In Save As get Table Name Table1 OK.
10. If You Want a primary Key.
11. Click on the yes.
12. Now Create a Table in Design View.
13. Now Right Click on the Table1 and Select Design view.


Creating a Form by Using Wizard

1. Select File Menu and Choose New.
2. Click on the Blank Database.
3. In File New Database- File Name db1 Create.
4. Click on the Create Button.
5. In db1 database, Choose Forms and Create form by Using Wizard.
6. Double Click on the Create Form by Using Wizard.
7. In Creating Form You must have at least one table to use this wizard.
8. In Form Wizard, You can Choose a table or more than one table.
9. Click on the Next button
10. In Form Wizard, Select  a layout would you Like From your Form.
11. Click on the Next Button.
12. In Form Wizard, Select a Style Would You Like.
13. Click on the Next Button.
14. In Form Wizard, Give a Title You to Your Form.
15. Click on the Finish Button.

Macro

1. On the Tools Menu, Select Macro and Click on the Record New Macro.
2. In Record Macro: Type a Name for the Macro.

3. And Assign Macro to Toolbars or Keyboard.
4. To Assign the Macro to Toolbars, Click On the Toolbars and Click Command Tab.

5. Click on the Close Button to Start Recording Macro
6. Click on the Close Button to Start Recording Macro.
7. To Assign the Macro in Keyboard, Click on the Ok Button.
8. In Customize Keyboard, Press New Shortcut key.
9. Click on Assign Button.

10. Click on the Close button to Start Recording to Macro.

11. Now Perform your action to Include in Macro.
12.To Stop Recording Macro, Click on the Stop Recording.

13. For Running Macro Press  Shortcut keys.

Create a Macro in MS Excel 2003

1. On the Tools Menu, Select Macro and Click on the Record New Macro.
2. In Record Macro: Type a Name for the Macro,  Get a Shortcut Key Ctrl + __
3. Click on the OK Button.
4. Now Perform your  action to Include in Macro.
5. To Stop Recording Macro, Click on the Stop Recording.
6. And then Run Your Macro

Subscribe to: Posts (Atom)