Form and Graphical User Interfaces

1
Form and Graphical User Interfaces
2
Lesson plan

• More about queries
• More about entering data into a table
• Form

3
More about queries

• Action query to insert a new record into a table
• Queries -gt choose the table -gt right mouse click
  -gt SQL View
• INSERT INTO User
• VALUES ('000001', '1234567', '34 Lancaster Road',
  'Glastonbury', '06033', 'asd_at_yahoo.com')

4
Entering data into table
5
Entering data into table
6
Entering data
7
Entering data into table
8
Entering data
9
Form

• Data entry forms are the primary means of
  entering data into tables in the database.
• Graphical User Interfaces

10
Form

• Spread-sheet like view
• Graphical user interface view

11
Why Form?

• Graphical user interface view offers
• Presenting data in an organized and attractive
  manner
• Offering the ability to limit the number of
  fields that appear on the form and allow or
  preventing editing a specific value

12
Basic Transaction Processing Form

• Serves transaction processing applications which
  add new records, or editing existing records

13
Basic Transaction Processing Form

• Example create a form to add a new record or
  view existing record to Employee table

14
Basic Transaction Processing Form
15
Basic Transaction Processing Form
16
Basic Transaction Processing Form
17
Basic Transaction Processing Form
18
Basic Transaction Processing Form
19
Using Design Form Window

• Form -gt Create form in Design view

20
Using Design Form Window
21
Using Design Form Window
22
Using Design Form Window
23
Using Design Form Window
Private Sub AddNewRecord_Click() On Error GoTo
Err_AddNewRecord_Click Dim sqlStatement As
String strStatement "insert into
Employee values('" Me.userssn "','"
Me.username "'," Me.usersalary ")"
DoCmd.RunSQL (strStatement)
Exit_AddNewRecord_Click Exit Sub
24
Create forms with more than one table
25
Create forms with more than one table
26
Create forms with more than one table
27
Create forms with more than one table
28
Create forms with more than one table
29
Create forms with more than one table
30
Create forms with more than one table
31
Adding Option Groups
32
Adding Option Groups
33
Adding Option Groups
34
Adding Option Groups
35
Adding Option Groups
36
Adding Option Groups
37
Adding Option Groups
38
Adding List boxes
39
Adding List boxes
40
Adding List boxes
41
Adding List boxes
42
Adding List boxes
43
Adding List boxes
44
Adding List boxes
45
Practice

• Create a form to add a new record and view
  existing records to Course table

46
Week 5 - Practice

• Change the Registration table so that every time,
  we add a new record, the list of available
  students (studentID, firstName, lastName) and
  courses (courseID, courseTitle)

47
Practice
Create forms in section a and b of project 1,
part 4