How To Create Mailing Labels

Document Sample
How To Create Mailing Labels Powered By Docstoc
					               DB2000 From Scratch
Loading DB2000 from the Internet

This will tell you how to go to the USPS website and download the actual
DB2000 program onto your home computer.

  1. Get to the USPS Home Page
  2. Click “Site Index”
  3. Click on “Information Technology”
  4. Click on “USPS Software:
  5. Click on “DB2000 support”
        a. Notice the choices you have. This is a good
           reference for “Tips & Tricks” “Examples”
           “Tutorials” etc. Play around – you can probably
           answer some of your own questions there.
        b. Notice “Useful Documents and Help Links”. This
           is where you will find the tutorials I am unable to
           give you today because of time limitations.
        c. I suggest you subscribe to the DB2000
           Notification Mailing List. A place to ask questions
           and get answers.
        d. There should be only one designated person i.e.
           Secretary, Database Manager, or IT person that
           manages ALL uploads to National.
  6. Click on “Downloads”
DB2000 for Beginners
2 of 29



              a. I‟m going to assume for this training that you do
                 not have it loaded on your computer.
    7. Click on “Download Full Distribution for all Windows
       systems”. The latest version is 9.3.0.0 as of 11/3/08.
    8. Click on “Save File”
    9. Depending on your browser it may or may not ask you
       where you want to save the file. This is a “zipped” file
       and has to be “unzipped” in order to install the
       program.
    10.    After the file has been downloaded and saved,
      find the file and install it.
    11.   It will ask where to install it – it will probably
      default to C: Program/Files.
    12.  Let it unzip, after which a series of “Install Shield”
      messages will appear and have to be answered.
      Answer them.
    13.   If the DB2000 icon is not installed on your
      desktop, click “New Programs” and find DB2000.

Installing MQ Series Client
This is not a “required” program yet but it does have very distinct benefits.
     It is an “instant” file with all the latest information from National.
     It‟s fast.
     It takes no human interface at National.
     Accessible 24 hours a day.



File: F:\pdf\6ff9dc0c-7023-4b7b-8385-25a16538815c.doc
DB2000 for Beginners
3 of 29



As a matter of fact, National is really pushing using this method in
preparation of dropping the email roster files altogether – stay tuned.


    1. Click “Download MQ Series Client for
       WIN/NT,2000,XP”
              a. Choose what version software your computer is
                 running – VERY IMPORTANT!
    2. Do the same steps as you did for installing the
       DB2000 program – downloading, unzipping, etc.
              a. The benefit of this program is that you can
                 download a roster in “real time” vs. having to
                 send a request for a roster to National and them
                 to return one.

Downloading a Roster File

You MUST download a roster file to supply your particular data to your
computer.

    1. Before you can download a roster you have to put
       your information into the “settings” field.
    2. Click on “Settings”
    3. Click on “User Authorization”
    4. Fill in the information including your district/squadron
       number, your name, and your password(s)




