Docstoc

database

Document Sample
database Powered By Docstoc
					House    Size          Bedroom       Name




House    Size          Bedroom
First           1200             2
Second          4400             4
Third           1800             2
Fourth          1200             3
Fifth           5000             5
Sixth           1000             1
Name                     Type            What
database                 Worksheet       Where all the data is stored - both that original and that obtained from the user
output                   Worksheet       Where all the output is going to show up
alldata                  Range           The range for the database, on "database"
yourchoice               Range           The range for the user's preferences, on "database"
size                     Cell            The cell for the user's size preference, on "database"
bedroom                  Cell            The cell for the user's bedroom preference, on "database"
getinformationuserform   Form            To collect preferences from the user
sizelistbox              Listbox         Provides size choices
bedroomlistbox           Listbox         Provides bedroom choices
showcommandbutton        CommandButton   Runs macro to store user preferences and to filter database in user form - getin
exitcommandbutton        CommandButton   Runs macro to exit user form - getinformationuserform
nametextbox              TextBox         Obtains user name in user form - getinformationuserform
username                 Cell            The cell for the user's name, on "database"
al and that obtained from the user




on "database"



o filter database in user form - getinformationuserform

tionuserform

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:1
posted:3/13/2013
language:English
pages:3