Introduction to MS Access Creating an Interactive Form

1
Introduction to MS Access Creating an
Interactive Form
2
Introduction to MS Access Creating an
Interactive Form
Design a Switchboard Using Wizard View Records,
Add New Record and Edit Existing Record
3
At the end of this class you are able to add and
edit a records using switchboard manager
This will be your end product
4
Introduction to MS Access Creating an
Interactive Form
5
Introduction to MS Access Creating an
Interactive Form
Click yes to create a switchboard
6
Introduction to MS Access Creating an
Interactive Form
Click new to create a item on the switchboard
7
Introduction to MS Access Creating an
Interactive Form
Select Open Form in the drop-down menu
8
Introduction to MS Access Creating an
Interactive Form
This text will appear at the main switchboard menu
The command to execute
Which form to show
Select Open Form in the drop-down menu
9
Introduction to MS Access Creating an
Interactive Form
You have to complete the items on this
switchboard like this
10
Introduction to MS Access Creating an
Interactive Form
This will be your end product
11
Introduction to MS Access Creating an
Interactive Form
Design a Splash
Splash Form Its will appear first for a couple
of second before a main switchboard appear. For
instance credit to the designer or declaration
made by the designer.
12
Introduction to MS Access Creating an
Interactive Form Splash Form
1. Create a new Form2. Type anything at your
plain form
13
Introduction to MS Access Creating an
Interactive Form Splash Form
Why we change these three properties from yes
to no ?
1. Change Form properties
14
Introduction to MS Access Creating an
Interactive Form Splash Form
1. At the form properties, choose Event tab.2.
Search On Open element.3. Click at the
15
Introduction to MS Access Creating an
Interactive Form Splash Form
1.The builder will pop-up 2. Chose Code Builder
and click OK
16
Introduction to MS Access Creating an
Interactive Form Splash Form
Make sure your Object is a Form
Make sure your Declaration is Open
In your VB Code environment type
Me.TimerInterval3000
Me.TimerInterval3000. This mean that your
splash form will appear with in 3 second after
the its will close automatically
1.After select code builder VB code environment
will appear
17
Introduction to MS Access Creating an
Interactive Form Splash Form
Change declaration from Open to Timer
18
Introduction to MS Access Creating an
Interactive Form Splash Form
Under Command Form_Timer () type DoCmd.Close
This command will instruct the form to close
after timer reaching 3 second
Close this VB code by clicking x
19
Introduction to MS Access Creating an
Interactive Form Splash Form
1. At the form properties, choose Event tab.2.
Search Timer Interval element.3. Type 30004.
Close form properties5. Save as Student
Information System Splash
20
Introduction to MS Access Creating an
Interactive Form Splash Form
When you click Student Information System
Splash at Form object. Your splash will appear
with in 3 second before it close itself.
21
Introduction to MS Access Creating an
Interactive Form Splash Form
Your task Try design a splash form after the
splash close. Your Existing Student Information
System From appear like this
After 3 second this students information system
appear..
This is your splash screen will appear 3 second.