File: F:\pdf\6ff9dc0c-7023-4b7b-8385-25a16538815c.doc
DB2000 for Beginners
4 of 29



              a. These passwords are issued by your
                 Commander and are renewed every June. We
                 will discuss passwords later in this training.
    5. Click on “Download Roster” or “Request Roster From
       Website”
              a. If you request a roster from website, you have to
                 wait for National to receive the request and you
                 will get an email with a file attached. You might
                 get the file in a few minutes or it may take a day
                 or two. If so, you might have to call Lynnda
                 Stevens at National. Once you receive the file,
                 You need to save the file in the DB2000
                 program/root file.
              b. You can only “Download Roster” if you have the
                 MQ Series Client installed properly. This is an
                 immediate download directly into your DB2000
                 database. It will take approximately 2 minutes ±.


                          Only Squadrons can upload BDU data!!!
                           (See the 'How To Update The Squadron
                           Database'). The 'Update' password should
                           only be given to one or two people in the
                           Squadron or District; The 'Master' password
                           should be retained by the Commander only.
                          If you are going to make changes make
                           sure you have the latest dataset
                           version!!!!


File: F:\pdf\6ff9dc0c-7023-4b7b-8385-25a16538815c.doc
DB2000 for Beginners
5 of 29



Updating your roster file

1.       DB2000 will remember this setting for future
         downloads. The passwords change in June each year
         and the new ones are sent only to the Commander.
2.       On the main screen select 'IMPORT'
3.       Select 'DOWNLOAD ROSTER' (You should see a
         funny little man with flags with download progress
         messages)
4.       On completion a Download complete box should
         appear, select 'UPDATE NOW'
5.       Now an ' UPDATE DATABASE' box should appear,
         Select 'CHECK ALL' and then 'UPDATE'.
6.       The box will show the changed records, look it over
         just to see what you have, then click 'FINISH'.
7.       That's all there is to it.
Downloading EMM Slideshow Presentation
Download this file if you will be doing the merit mark report for your
squadron.

     1. Get to the USPS Home Page
     2. Click “Site Index”
     3. Click on “Information Technology”
     4. Go to the DB2000 Information Index
     5. Click on “Useful Documents and Help Links”


File: F:\pdf\6ff9dc0c-7023-4b7b-8385-25a16538815c.doc
DB2000 for Beginners
6 of 29



    6. Click on the “EMM PPS” link to download the file. Just
       remember where you have save the file OR???????
    7. The file is not zipped. It is a PowerPoint Slide Show.
       Find the file and click on it to run it.
Things to remember:
     Download the “How Do I Do EMM?” Tutorial from the
      DB2000 Tutorial page. Very good information.
     You are only allowed 438 characters in the
      description field. It does not allow for a magnum opus.
     If you teach a course, that‟s your merit mark. You do
      not need to enter any information in the “valuable
      services performed field.
     The merit mark monitor for the district and the
      squadrons within the district are the same. In our case
      it is PCC Richard Miner. Due by November 15th.
     Each squadron commander should have gotten
      information regarding merit marks from National via
      an email.
     There is now a spell check function in the merit mark
      program. Use It!
     Only one person, either the Merit Mark Chairman or
      Commander should be working with the merit marks
      portion of DB2000.
If time allows I will go into the merit mark section and
give a brief overview.

File: F:\pdf\6ff9dc0c-7023-4b7b-8385-25a16538815c.doc
DB2000 for Beginners
7 of 29




Okay! Now we have the program(s) installed and the data
loaded. It is now time to play with the program and see
what trouble we can get into.

DB 2000 or the Computer Challenged

How To Create Mailing Labels
How To Create Mailing Labels In Zip Code Order
How To Update The Squadron Database
How To Download Updates For The DB2000 Databases
How To Use 'The Magic Page' Or The 'Query Roster' Facility
How To Build a Basic Report , The Down & Dirty Roster Printer
How To Send An Email Note To Selected Members
How To Create The 'OD1/2' Forms



How To Create Mailing Labels

This is based on the District Database; if you are using the Squadron
Database, skip the first step...


1.       On the DB2000 'Main Page', select the desired
         squadron of choice or the entire district...
2.       On the top selection bar (white) select 'Reports'
3.       Now select 'Print Roster Info'
4.       Select 'Complete Roster'
5.       Select 'Label (Avery 8160)'




File: F:\pdf\6ff9dc0c-7023-4b7b-8385-25a16538815c.doc
DB2000 for Beginners
8 of 29



6.       The little green things represent the Avery Sheet of
         labels. If you are using a partial sheet of labels, select
         the ones already used. 'Clear All' and 'Set All' are
         options here.
7.       The display area of the screen will show you the
         Label layout
8.       In the 'Record Content' block:
9.       Select 'Row 1', then the name format you want to use.
         ('Rank First Last, Grade' is a good choice), Click
         'ADD'.
10. Select 'Row 2', Then 'Street Address', Click 'ADD'.
11. Select 'Row 3', Then 'City State Zip'. Click 'ADD'.
12. Select 'Cleanup' (removes some garbage characters)
13. Select 'Barcode' if you wish to add Postal Barcodes. (I
    have never used this.)
14. Select 'Print'. This will print the selected page. I
    strongly suggest that you only print one page at a
    time, since the label forms tend to jam. The first 'Print'
    should be on plain paper to make sure that it is
    correct and placed right.
15. You can go to “Save or Retrieve Page Layout” and
    save this report as “Mailing Labels” if you choose.
              a. In the blank type “Mailing Labels”




File: F:\pdf\6ff9dc0c-7023-4b7b-8385-25a16538815c.doc
DB2000 for Beginners
9 of 29



              b. Click “Save” – this layout will now be saved and
                 we will touch on this again later.
How To Create Mailing Labels In Zip Code Order

This is based on the District Database; if you are using the Squadron
Database, skip the first step...

1.       On the DB2000 'Main Page', select the desired
         squadron of choice or the entire district...
2.       On the top selection bar (white) select 'Reports' then
         'Query Roster'
3.       Select 'All' in the Member Type Box
              a. (You can modify this to select the particular group
                 you wish to mail to.)
4.       In the 'Order By' box select 'Zip Code'
5.       Select 'Find'
6.       Now select 'Print'
7.       Select 'Label (Avery 8160)'
8.       Format the rows in the label as described in the
         Mailing Label 'How To'


Dual Address Members – NEW!

     Many squadrons have the problem of tracking dual
     address members. National‟s database does not


File: F:\pdf\6ff9dc0c-7023-4b7b-8385-25a16538815c.doc
DB2000 for Beginners
10 of 29



    support this but DB2000 can support it locally using the
    following rules.

     Members selected for dual address support will no
      longer have their address and related fields updated
      by roster imports from national. This is because there
      is no way of knowing what data currently resides in
      the HQ database. Remember that individual members
      will often advise HQ of their current address to make
      sure they receive their Ensign.

     Any time a dual address member‟s current location is
      swapped, the BDU upload list can be optionally
      updated for the next upload to HQ.


              o What this says is, when you do your next upload,
                that address listed either home or away is the
                address that will be going to National. If you were
                do redownolad the roster, it will show that
                address!



    There are two columns in the roster grid, “DA” and
    “Swap”. To assign a member to dual address status,
    select the “DA” cell in the member‟s row and press
    Enter. This will raise a dialog asking in which location to
    assign the current address. Make a selection and the
    cell content will reflect this with “H” for home or “A” for
    away. The grid can be toggled between the two by


File: F:\pdf\6ff9dc0c-7023-4b7b-8385-25a16538815c.doc
DB2000 for Beginners
11 of 29



     double-clicking or pressing Enter on the “Swap” cell.
     Alternate address information can be entered into the
     grid directly by editing the grid cells, or the BDU form
     may be used which will reflect the current location
     selected.

     If, for any reason, the two locations get reversed, this
     can be corrected using the “Swap H & A Labels” menu
     selection exposed by clicking the Tools button at the top
     of the roster form. NOTE: This only exchanges the “H”
     and “A” labels, it does not exchange the address data
     shown on the grid.

How To Update The Squadron Database

This is based on the District Database; if you are using the Squadron
database, skip the first step...

1.       On the DB2000 'Main Page', select the 'Squadron
         Database'
        a.        Select 'File'
        b.        On the drop down select 'Select Primary
                  Database' It will look like 'DBSQD.MDB'
        c.        Select 'Change Database'
2.       On the second selection bar (blue) select 'Roster'
              a. (I recommend downloading the latest roster
                 before making any changes.)



File: F:\pdf\6ff9dc0c-7023-4b7b-8385-25a16538815c.doc
DB2000 for Beginners
12 of 29



              b. As a matter of fact, if you have not downloaded a
                 new roster within the last 60 days, you will
                 receive a note stating so and it will ask you if you
                 want to download a new roster.
              c. Do as you choose at that point
3.       Now select the member's name you wish to modify,
         the selected line will turn blue...
4.       Select 'BDU' on the top selection bar
5.       Select 'The white box next to the information you wish
         to modify or add' (it will become a pale blue)
6.       Select 'Edit' and change or add the data, the box will
         turn a pale red.
              a. (Only the data boxes shown may be changed, all
                 other data is maintained by National.)
              b. NOTE: 'Cell Phone' is not a selection. You can
                 add them to your private database in the 'COMM'
                 section of the program.
7.       Hit 'Enter' to move to the next box
8.       When you have entered all of the changes click 'OK'
         to save them or 'Cancel' to not make the changes
9.       Use the 'Navigation' selections to move to other
         records in the database




File: F:\pdf\6ff9dc0c-7023-4b7b-8385-25a16538815c.doc
DB2000 for Beginners
13 of 29



10. Select 'Roster' to return to the updated roster. The
    changes will remain in the database but will not be
    uploaded to the National Database.
              a. Up to this point you have not changed the
                 National database.
              b. Play with it all you want. The worse case will just
                 require reloading the database with a fresh copy.
              c. Push the buttons and learn the program...
11. Now we are getting serious and will update the
    National database. You must have the 'Updaters'
    password.
12. On the Main Page, select 'Export' then 'Roster' then
    'Review/Send Current Changes'
13. You will be presented a page with the changes that
    are going to be uploaded for your review. Check it
    carefully.
14. You have several choices to assist you ON THE TOP
    BAR, They are obvious in their actions, play a little if
    you wish.
15. Now we are at the critical point and will be making
    changes to the National Database. Once you are
    satisfied with the changes to be made hit 'Send' and
    watch the little man with the flags as the data is sent.
    You will get a message showing the outcome of the
    transaction.



File: F:\pdf\6ff9dc0c-7023-4b7b-8385-25a16538815c.doc
DB2000 for Beginners
14 of 29



16. As soon as the transaction is complete, you or
    anyone else can download the database with the
    changes. It is also immediately reflected to the District
    Database.
17. Once you have done this a couple of times you can
    make a change in only a couple of minutes, even on
    dial-up.
How To Download Updates For The DB2000 Databases

8.       On the main screen select 'Settings' then 'User
         Authorization'
9.       On the top box, use the arrow to select 'Your Name'.
         This will also enter your certificate number.
10. Enter the appropriate 'Password'.
              a. There are three passwords for each District or
                 Squadron:

                          The 'Master' password that can change the
                           other passwords
                          A 'Update' password that allows uploads of
                           BDU data or some forms such as OD1 or
                           OD2.
                          A 'Read Only' passwords that allows
                           downloads only




File: F:\pdf\6ff9dc0c-7023-4b7b-8385-25a16538815c.doc
DB2000 for Beginners
15 of 29



                          Only Squadrons can upload BDU data!!!
                           (See the 'How To Update The Squadron
                           Database'). The 'Update' password should
                           only be given to one or two people in the
                           Squadron or District; The 'Master' password
                           should be retained by the Commander only.
11. Click 'OK'. DB2000 will remember this setting for
    future downloads. The passwords change in June
    each year and the new ones are sent only to the
    Commander.
12. On the main screen select 'IMPORT'
13. Select 'DOWNLOAD ROSTER' (You should see a
    funny little man with flags with download progress
    messages)
14. On completion a Download complete box should
    appear, select 'UPDATE NOW'
15. Now an ' UPDATE DATABASE' box should appear,
    Select 'CHECK ALL' and then 'UPDATE'.
16. The box will show the changed records, look it over
    just to see what you have, then click 'FINISH'.
17. That's all there is to it.




File: F:\pdf\6ff9dc0c-7023-4b7b-8385-25a16538815c.doc
DB2000 for Beginners
16 of 29



How To Use 'The Magic Page' or the 'Query Roster' Facility

One of the most powerful tools in DB2000 is the 'Query Roster' facility. With
this tool you can create many different searches in the database and then
send it to the print facility. I am going to give a couple of simple examples
and then encourage you to play with it.

On page 13 of the “DB2000 Workshop”
document you can read over the information and
play with that feature. It includes instructions on
tags and how to use them. There are 4 examples
to work with.
How To Send An Email Note To Selected Members

Make an address listing for the squadron newsletter

How to change information in bulk, i.e. area codes or affiliated
members.


The Squadron Educational Officer will find this extremely valuable for
determining what courses should be taught and then creating mailing list
for the prospective students. I will use such an example to get started on
this adventure.

1.       On the 'Main' screen select 'Reports' then 'Query
         Roster'
2.       Don't panic!!! All of the boxes make it very easy to
         use.
               Take a minute or two and notice how things are
                grouped.




File: F:\pdf\6ff9dc0c-7023-4b7b-8385-25a16538815c.doc
DB2000 for Beginners
17 of 29



               Two boxes are pre-selected so that the default is
                to the entire database. (All Members and Last,
                First)
               We are going to do a very elementary search to
                determine who is eligible for an 'AP' Class.
3.       In the 'Advanced' box, select in the 'Yes' column 'S' &
         'P' and in the 'No' column select 'AP'.
4.       At the top of the page, click on 'Find' and then look in
         the lower left hand box, 'Result Set' for the results of
         the search.
         a. So now we‟ve have caught that bear and now we
            need to skin it...
5.       'Tags' are used to identify individual records that you
         wish to work with. We will be playing with them as we
         go along in several different areas.
                  a. At the top of the current page you will see a
                     box labeled 'Tags' that appears to have
                     something to do with California, 'CA', it doesn't,
                     but rather means 'Clear All'
                  b. This box will be on almost all DB2000 pages.
                  c. This clears all tags that might have been left
                     over from previous searches or file
                     manipulations.
                  d. There is also a 'TA' or 'Tag All' on some pages;
                  e. Click 'CA' so that we have a fresh start.

File: F:\pdf\6ff9dc0c-7023-4b7b-8385-25a16538815c.doc
DB2000 for Beginners
18 of 29



6.       In the 'Do With Result' box at the top of the page
         there are three selections we are interested in.
                  a. The 'Save Query' selection allows you to save
                     a search with a name so that you will not have
                     to rebuild it next time.
                  b. Click on 'Save Query' and a box appears
                     where you can ad a descriptive name,
                  c. I entered 'Potential AP students', then click
                     'OK'.
7.       Now click on the 'Add To Tags'. You have now tagged
         the records we searched out.
                  a. We will be using these in some of the other
                     'How To's'.
                  b. Now lets go to “Do with results” and click print.

                        Click “Print” now you can print mailing labels
                         as in the other examples, etc.
                                 o You can also make a list –
                                 o Click “Roster List”
                                 o Click Name - then add (whatever
                                   format)
                                 o Click “Database Field” – Choose
                                   “Phone” – then add



File: F:\pdf\6ff9dc0c-7023-4b7b-8385-25a16538815c.doc
DB2000 for Beginners
19 of 29



                                 o Click “Database Field” again – Choose
                                   “Email” – then add
                                 o Click “Print” or “Print to End” to print the
                                   list you have created.
8.       Another simple search for example could be “Life
         Members”.
               Lets go back up and click “Reset All”
               On the 'Query' page, under 'Merit Marks' select
                the 'Life' box, then 'Find'.
9.       You now have a nice list, alphabetized by last name,
         that you can use, but now let‟s sequence it by the
         number of merit marks.
               In the 'Order By' box select ‟Merit Marks' and
                then click 'Find'. You now have a list sequenced
                low to high by number of merit marks.
               In a list of this nature, It would be nice to
                sequence it high to low so click 'Descending' in
                the 'Order By' box and your members with the
                most merit marks are on top of the list.
               If you wish to print this, click 'Add To Tags' and
                'Print'. See my 'Down and Dirty Roster How To'
                for detailed print instructions.




File: F:\pdf\6ff9dc0c-7023-4b7b-8385-25a16538815c.doc
DB2000 for Beginners
20 of 29



10. Play around with this page and find out who your
    officers are at National, District and Squadron levels.
    You will probably find a lot of updates are needed.
    The 'Birthday' search is nice if you wish to recognize
    those with birthdays at your meetings or in your
    newsletter.
How To Build a Basic Report , The Down & Dirty Roster Printer

In a previous 'How To Use The Magic Page', we built and saved a 'Query'
for people that were potential AP students. If you have not done that
exercise, do so now and then return to here.


1.       Retrieve the AP Student Query by going to 'Reports'
         then 'Tag From Query' then 'Clear Tags Then Tag
         From Query'
2.       Select the Query 'Potential AP Students' and now
         click it and you will receive a 'Done' message.
3.       You have now tagged the records we searched out.
               Click on 'Reports'
               Click 'Print Roster Information'
               Click “Tagged Records”
         This takes us to the 'Down & Dirty Roster Printer',
         another page we will visit often. We are going to first
         print a list of potential 'AP' students.
         The 'Print Options' default to 'Roster' and '8.5x11'
         paper... Good enough for now...


File: F:\pdf\6ff9dc0c-7023-4b7b-8385-25a16538815c.doc
DB2000 for Beginners
21 of 29



4.       In the 'Page Options' box select 'Header' and enter a
         name for the report such as 'Potential AP Students'
               (The title of the 'Query' might already be in the
                box.) Watch the big white space on the right as
                we develop this report.
               Now select 'Line Sep' 'Bold' and 'Larger Font'...
                Nice title line isn't it. ...
5.       Now drop down to the 'Footer' box and select 'Footer',
         Line Sep' and 'Date'.
               Click 'Today' and select your preferred date
                format. Type in whatever you wish in the box next
                to 'Footer'. I usually enter '*** FOR USPS USE
                ONLY ***'
               If you wish, select 'PN' to add page numbers.
               We have now created a basic page format that
                we will use many times.
6.       Now let's add the records that our search found
         earlier.
               In the 'Record Content' box select 'Row 1' then
                'Formatted Name' then 'Add'.
                                 o (You may select from several different
                                   formats for the name display in the
                                   adjacent box.)




File: F:\pdf\6ff9dc0c-7023-4b7b-8385-25a16538815c.doc
DB2000 for Beginners
22 of 29



7.       Now go to 'Row 2' and select 'Street Address' and
         then 'Add'.
8.       Now for 'Row 3', select 'City State Zip', and 'Add'.
9.       We are going to skip Row 4 for this report,

          Select 'Row 5', then 'Database Field'. This allows
           you to select almost any other data in DB2000
           database;
          we want to add the 'Certificate' number since this
           will be of value if the person enrolls.
          Select 'Cert' and then 'Add'.
10. Based on the needs of the report, you can select the
    number of 'Columns' and 'Text Position' in the bottom
    box. Play with it a little; just leave it the way you want
    the report to appear before going to the next step.
11. This is a basic report that we will use variations of
    many times, so let's save it.
               Near the top of the page find 'Save or Retrieve
                Page Layout' and enter a name such as 'Basic
                Page'. Then click 'Save'.
               The next time you need to print information of this
                type, Use 'Get' and select 'Basic Page' to retrieve
                the format you have saved. You can then change
                the options on the retrieved format as needed.




File: F:\pdf\6ff9dc0c-7023-4b7b-8385-25a16538815c.doc
DB2000 for Beginners
23 of 29



12. At the top of the 'The Down & Dirty Roster Printer'
    page, select your print option of choice. If it is a
    multiple page report you can select all of the pages or
    any one of the pages.
13. Well, we know who they are and we have a list that
    we can use as a guide but we need to let them know
    about the class, 'Mailing Label' time!!! With a few
    clicks we will have that job done.
               (See my 'How To Print Mailing Labels' for
                details.)
               Select 'Label (Avery 8160)'
               then 'Row 1, Formatted Name, Add'
               then 'Row 2, Street Address, Add'
               then 'Row 3, City State Zip, Add'
               and then 'Print' at the top of the page'.
                       i. When I print mailing labels I make a test run
                          before adding the real labels to the printer,
                          and then I feed them one sheet at a time.
                          You can select the page to print at the top of
                          the 'Down & Dirty Roster 'page.)
14. This is another basic format that we will use often so
    let's save it. Go to 'Save or Retrieve Page Layout'
    and enter 'Mailing Labels'. Then click 'Save'.




File: F:\pdf\6ff9dc0c-7023-4b7b-8385-25a16538815c.doc
DB2000 for Beginners
24 of 29



15. We have now gone through a basic search of the
    database and used the results to print a list and then
    print mailing labels. Neat isn't it.... Stay tuned for 'How
    to use Email' rather than the other USPS.
How To Send An Email Note To Selected Members

In a previous 'How To Use The Magic Page', we built and saved a 'Query'
for people that were potential AP students. If you have not done that
exercise, do so now and then return to here.

1.       Retrieve the AP Student Query by going to 'Reports'
         then 'Tag From Query' then 'Clear Tags Then Tag
         From Query'
2.       Select the Query 'Potential AP Students' and now
         click it and you will receive a 'Done' message.
3.       Click 'Comm' and you should see a bunch of phone
         numbers and email addresses.

          Click 'Email' at the top in the tagged records section
           and if your system is set correctly Magic happens
           and you have an email addressed to the potential
           students (provided their email addresses are in the
           database.) and ready for text.
          Time to get the email addresses updated isn't it?
                                 o Refer to the 'How to update The
                                   Squadron Data Base' tutorial that we
                                   have already done.




File: F:\pdf\6ff9dc0c-7023-4b7b-8385-25a16538815c.doc
DB2000 for Beginners
25 of 29



4.       This was too easy, wasn't it? I updated the email
         addresses for the incoming commanders in my
         personal database before I sent the first note in this
         series and then created the email addresses from the
         database.
               You can not upload that information from the
                District Database so it is up to each squadron to
                get and keep the email addresses current.
               The first time takes some time but it makes life
                easier for all of the Squadron and District officers
                after that.
5.       Another method to create your email list is by
         selecting the people you wish to sent the note to
         manually

                   Go to the 'Main' page then select 'Comm'
                   Click 'CA' to clear any old tags.
                   Now select a name you wish to include in the
                    note (the selected entry should turn light blue)
                   Select 'T' in the 'Tagged Records' section at
                    the top.
                   An '*' should appear in the 'Tag' column.
                   If you reselect the name the 'T' will now be a 'U'
                    and you can 'Untag' the record.
6.       Too much trouble? Then do this:

File: F:\pdf\6ff9dc0c-7023-4b7b-8385-25a16538815c.doc
DB2000 for Beginners
26 of 29



                   place your cursor in the 'Tag' column next to
                    the name you wish to add
                   'Double Click' to select the record.
                   'Double Click' again to remove the selection.
7.       Select 'Email' at the top to create the note.

How To Create The 'OD1/2', “H-701” and “H-102” Forms

This is one of the easiest projects I will be describing in this series. The
tough part is getting the people committed to submit the form in a timely
fashion.

On page 21 of the “DB2000 Workshop”
document you can read over the information and
play with that feature.
OD – 1 District Positions
OD – 2 Squadron Positions
HQ – 102 Name Change or Death Notice
H- 701 Historians Report (Paper – Not Electronic)
1.       On the 'Main' page, select the primary database by
         clicking 'File' then 'Select Primary Database'.

          For this exercise select the 'DBD21.mdb'. If you are
           doing this for your squadron, select the squadron
           database, e.g. 'DBSQD.MDB'.


File: F:\pdf\6ff9dc0c-7023-4b7b-8385-25a16538815c.doc
DB2000 for Beginners
27 of 29



          Click 'Change Database' to activate a different
           database.
2.       Back on the 'Main' page select 'Forms'.

          On the District database you will only have The
           'OD' forms as a choice. The squadron databases
           have a couple of others.
          I highly recommend playing with the 'Historian's
           Form', which is one of the squadron choices.
3.       The OD1/2 form will preload with its previous
         information, the current Commander and the current
         date. This is good since a many of the slots are carry-
         overs.
4.       Now highlight the position you are going to enter, it
         will turn a weak green, about like Charles Strong's
         face for the next year. For this exercise, select
         'Squadron Commander' and then in the 'Add/Remove
         Office Holder'
          Select the officer...
          The small box on this line allows you to enter the
           first three letters of a name and indexes you down
           the list;
          Enter 'haa' and then the 'Enter Key'.
          Down the list a little further in the larger box you will
           find 'Haas, Linda'. Click 'Add'.
5.       Now move to the next position and add the next name
         – etc., etc., …..

File: F:\pdf\6ff9dc0c-7023-4b7b-8385-25a16538815c.doc
DB2000 for Beginners
28 of 29



6.       Enter the 'COW Date' for your Squadron or District.
         The Date for D/6 or your Squadron is XXXXXXXX.
7.       Once you have completed the form you can print it
         out by selecting 'File', then 'Print OD Form'.
8.       For our purposes we just want to update our personal
         database, select 'Option' then 'Install New Officers'.


This is the form that the current Commander must send to
National during sometime in February.

How To Do Merit Marks

Only one person in each squadron should be working with the Merit Mark
function in DB2000.

Run the EMM presentation that was downloaded from the
National website.


How To Use Report Wizard



Rep Wiz
  1. Go to the website and find “RepWiz Examples”
     download.
  2. Click on “Download EXAMPLE&.ZIP”
     3. Save the file in DB2000 directory.
     4. Go to „My Computer” and find the DB2000 Directory
     5. Right click on “EXAMPLE7”

File: F:\pdf\6ff9dc0c-7023-4b7b-8385-25a16538815c.doc
DB2000 for Beginners
29 of 29



    6. Click “Extract All”
    7. See the “Welcome Screen” and click “next”
    8. Extract the files to the main DB2000 directory.
    9. Open the “Member Type by Sex ReadMe” file
    10. Print the MSWord document for exact instructions
        on how to work with example 7.
    11. Click on the Reports Menu and select Report
        Wizard
    12. When RepWiz starts, use the File Menu to import a
        Query and import “Member Type by Sex.rqw”
    13. Use the File Menu to Open Report and select
        “Member Type by Sex.rqw”
    14. When RepWiz presents the Report Designer
        window, press the Ctrl+P keys to go to Print Setup
    15. Select your printer and click OK
    16. RepWiz will present the report in Print Preview
        mode. You can scroll and page up and down
        through the report




File: F:\pdf\6ff9dc0c-7023-4b7b-8385-25a16538815c.doc