MDB Speaking Flashcards

The Rose Project of 2003

Version 1.2

Freeware Edition

User's Guide

  1. Introduction

    The MDB Speaking Flashcards is a software application which reads mdb databases, loads the records into its internal buffer and converts them into flashcards equipped with multilingual speech.

    This software application reads mdb databases created by Microsoft Access, its Jet Engine, or other capable database applications. The MDB Speaking Flashcards has a native capability to create, maintain and view mdb databases, tables and fields.

    The flashcards are capable of displaying text, or text-represented data, and bitmap images which are embedded in the records. Only the Commercial Version is capable of simultaneously displaying multiple images on the flashcards. The flashcards will also play all wave files which are either embedded or linked in the records.

    The unique power of the application comes from its ability to generate speech utilizing the speech application programming interface (SAPI) provided by Microsoft. For its ordinary function, every field can have its own speaker with a unique set of characteristics such as language, gender, age, pitch, speed and volume. For its dialog function, the application can define a set of speakers of varying sets of characteristics. This set of speakers is referred to as a dialog point identified by a name or label. It is also referred to as dialog speaker. The actual speaker to use is determined by the value of the field assigned as the basis field. Any field can have a dialog speaker which will then vary depending upon the value of the basis field.

    Dialog points are specific to a table or query because they are tied up with particular fields of such table or query.

    Only the Commercial edition is capable of defining and utilizing more than one dialog point or dialog speaker. The Demoware edition does not have a valid dialog speaker. The Freeware edition has at most one.

  2. Software Environment

    Starting Version 1.1, the software supports UNICODE character set, on top of the ANSI counterpart. Now, mdb databases created by MS Access up to 2003, or those compatible with MS Jet Engine up to Version 4.0, or up to DAO 3.6.

    The software has been compiled for two target platforms. One, the ANSI compilation for Windows 9x and ME series, and UNICODE compilation for Windows NT and XP group. The two compilations both support UNICODE data. The difference lies in the names of fields, tables or even queries. For these names, only the UNICODE version allows UNICODE character sets to be used. For the ANSI counterpart, only one single ANSI character set, that of the system, is supported. This may be largely a DAO limitation or MFC.

    Another limitation for ANSI build is that basis values, as can be learned later, may be only in the ANSI codepage of the system. This is not a problem for the UNICODE build.

  3. Setup Requirements

    This is a software application which relies heavily on other components, ActiveX or otherwise, provided by the author himself, or by Microsoft Corporation, or by third parties, whether through Microsoft or independently. Hence, before this software application will run, those components have to be installed already.

    1. ActiveX ncScrollbar by the Author

      This scrollbar maybe obtained from either www.simtel.com or www.winsite.com. Please be patient with all the ads being flashed. It is part of the deal in exchange for freely hosting the controls. For now, the MDB Speaking Flashcards Freeware edition is available also in those websites. Make sure to obtain the latest version 2.40. There is a bug in 2.30 which has been emphasized in the Commander as can be learned later on.

      When the software technology is obtained, this is in a zip format. Unzip the technology. There are two versions of the scrollbar, the ANSI and the UNICODE. The former works with all Windows desktop or laptop platforms, while the latter for the NT's and XP's only. Please choose the appropriate version, and register it to your system.

      If you do not have a program to register ActiveX, please follow this:

      1. Copy the OCX and LIC files to the directory of the MDB Speaking Flashcards software application.
      2. Download by clicking this Setup file. Unzip the file and copy the program SETUP.EXE and the accompanying OCI file to the directory of the MDB Speaking Flashcards software application.
      3. When all the files have been transferred to the same directory, run setup.exe. Click Open item in the File menu, then choose the OCI of the scrollbar. Click the register button from the toolbar. Alternatively, click the Register item in the Action menu.
      4. Follow the screen. Hopefully the ActiveX would have been registered.
    2. DAO 3.6 by Microsoft Corporation

      This component is required for all DAO database applications like the MS Acess 2000 or later, or the MDB Speaking Flashcards software application. This is freely distributed by Microsoft. This is installed by MS Access or MS Office by Microsoft, or programming languages sold by Microsoft. This may also be bundled with DAO-aware applications.

      To check whether the computer has this component is to run the program and switch to Database View. Try loading a database file. If there is no problem along the way, then it should have been installed already.

      Otherwise, go to the Microsoft website to obtain and install the needed file: Dao360.dll. For Windows 9x, ME platform and Windows NT 4.0, please install the Microsoft Jet 4.0 Service Pack 7.0. Please click this link: http://support.microsoft.com/?KBID=282010. (To launch it in another window, right-click it and choose Open in Another Window item from the pop-up menu. This way, this webpage will not be lost.)

      For other platforms , please install the Microsoft Jet 4.0 Service Pack 8.0. Please click this link: http://support.microsoft.com/?KBID=829558.

      Just follow the instructions there.

      For advanced programers who want to free up some space, other files included with the service packs are not needed by the MDB Speaking Flashcards, can be safely removed as long as no other applications depend upon them.

    3. SpeechAPI.exe by Microsoft Corporation

      This file is included with the MDB Speaking Flashcards zip file. After unzipping the latter, just look for the SPEECHAPI.EXE and run it to install the SAPI binaries. However, the speech engines should be obtained separately and installed in the computer, if they are not yet installed.

      Please take note that the Freeware edition of the MDB Speaking Flashcards only recognize SAPI 4.0 compliant speech engines, like the ones freely available and downloadable later. SAPI 4.0 and SAPI 5.0, and later, compliant speech engines are recognized and supported only by the Commercial edition.

    4. Text-To-Speech Engines

      There are free and commercial speech engines available in the market. The following are freely downloadable SAPI 4.0 compliant speech engines available in the www.microsoft.com website. After downloading, just double-click on the file, and follow the screen. The speech engine should be available to the MDB Speaking Flashcards. If currently running, however, please close the application first and then reopen it.

      Now, please click on the appropriate links. If these fail, please go to the www.microsoft.com website and search for MS Agent component. The language-specific speech engines should be made available following the link downloadable user components of the MS Agent.

      American English.

      British English.

      Dutch.

      French.

      German.

      Italian.

      Japanese.

      Korean.

      Portuguese.

      Russian.

      Spanish.

  4. Basic Data

    1. In General

      The primary data of the MDB Speaking Flashcards come from the mdb databases. Users who are familiar with databases do not need to read this part. For those who are not familiar, it is presumed that they are familiar with computer files in general. The mdb database files can be thought of as a filing cabinet. The said cabinet contains folders and each folder holds several records. The record is a set of information kept for one purpose or another. A concrete example would be a folder holding application documents of job applicants. The record which is the application document may be the biodata or resume of the applicants, which in turn contain, among other things, their respective names, addresses, educational attainment information and work history.

    2. Analogy

      In terms of the mdb files, the tables or queries of the files are synonymous to the folders, particularly the folder of application documents. The record of the database table or query is likened to the application document or the biodata/resume of each applicant. The fields of the table or query are the individual pieces of information kept in the record. Hence, the name is a field, the address is another field, the educational attainment information and work history are yet another two fields of the table or query.

      Tables or queries are not different for purposes of the flashcards. The difference lies in the source of information contained by them. Tables contain raw information directly entered by the user or provider. The tables would require more memory as the number of records grows. On the other hand, queries use only information contained already by these tables.

    3. Queries

      While there are several kinds of queries, only the select query is relevant to the flashcards. It is called a select query because it merely selects some fields from other tables or existing queries, and adopts them unaltered or use them either altered or computed using data from a combination of fields or other sources, and including only a limited set of records from the totality of records that the original tables hold. There are two kinds of selection, then: vertical or field selection; and horizontal or record selection.The select query, or query, in short, is a two-dimensional subset of the table or tables, presented unaltered or enhanced. It requires no additional memory to hold its derived information, other than the query definition itself.

      Horizontal selection of queries can be done statically or dynamically, or both. If the limiting parameters are included in the query definition itself, this commonly called a filter. This is static horizontal selection. If the parameters are obtained before the query is performed or results displayed, this is dynamic horizontal selection. The latter is what is known as parameterized select query, or parameterized query. With this facility, there is no need to rewrite the query to vary what records may be included in the query.

  5. Interfaces

    So far, there are four most important main interfaces. These are the DatabaseView, the FlashCardsView, the TalkView, and the Flashcards Dialog interfaces. Another important interface is the Options Dialog. The three interfaces may be accessed or switched to from the Action menu.

    The DatabaseView allows user interaction with the database which is the source of information of the flashcards. The FlashCardsView interface provides a facility for specifying the settings which the flashing of the cards shall proceed, and of launching the Flashcards Dialog. The latter displays the information of the database one record at a time, and when appropriate speaks its data. The TalkView speaks any user-provided text. The Options Dialog offers another facility for indicating settings which take effect on and affect the application environment regardless of the database currently loaded, or flashcards currently in operation.

    There may be included more main interfaces in the future, which corresponds to the direction of expansion of the functionality of the software.

    1. Action Menu

      This is present in all view. It provides access to the different main interfaces, as shown below:

    2. Options Dialog

      There are three parameters here. The startup view, the interface, and the primary language set.

      1. Startup View

        The Startup View may be changed using the combo box. There are four choices: DatabaseView, FlashCards, TalkView, and Last Accessed. The choices are self-explanatory. When the software is run, the initial view it displays is the one chosen here. The last accessed view is that view being displayed when the software is terminated or closed.

      2. Interface

        The interface maybe changed using the corresponding combo box. For now, there is only one interface - English. So, it seems that this parameter is not yet significant. However, the Freeware and Commercial versions are both internationalized and localized. For the latter, the following additional localized interfaces will be provided: French, German and Spanish. Russian and Japanese interfaces are in the drawing board.

      3. Primary Language Set

        The primary language set is used to specify test sentences for a particular language. To do this, the primary language id, a codepage, a language description to distinguish it from other test sentences, and the test sentence itself, are required. To find out if a particular speech engine is working fine, the software provides mechanism for testing it. Speech engines of a particular language utilize the corresponding test sentence for such purpose. If there is none provided, it uses the default sentence provided by the application considering the current interface in effect. That is why test sentences are provided so that for instance, german sentences would be spoken by german speech engines, and english sentences for english speech engines.

        These sentences and the settings are all saved conveniently in the windows registry, saving the users the burden of having to type the sentences over and over every session.

        1. LANG ID

          The primary language id is entered here. There are predefined language id's in the combobox, just select it or type its name. Alternatively, specify their corresponding id's. The latter method is also the only way to enter primary language id's of languages not included in the selection. The choice of predefined entries matches correspondingly with the freely available text-to-speech engines. Other numbers will be published here later, or they maybe obtained from windows documentation on primary language id's.

        2. Codepage

          Codepages are used to properly decode the ANSI characters stored in the Registry. Please note that for Windows 9x, it is deemed a homogeneous ANSI character set of one codepage. Hence, we need to circumvent this limitation to save mixed character sets in the Registry.

          Ideally, the codepage is automatically assigned once the proper primary language id has been chosen from the corresponding combobox. If it happens that the language id is not found in the combobox, and a user provided number is entered, it is the responsibility of the user to provide the proper codepage. Please consult the Windows documentation.

          The choice of defualt values correspond to the freely avaiable speech engines.

        3. Language Desc

          This is simply useful to the user. The labels here should be descriptive of the language for easy recall. To enter the label, type it in the edit box. Also, labels here maybe changed at any time.

          The list box shows the languages having test sentences. Just select the particular language description to reveal the test sentence and the primary language id.

        4. New, Apply, and Delete Buttons

          After specifying the three parameters, press the New button to create the test sentence. If the new values were just to change an existing value, press the Apply button. To remove the test sentence from the list, select it from the Language Desc list box and then press delete. As many test sentences may be maintained, and all these are saved in the windows registry. However, only one test sentence may be maintained for a particular language.

        5. Apply, OK, Cancel and Revert Buttons

          Please take note that all the changes may be effective only for the current session or made permanent to apply to future sessions as well, depending on the button pressed. To make it permanent, press either the Apply or OK button. The difference of the two is that the former does not close the dialog, while the latter does. To abandon the changes currently made, press the Revert button which will immediately restore the permanent and saved settings. To exit the dialog without committing the changes to the windows registry; and hence, use the changes for the current session only; press the Cancel button. Later these changes may be finally committed or abandoned by going back to the Options dialog and pressing the appropriate button. However, if not committed these changes will be lost upon termination of the application. Closing the application does not warn the user of any pending changes in the Options dialog.

    3. FlashCards

      The FlashCards interface consists of a tab control of six (6) tabs. The Operations Toolbar and Menu are provided to launch the flashcards.

      1. Operations Toolbar and Menu

        The Freeware edition provides only the Launch button or item. This is because in this edition, only one type of flashcard operation is provided. This is the non-interactive flashcard, or more appropriately the Slide type flashcard. Interactive Flip flashcard, or the classical Question-Answer type is available in the Commercial edition. Other types of operation include the Matching type, Enumerate type, Multiple Choice type, and other variations.

      2. General Settings Tab

        1. Flash Table/Query and View Comboboxes

          This flash combo box shows the tables and queries available according to the view mode chosen above it. If the mode is ALL, it shows all the tables and queries available to the application and the user as basis for the flashcards. If the mode is WITH DEFINED SETTINGS ONLY, only those which have defined settings are shown. If the mode is WITHOUT SETTINGS ONLY, only those tables and queries without settings are displayed. This is useful for purposes of definition. The distinction is significant because only those tables and queries which have definitions may be run in the flashcards (obviously because these definitions are required settings by the flashcard function).

        2. Parameter Box

          This read-only edit box shows the following basic information:

          • -Number of Records returned. If this is zero (0), it indicates that either there is really no record available or there was an error encountered in the opening of the table or query.
          • -For tables, the Number of Sort Definitions or Indexes available for use with the table. Any one index may be selected at anytime.
          • -For tables, the Current Index being utilized in the opening of the table.
          • -For queries, the Number of Parameters required by the query.
          • -For queries, the Actual Values of each of the parameters, or the condition of the settings currently supplied by the user.
        3. Define Button

          Click this button to define the table or query settings. By default, all fields of the table or query are written to the flashcards (displayed in the flashcards), but no speaker is assigned to any field header or value. The field header is simply the name of the field; while the field value is the actual value of the field in the current record. They are assigned separate speakers because they might be in two different languages, or to put more emphasis on one over the other, or simply to make audio distinction between the header and its values. The checkbox indicating with defined settings should be automatically set or checked afterwards. There are many configurating guis in the field definition set to be described later on to vary the flashcards settings.

        4. Delete Button

          Click this button to remove the current definition of the table or query. The checkbox indicating with defined settings should be cleared afterwards.

        5. Set Button

          Click this button to set or change the index to be utilized by the table, or change any of the values of the parameters required by the query.

          In case of the table, the following dialog will appear. Please choose the appropriate index from the list box.

          In case of the query, the following dialog will pop up. Enter the appropriate values for one or more of the parameters.

          Afterwards, either press the OK button to confirm the changes or Cancel button to abandon them.

        6. Field Header Combobox and Field Type

          This is the combobox which lists down all the fields of a table or query. Select a particular field to see its current flashcards settings. The Field type is simply the variable type of the field, whether boolean, text, or long, for instance.

        7. Tag Checkbox

          Control Tags which are recognized by the speech engines maybe freely mixed with values of the field. However, this may not always be possible because the databases are used also or probably much more importantly for other purposes than simply for speech synthesis. That is the main reason why the software application was conceptualized: the fact that databases are created for much more important reasons than merely listening to how it sounds.

          Other databases are really intended for speech applications. Thus control tags maybe freely mixed. Please consult the SAPI documentation. For those tags, this checkbox need not be set. The software application introduces some of its own tags available in the commercial version. If those tags inserted in the value of the particular field are supposed to be interpreted by the software application, this checkbox needs to be checked. Otherwise they are interpreted as ordinary text, and may result in fact in the wrong interpretation of the whole field data.

        8. Do Not Read In FlashCards Checkbox

          If this checkbox is set or checked, the field header and the value are not spoken by the flashcards, even if they have assigned speakers. This is useful for disabling field speech without losing the currently assigned speakers.

          Please note that all wave files are affected by any read-related flags.

        9. Do Not Write In FlashCards Checkbox

          If this checkbox is set or checked, the field header and the value are not shown or displayed in the flashcards. This is also useful for last minute selective inclusion of fields, an alternative to writing a new query.

          Please note that all image files are affected by any write-related flags.

        10. Header Speaker and Value Speaker Comboboxes

          Select from the corresponding combobox the speakers intended for the particular field header or value. By default they are assigned no speaker. There are two types of speakers available for the field values: ordinary and dialog speakers. Only the ordinary speakers are available for the field header because the name of the header does not change and could only be assigned one language. The values, on the other hand, may be of different languages.

          As many speakers may be defined for the database. Please proceed to the Field Basic Speech Tab. Likewise, as many dialog speakers may be provided in the Dialog Basis Tab.

          Please note that value speakers assigned to fields containing wave or image files are ignored by the flashcards.

        11. Unspeak Header and Unwrite Header Checkboxes

          There are cases where the field of the current record does not contain any actual value, or is NULL. For these cases, there is no reason for displaying or speaking the field name. Hence, to achieve selective disabling, set either of these checkboxes. Please take note that similar Do Not Read or Write flags operate totally to the field without distinction as to whether the value is NULL or not.

        12. Test Buttons

          Click this button to hear the speaker. The speaker speaks the appropriate test sentence according to the language of the underlying speech engine.

        13. Test All Button

          Click this button to hear the sample flashcard being spoken according to the whole table or query settings. Values are replaced by appropriate test sentences.

        14. Disable Speech Checkbox

          Set this checkbox for blanket disabling of speech. This is useful if speech must be temporarily disabled without losing or altering the current speaker settings of the fields.

      3. Field Basic Speech

        1. Speaker Name Combobox

          This combobox lists down all the ordinary speakers created, or supplied by the application. To create a new speaker, type in a unique name for the speaker. Then set the necessary parameters of the new speaker such as the voice, pitch, speed, and volume. Press the New button. Please note that any addition or changes are reflected immediately in the General Settings and Dialog Basis Tabs.

          To change the current name of a speaker, select the speaker and type in the new name. Other parameters may also be changed. Press the Apply button. If changes were not intended, press the Revert button.

          To remove a particular speaker, select the speaker and press the Delete button. However, Revert and Delete are available only in the Commercial edition. Maintenance there is important because it is only in the Commercial edition that settings may be saved and loaded between sessions. For other editions, these settings need to be entered every session. (See why there is a need to buy the Commercial edition? But if this little burden is alright, then there is nothing to worry about.)

        2. Voice Combobox

          Select the appropriate voice mode according to language, sex, age, engine provider, etc. Speech engines currently installed appear in the list.

        3. Use default and User Pitch, Speed and Volume Radio Buttons

          When the speaker is first created the characteristics of the voice mode are set to their default values which are the optimum values recommended by the speech engine provider. The use default radio button is set. If the settings are altered, the switch is made to the user radio button. As long as the current voice mode is the one saved, it is possible to switch back and forth between default values and user values. If the voice mode is also changed then the characteristics are reset to the new voice mode. To switch the radio button to user, at least one characteristic value must be altered. This change may be lost if the use default button is set again. If the voice mode is placed at the saved one again, the user values saved are available again. To save the new settings, please press the Apply button.

        4. Pitch, Speed, and Volume Scrollbars and View Boxes

          The voice mode characteristics may be altered through the corresponding scrollbars. Just press the appropriate New or Apply buttons afterwards.

        5. Test Button and Auto Test Checkbox

          The current settings may be tested. The underlying speech engine will use the appropriate test sentence provided in the Options dialog. To provide automatic testing every change in selection of speaker in the corresponding combobox, the Auto Test checkbox must be set or checked.

        6. Advance Related GUIS

          They are available only in the Commercial edition.

      4. Timer and Alert

        1. Timer Definition Set

          Two standard timer settings are available. The initial time required to display the first flashcard is given in ten (10) seconds, 0 for no delay. The succeeding time to elapse for the following flashcards to be showed is given in five (5) seconds, or 0 for no delay.

          Another timer setting is available in the Commercial edition. It is the Animation timer.

        2. Sound Alert and Play Async Checkboxes

          Set this checkbox if a sound alert needs to be played for every change of flashcards. If the sound needs to be played asynchronously or independently of the flashcard tasks, then set the Play Async checkbox. Most of the time, however, the sound is better played synchronously so as not to overlap with the other sounds generated by the flashcards.

        3. Sound Files and System Events

          If sound alert is enabled, the sound played is either a system sound event provided the appropriate settings in the control panel have been enabled, or a particular wave file.

        4. Browse Button

          Click this button to search for the particular wave file.

        5. Add Button

          If the entry in the edit box is not already found in the combobox, it will be added as long as there is space for it in the combobox. Otherwise, the current entry subsists only as long as no new selection has been made.

        6. Delete Button

          The edit box is cleared, and if the entry has been previously added, it is likewise deleted in the combobox.

        7. Test Button

          To test the sound intended to be used in the flashcard, please press this button.

        8. Max Sound Files

          Enter a number from 0 to 127 for the maximum user provided sound files or system sound events not yet found in the combobox.

        9. Apply Button

          No changes made both in the Timer Definition set and the Alert Definition set shall be made effective unless the Apply button has been pressed, including the max sound files.

        10. Revert

          To abandon currently made changes, and reset the values to the saved values, please press the Revert button.

      5. Dialog Basis

        1. Flash Table/Query and View Comboboxes

          This flash combo box shows the tables and queries with defined available according to the view mode chosen above it. If the mode is ALL, it shows all the tables and queries with defined settings. If the mode is WITH DEFINED DIALOG ONLY, only those which have existing dialog points are shown. If the mode is WITHOUT DIALOG ONLY, only those tables and queries without dialog points are displayed.

        2. Dialog Point Combobox

          This shows all the dialog points available to the particular table or query shown in the flash combobox. Each dialog point is identified by a unique name. Please note that the uniqueness of the name is imposed only among the dialog points belonging to one and the same table or query. Furthermore, in the Freeware edition, the user cannot choose the name of the only one dialog point available to the said table or query.

          In the Freeware edition, creating a new dialog point is done by pressing the New button. The name may not be changed. It may not be deleted, either.

          In the Commercial edition, to create a dialog point requires the user to first type in a unique name, then press the New button.

          To change the current name, just type in the new name and press the Apply button. Likewise, press the Delete button to remove the selected dialog point from the list.

          After creating the dialog point, the Dialog Definition set must be properly configured before the dialog speaker may become useful.

        3. Basis Field Combobox and Field Type

          The choice of the Basis Field is the most important step in the configuration. This is the field which will determine the variability of the speakers which will be used for those fields utilizing the particular dialog speaker.

          Listed in the combobox are those fields of the table or query with the following field types only: Boolean, Byte, Integer, Long, and Text. All other types are impracticable due to the size of the data, or its variability when displayed under different locales.

        4. Basis Values Combobox

          The number of actual speakers is determined by the number of values in this list. Each value which represent an instance-value of the basis field, is associated with a particular speaker.

          During the flashcard operation, whenever a field in the record utilizes a dialog speaker, the actual value of the basis field in the same record is obtained. The value is then referred to this list of basis values, and if available and found the associated speaker is chosen for the flashcard. However, if the value is not found in the list, the speaker associated with the Dialog Default Speaker is utilized for the flashcard.

          Please note that the list is not case-sensitive.

        5. Value Speaker Combobox

          Please select from the combobox the speaker intended for the particular basis value. By default, the newly added basis value, and even the Dialog Default Speaker, is associated with no speaker.

        6. Value Help List

          The list is built up from the database. Leading spaces are trimmed. Normally, changing the basis field is accompanied by a reloading of this list.

        7. Disable Value Help List Checkbox

          The value help list is desirable for most situations when the database does not contain voluminous records. However, when the latter is indeed large, and the basis values to be built up are just few and easy to imput, it is sometimes advisable to turn the facility off by checking or setting this.

        8. Volume Indicator Box

          Two values are provided by this box. The first is the actual number of entries in the value help list, and the other the number of records read from the database. In effect the first is the number of distinct values out of the number of records read.

        9. Add Button

          To add a basis value, just select the desired value from the value help list or type in a value from the edit box of the help list. The latter may or may not be found in the list. Afterwards, please press this button.

        10. Disable Speech Checkbox

          This has the same function found in the General Settings Tab.

          The other tabs are relevant only for the Commercial editions.

    4. Flashcards Dialog

      The dialog above is an example of a flashcard. It may have a picture above the richedit control.

      1. Current Flashcard ViewBox

        The current flashcard sequence or list number and the total flashcards are indicated here. In case of randomly selected flashcard, the sequence number, enclosed in brackets, is different from the list number. The former is its order in the database retrieval process, while the latter is the order of appearance in the set of flashcards.

      2. Alert and Async Check Buttons

        Set this check buttons if a sound alert needs to be played for every change of flashcards. If the sound needs to be played asynchronously or independently of the flashcard tasks, then set the Play Async check button. Most of the time, however, the sound is better played synchronously so as not to overlap with the other sounds generated by the flashcards.

        Also, changes made here are effective only for the current flashcard operation.

      3. Commander Button

        The Commander button shows and hide the Commander dialog shown above.

        1. First, Previous and Next Buttons

          The First button displays the First flashcard. The Previous button displays the previous flashcard until the first flashcard is reached. The Next button displays the next flashcard until the last flashcard is reached; unless the commander is set to loop around, in which case, it goes back to the first flashcard.

        2. Goto Scrollbar and Current Flashcard ViewBox

          Randomly displays the desired flashcard. The current list number of the displayed flashcard is shown in the viewbox. Unless the latest ncScrollbar version 2.40 is installed, please refrain from operating this scrollbar during timered operation, as the desired number might be misplaced, and unpredictable results might occur.

        3. Randomize Button and Sequence Check Button

          Press the Random button to make the appearance of the flashcards in random order. Press this again to change the randomization, as many times as desired. Press the Sequence button to make the flashcard appear in the order the records were retrieved in the database. Both will display the first flashcard immediately.

        4. Play Button

          Press the button to display or replay the current flashcard.

        5. Mute Check Button

          Press this button to temporarily disable or enable speech.

        6. Loop Check Button

          Press this button to provide automatic looping around the list or not.

        7. Timer Check Button

          Press this button to automate flashing of the cards according to timer settings. Unpressed, flashcards must be manually moved using the other buttons provided. If the Loop flag is not set, the Timer check button pops up automatically upon reaching the last flashcard.

    5. DatabaseView

      The interface consists of ceiling tabs and floor tabs. The ceiling tabs are for the tables and queries of the database. Click the desired tab to view the corresponding table or query. The floor tabs correspond to the kind of information which is sought to be displayed.

      1. DataRibbon Toolbar and Menu

        The dataribbon is the principal interface utilized for data navigation, creation and maintenance. Common to most of the floor tabs, there are eight (8) standard buttons or items, and one multipurpose button.

        1. Move or Navigation Buttons

          The four (4) innermost standard buttons or items are the First, Previous, Next, and Last. Applied to records of the database, pressing the buttons correspondingly move the database pointer to the first record, previous to the current record, next, and last record. Applied to fields, pressing the buttons similarly move the field pointer to the first ordinal field, and so on. The same is true to the sort definitions or indexes. For the purpose of this section, the term record may apply to database record, field, or index.

        2. Creation and Maintenance Buttons

          The four (4) outer standard buttons or items are the Apply (like a forward slash), Add (plus), Delete (minus), Edit (backslash). One or more buttons may be disabled and unavailable at times.

          1. Edit and Apply

            To edit a particular record, press the Edit button. To cancel current changes, unpress the Edit button. To commit the changes, press the Apply button. The latter can also be achieved by pressing one of the four navigation buttons. Pressing other buttons may likewise cancel the operation.

            Please note that the Edit button remains pressed until unpressed. That means edit mode is turned on; and records may be edited and confirmed conveniently using the move buttons. This is normally desirable during the editing of several records.

          2. Add and Apply

            To add a new record, press the Add button. Enter entries to the fields, and press the Apply button to commit or confirm the addition.Likewise, the confirmation may also be achieved by pressing one of the four navigation buttons.

            To cancel the addition, unpress the Add button. Pressing other buttons may likewise cancel the operation.

          3. Delete and Apply

            To delete a record, press the Delete button and press Apply to confirm. Again, the second action may be done by pressing one of the four navigation buttons.

            To cancel the deletion, before confirming it, unpress the Delete button. Pressing other buttons may likewise cancel the operation.

      2. Database Menu

        The menu provides items to interface with functions responsible for the creation and update of the database parameters.

        1. Create Item

          When the user issues a new database command by pressing the New File button or item in the File menu, the software will merely clear its memory of the previous database file, but does not yet create a new file.

          Please click this item to create the database file. A database creation dialog will pop up, as shown below:

          Two parameters are necessary: The Locale for Collating Order which will be use to decide how texts are supposed to be sorted; and the Jet Version of the database file to be created. Right now, the latest is version 4.0, which is the default and supports UNICODE encoding.

          One more beneficial parameter allows for encryption of data, which hides the data stored from other softwares not capable of opening mdb files.

        2. Refresh Item

          The database file currently handled by the software may be simultaneously edited by more than one users. To reflect the latest state of the database, please click this item.

      3. Tables And Queries Menu

        This is responsible for the creation, removal, or update of tables and queries.

        Two approaches are provided to achieve this. The first approach is with the aid of a table or query wizard; and the second is th regular unaided table or query creation.

        1. Wizards

          At this time, only one wizard ia available, the Deck Maker. Click the item and the Deck Maker dialog will show up like the one shown below:

        2. Regular Table and Query Creation

          Not yet active. Please refrain from using it because it still has undesirable effects.

      4. Database

      5. General Parameters

      6. Data List

      7. Fields List

      8. Sort Definitions (Index)

      9. Edit Data

      10. Edit Field

      11. Edit Sort Definitions

    6. TalkView

      The controls found in this dialog interface is similar to the ones found in the Field Basic Speech Tab in the FlashCards View.

      1. Talkpad

        There is one important addition which also characterizes the functionality of this view. It provides a talkpad, a UNICODE richedit control the user may use to enter text to be spoken by the speaker nominated. Right away.

      2. Talkies Toolbar and Menu

        The Talkies is responsible for the speaking operations of the view. It provides four buttons.

        1. Talk button

          This button is pressed to initiate the operation of speaking whatever is on the talkpad. The operation may be postponed if the pause button is currently active.

        2. Stop/Reset button

          This button interrupts the current speaking operation. If it is currently paused, both the pause operation and the speaking operation are cancelled.

        3. Pause button

          This button holds whatever is currently spoken or will be spoken, for as long as the pause state is in effect.

        4. Resume button

          This button releases whatever is being paused, and cancels the pause operation.

      3. Edit Toolbar and Menu

        The buttons found in this toolbar are standard edit buttons for use with the talkpad, and other text receiving controls.