Scribd
Upload
68 views9 pages

Assingment Access

To create tables, reports, relationships, queries, and forms in Access, follow these basic steps: 1. First, create your tables in Design View. 2. You can then create different types of reports like auto reports or custom designed reports based on your tables. 3. Create relationships between your tables by going to the Relationships view. 4. For queries, you can use the Query Wizard or design your own queries on one or more tables. 5. Finally, you can create forms in different ways like auto forms, custom designed forms, or blank forms based on your tables. Make sure to save your work.

Uploaded by

emma
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
68 views9 pages

Assingment Access

To create tables, reports, relationships, queries, and forms in Access, follow these basic steps: 1. First, create your tables in Design View. 2. You can then create different types of reports like auto reports or custom designed reports based on your tables. 3. Create relationships between your tables by going to the Relationships view. 4. For queries, you can use the Query Wizard or design your own queries on one or more tables. 5. Finally, you can create forms in different ways like auto forms, custom designed forms, or blank forms based on your tables. Make sure to save your work.

Uploaded by

emma
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

ASSINGMENT : ACCESS

1. How to create a Table like this


ii.
First step you need click View and you will see Design View

iii.

Click that Design View and you can create your own table

Note you need click


view
iv.

after you done create table on design

To view you table. Click View and click Datasheet View

And you will get your own table

How to create Report


1. Report have 3 category
a. Report
b. Report design
c. Blank report

a. First report you can find auto report

b. Report design you can design your own design

c. And the last report is blank report

If you want to create blank report you just click show all table
2. Remember , you must create your table fisrt after that you can create your
report

How to create relationship


1. In relationship have connection between query
2. Done you table after that continue to query
3. Click query design

And you will see like this picture

4. Click enter to Database tools and you will see relationship button

5. You just click relationship and you will get

How to create query

1. Query has 2 category


a. Query Wizard
b. Query Design

You can choose any


query you want to
create
2. First click enter create and you will see 2 query . Before you start to
create query , you must create design view on your table

Design View

3. If you click enter


Query Wizard, you will
see
a.

b. click >>
to
selected
fields and
than just
click
Next or
Finish

4. Query design you can make relationship another table to another table

And you can continue your use 2 different query


How to create Form
1. Form has 3 category
a. Form
b. Form design
c. Blank form

You can choose any form you want to create. I give one example from that 3
form.
2. First click create and you will see 3 form . Before you create form you
must create your own work at table like this

3. Remember after you done you must click safe


to create
form
4. First form like auto form , second form is Form Design you can create
your own design according to your taste , and third form is Blank Form
i.

For
m

ii.

Form Design

iii.

Blank Form

You might also like