PRACTICAL-10
Creating a Table in Design
View
TO CREATE A TABLE IN DESIGN VIEW FOLLOW THE
GIVEN STEPS
Click on ‘create table in design view’.
Type field name in ‘Field Name ’ column
Select field type from drop down list of
‘field type column’
Mention details of field in ‘Description’
column.
Set the primary key
Click ‘save’ icon from standard toolbar
Type name of table
Click on ‘OK’ button
Now, click on ‘File’ menu from menu
bar and select ‘close ’ option.
PRACTICAL-11
Setting Relationships
TO SET UP RELATIONSHIPS FOLLOW THE GIVEN STEPS
Open the Table window. Select
‘Relationships’ option from tools menu.
Click on ‘ADD TABLES ’ icon from standard
toolbar
Select one table from ‘Add tables’ and click
‘Add’
Follow the above steps to add as many
tables as you want
Click on ‘Close’ button
Click on primary key field of first table and
drag it to foreign key of other table
Right click on ‘Relationship set’ and
select ‘Edit ’ option. ‘Relations dialog
box appears’
Click on ‘Update Cascade’ radio
button to activate update option.
Click on ‘Delete Cascade’ radio
button to activate delete option.
Click on ‘Ok’ button
Click on ‘Save’ icon from standard toolbar
PRACTICAL-12
Creating a Form Using
Wizard
TO CREATE A FORM USING WIZARD FOLLOW THE
GIVEN STEPS
Click on forms object from from database
pane
Click on ‘Use wizard to create form’
from tasks pane.
Add the fields in the ‘fields in the form’ box
Click on next button
Select Layout for your form
Then click next button
Select the data entry mode
Click next
Select style for your form
Click next
Change setting for your form to modify
or work with
Click finish.
PRACTICAL-13
Creating a Report Using
Wizard
TO CREATE A REPORT USING A WIZARD FOLLOW
THE GIVEN STEPS
Click on’Reports’ icon from the
‘Database’ window
Click on ‘Use wizard to create report’
Select tables/ queries from which data
has to be taken and records are to be
printed from ‘Tables or Queries’ box
Select fields
Click next
Label the fields
Click next
Select the fields to be grouped from
the ‘Field’ list box
Select fields on which recors of the
table will be sorted
Select layout for the report
Select page orientation
Give a name to the report
Click on radio button of ‘Create report
now’
Click finish
PRACTICAL-14
DDL Commands
SYNTAX (Create command)
CREATE TABLE TABLE_NAME
{
Column_name1 data_type(size),
Column_name2 data_type(size),
…..
….
Column_nameN data_type(size)
};
PRACTICAL-15
DML Commands
SYNTAX( SELECT command)
Select*from table_name where condition;
SYNTAX(INSERT command)
Insert in table_name ()()();
Table of Contents
[Link]. Title [Link]
1 Applying Different Styles
2 Creating A New Template
3 Creating Table Of Contents
4 Subtotal
5 Consolidation Of Data
6 Scenario
7 Cell Referencing
8 Goal Seek
9 Creating Macros
10 Creating A Table In Design View
11 Setting Relationships
12 Creating A Form Using Wizard
13 Creating A Report Using Wizard
14 DDL Commands
15 DML Commands