6prim computer term2

8/2/2019 6Prim Computer Term2

1/39

--


2/39

--

Expression Web Lab ExercisesScenario

The exercises in this tutorial will introduce you to Microsoft Expression

By the end of these exercises, you will have created a simple standards-compliant

Web site on the topic of Egypt & freedom.

In order to create this site, you will learn how to use the tools in Expression Web

to edit Web documents in Design view and to create a site that is ready for

publishing to the Web. In these lab exercises you will become familiar with Web-

based technologies such as cascading style sheets HTML .

Below is a sneak peek of the Egyptian Revolution Web site that you will

create with this tutorial.


3/39

--

The Microsoft Expression Web Workspace

1. Common Toolbar

2. Folder List

3. File Tabs

4. Toolbox

5. Style and Layer Task Panes

6. View Tabs

7. Tag and CSS Property Task Panes

8. Bread Crumb Trail


4/39

--

Task 1:-Open the program:-

1) Start

2) All program

3) Expression web

Task 2 :-Create a new Empty web site :-

1) From File menu choose new ,web site.

2) From web site tab select empty web site

3) Press OK.

Task 3 :-Create a new HTML page:-

1) From File menu choose new ,page

2) From page tab select HTML

3) Press OK.


5/39

--

Task 4 :- Save a page:-

1) From File menu select save as.

2) Type index.HTML

3) Clicksave .

Note:-

The page is named"index.html" because most web servers will

recognize this file name as the home page.

Task 5:- Change properties of page:-

1) Right click and select Page Properties .

2) From general tab in title "Freedom of Egypt".

3) In page description type "new Egypt" .

4) In keywords "Freedom,Egypt,25th January".

5) Under the formatting tab select the color you want .

6) Press OK .


6/39

--

Task 6:-Creating page layout with layers :-

A) Create a layer and add an image:-

1) In the tool box choose layer and drag it into the page.

2) From Insert menu select Picture from file .

3) Determent the location of the picture you want and choose it

4) Press insert .

5) In Accessibility properties dialog box write freedom in the Alternate text .

6) In the long description write new Egypt.

7) Press OK.


7/39

--

B) Add text to a layer :-

1) In the tool box choose layer and drag it into the page .

2) Write the title "Freedom of Egypt"

3) In the tool box choose layer and drag it into the page

4) Write the paragraph

"Let us all hope that the dark clouds of racial prejudice will soon pass away, and

that in some not too distant tomorrow the radiant... stars ofLove And Freedom

will shine over our great nation with all their scintillating beauty.

Task 7:-Preview the page in a browser

-From File menu select preview in browser

OR

- Press F12 from key board


8/39

--

Task 8:- Creating more page

1. File menu, New and clickHTML.

A blank page will open. DO NOT add anything to the page.2. File menu, clickSave.

3. File, Save As, File Name: Pictures.html , Then Save.

4. From Insert menu select picture from File .

5.Determent the location of the picture you want and choose it

6. Press Insert .

7. In Accessibility properties dialog box write freedom in the Alternate text .

8. In the long description write new Egypt.

9. Press OK.


9/39

--

Task 9:- Creating hyperlink

1. Select the text " Love And Freedom".

2. From "Insert" menu, select "hyperlink"

3. Select the page you want .

4. Press "OK"


10/39

--

Task 10:- Creating Table :

1. From "Table" menu select "Insert table" .

2. Select the number of "Rows" and "Columns" .3. Determine the size and color of the border .

4. Press "OK"


11/39

--

By using Expression Web program

Create a web site containing that :-

1.Two pages the first page by name index. Html and the

second page by name egy.html .

2.Change the background of this pages to " gray " .

3.Insert Layer & Insert picture in the two pages .4.Insert Layer & Add text .

5.Insert hyper link for picture in " page1 " to link it with " Page

2 ".

6. Insert table include two rows & two columns .

7. Browse your web site by Internet Explorer .


12/39

--


13/39

--

Day : Date :

Objects :

Open MS Access program .

Subject :

* To start Access

Select : start

Choose: programs

Choose : Microsoft Office

Select: MS Access

* Close the Access program

Click on the Close icon .

OR click on the Exit from the file menu .

OR press Alt+F4.


14/39

--

* Open a file

Click on the Open icon .

OR click on the Open from the File menu .

OR press Ctrl + O.

H.W :

Insert the right icon in the right space :

1.To open a document we click on .. icon .

2.To close anew document we click on .. icon .

3.To open access program we click on .. icon .

The drive or folder

that contains the file

you want

Select the file

name by clicking

on it

