Wednesday, July 23, 2014
Getting Started with MS Excel 2003
Start Menu >> All Programs >>Microsoft-Office>> Microsoft Office MS Excel 2003
Or
- Click on the Start button from the Task bar
- Select All Programs From the Start button.
- Select All Programs and Click on the Microsoft Office and Choose the Microsoft Office Excel 2003
The screen as shown in figure appears with a blank workbook opened.
Creating a New Blank Database
Creating a New Blank Database on MS-Access 2003
1. Select File menu and click on the New.
2. Click on the Blank database.
3. File New Database box will be appears.
4. In the File New database give File name: db2 (new database)
5. Click on the Create button.
6. The New Database db2 is created on the MS Access.
Creating a New Blank Database
Creating a New Blank Database on MS-Access 2003
1. Select File menu and click on the New.
2. Click on the Blank database.
3. File New Database box will be appears.
4. In the File New database give File name: db2 (new database)
5. Click on the Create button.
6. The New Database db2 is created on the MS Access.
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.
Subscribe to:
Posts (Atom)