[go: up one dir, main page]
Scribd
Upload
18 views18 pages

Task 2 - Data Entry Forms - Gr.9 - 2

The document provides a step-by-step guide on how to create and fill in forms using Microsoft Access. It includes instructions for creating a database, designing a form, and managing records, such as saving and deleting entries. The guide is structured to assist users in navigating Access functionalities effectively.

Uploaded by

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

Task 2 - Data Entry Forms - Gr.9 - 2

The document provides a step-by-step guide on how to create and fill in forms using Microsoft Access. It includes instructions for creating a database, designing a form, and managing records, such as saving and deleting entries. The guide is structured to assist users in navigating Access functionalities effectively.

Uploaded by

asalaalfiomy05
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 18

P.

13
Thursday
12 / 9 / 2024
Task 2
Data Entry
Forms
Access Forms

A form in Access is a
database object is
directly connected to a
data source such as a
table or query, and can
be used to enter, edit, or
display data from that
data source.
Start Access Program
1) Create a folder with your name on the desktop, and open it.

2) Right-click on an empty area, a side menu will appear.

3) Point to New, and select Microsoft Access Database.

4) Choose a name for your file (Task 1), then press Enter on the

keyboard.
Create a Database
1) On the Create tab, In the Tables group, Click Table Design.
Create a Database
2) Type the names of the fields in the Field Name.
Create a Database
3) Choose the correct data type for each field in the Data Type.
Create a Database
4) Right-click the table heading (Table1) and click Save.
5) Write a name for your table (Student Grades).
6) Click OK.
Create a Form
1) In the Tables/Queries menu, select Student Grades table.
2) On the Create tab, In the Forms group, Click Form Wizard.
3) In the window that will appear, click the >> button to move all the
fields from Available Fields box to the Selected Fields box (this
means include all the fields in the form).
4) Select the Row No field and move it back to Available Fields box
using the < button (not important information to be included).
5) Click Next.
6) Leave Column selected, and click Next.
7) Click Finish in the next screen.
Create a Form
Create a Form
Transfers only selected
fields from (Available)
to (Selected), one by
one.

Transfers all fields from


(Available) to
(Selected), in one step.
Create a Form
Create a Form
You can change the name of the form

The layout
of the form.
This option
opens the form
in design view
and lets you
modify it.
Fill In a Form
1) Fill in the form you
have already
created.

2) When you are done,


click Save on the
Home tab, in the
Records group.
Go to the
Previous record

Go to the
Shows the Next record
Go to the current
First record Go to the
record Last record

Create a
New record
Fill In a Form
Delete a Record
1) Select the record you want to delete from the form.

2) On the Home tab, In the Records group, click the down arrow next
to Delete and then click Delete Record.

3) In the Message Box that appears, click Yes.


THANK YOU

You might also like