Click on the Open

button


15/39

--

Day : Date :

Objects :Create a new database& save it .

* Create a new database :

Clickon the New icon .

OR click on the New from the file menu .

OR press Ctrl + N .

Blank database

Create

1

2

3

45


16/39

--

* To Save a database :

Click on the Save icon .

OR click on the save from the file menu .

OR press Ctrl + S .


17/39

--

Day : Date :

Objects :

Create, save and modify table.

* Create and save a table .

Press new icon .

Press blank database . Double click on the Create table in Design view option

In the Field Name section of the dialog box, enter the name of the first field and data types

.

We can now save the table by clicking on the Save icon.

You will see a dialog box in which you can enter your table name.


18/39

--

Clicking on the OK button may display a further dialog box.

You will see the table displayed within the Database dialog box.

H.W :

Put ( ) or ( ) :

1.The data one type only . ( )2.We can't delete records . ( )

3.To create table we press new icon . ( )


19/39

--

Day : Date :

Objects :

* Define a primary key

1. automatically when creating a table

When you create a new table part of the process will automatically assign a primary key

to the table

Example

1. We created the following fields.

2. We then save the table, as illustrated.

3. A dialog box is then displayed, offering to create a primary index.


20/39

--

4. Clicking on the Yes button will create a primary index using an AutoNumber Data Type.

2. Define a primary key (manually after a table has been created)

You can add a primary key to a table that does not already have a primary key set.In the following example we have a table with no primary key.

Click on the View icon, which will display the table in design view.

Press the Primary Key icon is visible within the Design View toolbar.

* Modifying the way a field is indexed

In the Design View .


21/39

--

H.W :

Put ( ) or ( ) :

1. We can't define a primary key automatically when creating a table .

( )

2. The Primary Key icon is visible in the Design View toolbar. ( )

3. The duplicated entries are allowed . ( )


22/39

--

Day : Date :

Objects :

Create, save and modify table.

* Create and save a table .

Press new icon .

Press blank database . Double click on the Create table in Design view option

In the Field Name section of the dialog box, enter the name of the first field and data types

.

We can now save the table by clicking on the Save icon.

You will see a dialog box in which you can enter your table name.


23/39

--

Clicking on the OK button may display a further dialog box.

You will see the table displayed within the Database dialog box.

:W.H

