To create the Microsoft Access 2002\XP Application

Return



Application name - KJV 2002

Contents...

Application introduction

Application developed with Access 2002, Part 1

Application developed with Access 2002, Part 2
Application developed with Access 2002, Part 3

Application developed with Access 2002, Part 4

Appendix, Print data
 

  Author
        Chucri Simon Zouein, Computer engineer
       E-mail: 
info@puresoftwarecode.com
 
*****************************************************


Subject: Step by step for creating Access 2002  application .


Info about this application :

  1. Name - KJV2002.
  2. Database Software.
  3. Developed with Microsoft Access 2002
  4. The KJV2002.mdb database file stores Part of the Bible data. - (part of Bible consists of 4 books, every book has a title and consists of several chapters and every chapter consists of several verses)
    The database consists of one table - BibleTable. The table stores more then 3781 records and each record consists of five fields - Book, Title, Chapter, Verse and TextData:
    - The Book field stores the orders of the 4 books.
    - The Title field stores the titles of all books.
    - The Chapter field stores the orders of all chapters.
    - The Verse field stores the orders of all verses.
    - The Textdata field stores the contents of all verses.
  5. Functions: View and Search.
  6. Requirements: Microsoft Access 2002
     
  7. To Run this application
     
    1. Run the Microsoft Access XP.
    2. From File menu, click  Open, the Open dialog box appears, select  KJV2002.mdb  (..\Access_XPAPP\KJV2002.mdb)  and then click Open.  Application automatically start
       
    3. Else (after this Access file open click MainForm)

After running, you can observe the following designs:

  1. MainForm Form, design.

     





     
    Welcome to KJV,
    Learn how to write a Microsoft Access 2002 application

    The functions of MainForm:

  2. To call the Book Form. - (Click Continue)
  3. To unload the current Application. - (Click Exit )
  4. Book Form, design:

    1. The 1st page of Tab control is selected.


    2. The 2nd page of Tab control is selected.

    The functions of Book:

  5. To display any KJV2002 database record into the Record data boxes.
  6. To move the current record position to the first, last, next, or previous record. - (Click the navigation button)
  7. To call the About Form - (Click About)
  8. To unload the current Form. - (Click Close)
  9. To search by word: - (Select the 1st page of Tab control)
  10. Type a word - (length > 1 characters) in the TextBox, the Display Button  set enable.
  11. Click Display button, two types of information appear:
    1. A list of information about all records of the KJV2002 database include the word you specified will appears in the List box - (each list item stores  the values of Book field, Title field, Chapter field and Verse field corresponding ...).
    2. The number of the records found.
  12. Select an item of the list, the record corresponding to the item selected displays into the Record data boxes.
  13. To search by address: - (Select the 2nd tab of TabStrip control)
    1. The Book ComboBox stores the orders of all books. Select an item:
    2. In the Book ComboBox, displays the item selected.
    3. In the Title ComboBox, displays the title of the book.
    4. The Chapter ComboBox stores all chapters orders of the book and in the current string displays the 1st chapter order.
    5. The Verse ComboBox stores all verses orders of the 1st chapter and in the current string displays the 1st verse order.
    6. Into the Record data boxes, displays the 1st record of the book.
    7. The Title ComboBox stores the titles of all books - ( 4 books). Select an item:
    8. In this ComboBox, displays the item selected.
    9. In the Book ComboBox, displays the order of the book.
    10. The Chapter ComboBox stores all chapters orders of the book and in the current string displays the 1st chapter order.
    11. The Verse ComboBox stores all verses orders of the 1st chapter and in the current string displays the 1st verse order.
    12. Into the Record data boxes, displays the 1st record of the book.
    13. :The Chapter ComboBox stores all chapters orders of the book corresponding to the item displays in the Book ComboBox. Select an item:
    14. In this ComboBox, displays the item selected.
    15. The Verse ComboBox stores all verses orders of the chapter and in the current string displays the 1st verse order.
    16. Into the Record data boxes, displays the 1st record of the book chapter.
    17. The Verse ComboBox stores all verses orders of the chapter corresponding to the items display in the Chapter and Book ComboBoxes. Select an item:
    18. In this ComboBox, displays the item selected.
    19. Into the Record data boxes, displays the record corresponding to the item selected.
  14. About Form, design.


    The functions of About.frm :

  15. To display information about the KJV2002 database.
  16. To unload the current Form. - (Click Close)

 

Note :

  1. Code: To display ... , from the View menu, click Code.
    Use the Code window to write, display, and edit Microsoft Access code
  2. Properties : To display ... , from the View menu, click Properties
    :Lists the design-time properties for selected objects and their current settings. You can change these properties at design time. When you select multiple controls, the Properties window contains a list of the properties common to all the selected controls.
    Properties List Tabs
    • Format Tab
    • Data Tab
    • Event Tab
    • Other Tab
    • All Tab
  3. Toolbox:  

    To display ... , from the View menu, click Toolbox
    Displays the standard Microsoft Access controls plus any ActiveX controls and  objects you have added to your Form.


 
  Home
0
 
Next