:)(or)(Put

4.The data one type only . ( )5.We can't delete records . ( )

6.To create table we press new icon . ( )


24/39

--

Day : Date :

:Objects

Change between view modes in a table, form, report.

Switch between views when using tables, forms or reports

There are two views for tables, forms and reports.

The Design View:

This view is used by the person that creates a database in the first place


25/39

--

The Datasheet View:This is used by the person entering data into a database.

* To switch between Design and Datasheet View

Click on the View icon on the toolbar.

* Display or hide a toolbar

1. Open View menu

2. Select the Toolbars command

3. Choose the Toolbar you want to display by clicking on it .

:W.H

:Complete

1.To display or hide a toolbar we choose ----------------- from view

menu .

2.There are two views for tables, forms and reports.

1. ----------------------------------

2. ----------------------------------


26/39

--

Day : Date :

Objects :

Add, modify data in a record.

* Add records to a table.

Double click on the name of the table that you wish to open.

We can enter data by using the tab key to jump from field to field.

* Delete records within a table

Select the entire record row as in the example shown.

Press the Del key.

A warning dialog box will be displayed.

Click on the Yes button to confirm the record deletion.


27/39

--

* Add data to a record

Open the table containing the record that you wish to add data to.

Click within the field you wish to enter your data into.

Key in your data.

* Delete data within a record

Open the table containing the records that you wish to modify.

Delete the data within the record that you wish to remove select and then press the Del key.

* Use the Undo command.

Click on the Undo icon in the toolbar.

* Navigate through a table :

Current record.

Record is selected.

Record is being edited.

Last (empty) record.

To move from record to record using the scroll bar and mouse

To move from record to record:

to the next record

to the previous recordto the last record

to the first record


28/39

--

To delete a table

Select the table that you wish to delete

Press the Del key and you will see a warning dialog box.

Clicking on the Yes button will delete the selected table.


29/39

--

H.W :

Match :

To Navigate through a table :

Current record.

Record is selected.

Record is being edited.

Last (empty) record.


30/39

--

Day : Date :

Objects :

Change field format

* Change field format attributes.

1.Open the table that you wish to modify.

2. Click on the View icon to see the table displayed in design view.

3. Click on the field that you wish to modify the attributes of.

1

2


31/39

--

We can modify :

1. Field Size

2. Number Format

3. Date Format

H.W :

Complete :

We can modify :

1. .

2. .

3. .


32/39

--

Day : Date :

Objects :

Change table format

Change width of columns in a table.

1. Move the mouse pointer to the line at the right of the field (column heading). It willchange to resemble a solid vertical bar intersected by a double-headed arrow.

2. Drag the column border to the size you want.

Move a column within a table

1. Select the column(s) and release the mouse button.2. Click on the field selector and drag the column(s) to the new location. As you drag the

columns a solid bar between columns indicates the current position of the columns beingmoved.


33/39

--

Day : Date :

Objects :

Create a relationship one-to-one .

* Create a one-to-one relationship between tables

Click on the Tools menu and select Relationships.

If the ShowTable dialog box is not already displayed click on the Show Table icon on the

Relationships toolbar.

Select the table you want to add from the Table list. Use the Ctrl key to add more than one

table or the Shift key to add a block.

Click the Add button.

Select a second table from the Show Table dialog box.


Click the Close button.


34/39

--

To create a relationship link from a field in one table to a field in another table, simply drag

the field from the first table and drop it on top of the field in the second table.

The Edit Relationships dialog box will be displayed.

Click on the Create button to create the relationship.

A line will appear in the Relationships window to represent the link.


35/39

--

H.W :

Put ( ) or ( ) :

1. We can create a relationship between a tables . ( )

2. Use the Shift key to add more than one table. ( )

3. We can select a One table only from the Show Table dialog box. ( )

4. To create Relationships we click on the Tools menu and select Relationships .

( )


36/39

--

Day : Date :

Objects :

Create a relationship one-to-many .

* Create a one-to-many relationship between tables

Click on the Tools menu and select Relationships.

If the Show Table dialog box is not already displayed click on the Show Table icon on the

Relationships toolbar.

Select the table you want to add from the Table list. Use the Ctrl key to add more than one

table or the Shift key to add a block.


Select a second table from the Show Table dialog box.


Click the Close button.

The Relationships window should now resemble the illustration below.

In the example we have 2 tables, Customers and Orders. A customer may have placed

many orders; therefore the relationship between the tables is one-to-many. The field used

to associate an order with a customer is the CustomerID field.


37/39

--

Drag and drop the CustomerID field from the Customers table to the CustomerID field in

the Orders table.

The EditRelationships dialog box will be displayed.

Notice that the Relationship Type area at the bottom of the dialog box states One-To-

Many.

We need to ensure that any changes to the CustomerID in the Customers table are

replicated in the CustomerID field of the Orders table. To do this enable the Enforce

Referential Integrity option and then enable Cascade Update Related Fields.

Click on the Create button. The relationship link will be shown as below:

To delete a relationship between tables

Click on the Tools drop down menu and select Relationships. Click on the relationship line that you wish to delete.

Press the Del key, and you will see a warning dialog box, asking if you wish topermanently delete the relationship.

Click on the Yes button to confirm the deletion.


38/39

--

H.W :

Put ( ) or ( ) :

1. To delete a relationship click on the relationship line that you wish to delete. And press

the Del key ( )

2. We can't create a relationship between a tables . ( )

3. Use the Ctrl key to add more than one table. ( )


39/39

Training on Practical ExamFirst: Ordinarily Course

1. Searching for a file in your computer .2. Searching for a hardware in your computer3. Searching for person in the address book .4. Install Printer .5. Add or removing programs .6. Add new hardware ( Camera)7. Help & support

Second: By using MS-Access application Do the Following Project

1. Start Access Program2. Create a new database3. Save a database with name Index4. Create table by using Design with following items:

Data typeItemChoose the suitable data typeFirst Name

Choose the suitable data typeSalary

Choose the suitable data typeMobile

5. Choose the suitable item to be primary key6. Switch between Design and Datasheet View7. add following data :

Samy 500 0123456789

Hend 200 0102345678

Ali 300 0112345678

8. Move the column Salary after column Mobile9. Insert new column with title Second Name after field First Name10.Create new table by using Design with following items:

Data typeItemChoose the suitable data typeID

Choose the suitable data typeFamily Name

Choose the suitable data typeHome Phone

11.Choose the suitable item to be primary key12.Switch between Design and Datasheet View13. Change width of columns in a tableto be widethest.14.Type the following data :

Gaber 2345678Hashem 3456789

15.Save table with name Information16.Make Relationship one to one between first name and Home Phone 17.Make Relationship one to many between table Index and table Information 18.Close the Access program.

6prim computer term2

Documents