Aquarium database system. Basically, if you know how to work aquariums. That's it!?
I am creating a database system (using MS Access 2003) for an aquarium. So I want to know how they work. Large aquariums with many types of fish, not the lil fish tank systems. I have taken these things into consideration: + Number / Type of Fish + Tanks / Location | Name | Type | CO2 Levels | pressure | Minerals | Temp | Food Equipment used + + Stock / Supplies | Power | Waste | Chemicals for water balance nutrients + Personnel assigned to food or health screenings. These are some of the ideas, but I was wondering if there is something else to consider. Also if anyone knows how I structure my database that would be useful. Any response is Related accepted ~ Even if it's short! Thanks
In addition to the parameters you have, you can also include the ammonia, nitrites, nitrates, pH, dH, salinity and oxygen levels (these are the factors that usually cause the biggest problems with the health of fish). Also might want to look at life plants, algae, corals, housing and skins, tank size, chlorine, chloramines, filters, filters, pumps, tidal, heaters, coolers, lighting and décor. As for the structuring of the database, how the structure that depends on what your goal. Think about the kind of reports are to write – you wish to print reports based on aquarium depending on the type of fish? Or do you want to print a report based on staff? If you want flexibility to several reports, will be easier in the long run to make the table smaller and more concise. Example – make a table with fields for general aquarium the name of the aquarium, the aquarium's location and the number or name of the tanks that have. Make an independent staffing fields for the name of the officer, working in the aquarium, etc. Make a separate table for tanks with fields for the type of fish you have, how many fish, a member of staff responsible and perhaps a table Separate terms with the fields to which date the data was taken the tank, the fields of the various parameters – such as levels of nitrites, etc. You can also create a table of fish with the type of fish, water quality ranges for different parameters, etc. Create table relationships that link them. Then you can run queries to create the exact reports you want or to make it easier to enter data (for example – can create a form with the table of tanks — and a subform in it for the conditions.) If you want to be able to perform calculations on data, be careful what you choose for your type of field. Many calculations can run in fields are the "text" type. If you want to save calculations as data instead of running them every time you print a report or see a form – Make sure you have fields in the table of results, then write a macro or event procedure to copy and paste the calculation into the field on a form. I have not worked with Access 2003 (we use 2000) and 2000 lets you write macros in the tables – you have to do in ways – but maybe 2003 has changed this. Definitely begin by deciding how they want to "work" the database before creating it. The answer to that question will determine how to structure the entire database. Good lucky!
co2 System Planted Aquarium
|
|
O2 Medical Oxygen Tank Cylinder Regulator 0-15 lpm $22.99 A BRAND NEW NEVER USED CLICK STYLE OXYGEN REGULATOR Comes in sealed Manufacturers box ********0-15 LPM******* Comes in green, picture shows blue * All-metal construction provides greater durability than plastic. Anodized aluminum will not rust |
|
|
Instant Ocean Omnivore Marine Grazing Block $4.12 Instant Ocean Omnivore Marine Grazing BlockGreat for supplementing the diet of your marine algae grazing fish, Instant Ocean Omnivore Marine Grazing Block is a protein based, revolutionary grazing food form that is formulated for day-long feeding. Marine fish have demanding nutrition needs. Instant Ocean offers a variety of scientifically formulated food types and formats that create a complete an… |
|
|
Fluval Ceramic 88g-CO2 Diffuser – 3.1 Ounces $6.48 A7548 Fluval is a world leader in quality aquatic products. For over 30 years Fluval has earned the trust of fish hobbyists by delivering the highest quality, most innovative products in the industry today. All Fluval products are designed to deliver performance that exceeds the expectations of the first time aquatic consumer to the most advanced fish hobbyist. Fluval products include the world’s… |
|
|
Pondmaster PMK190 190gph Pump and Filter with Bonus Fountain Head $115.00 An exact reproduction of the very early, rare houdini metamorphosis – printed on 65 lb ivory paper. Packaged in its own tube……. |
|
|
Thomas And Friends Wooden Railway – Circus Train Learning Curve $15.29 Kids who love Thomas the Tank Engine may recall the fun when Henry and the Elephant came to the Island of Sodor via the Circus Train. Made of sturdy wood and plastic, this set of three cars comes with five wooden animals: an elephant, a lion, a tiger, a zebra, and a giraffe. Like all cars and engines in the system, these link together via a sturdy and reliable system of magnets. Use them as compon… |
|
|
Aquarium Supply Buyers Guide – Best Practices for Keeping Fish Revealed $2.99 Many people think that Fish are easy to take care of, but the truth is, maintaining an aquarium needs to have great amount of dedication and hard-work. Aquarium Supply Buyers Guide lets you get to know more about aquarium maintenance as it gives information about what type and size of aquarium to choose and what to place inside the tank. This book provides you with knowledge on some of aquarium’s … |
|
|
A heat pump system with a latent heat storage utilizing seawater installed in an aquarium [An article from: Energy & Buildings] $8.95 This digital document is a journal article from Energy & Buildings, published by Elsevier in . The article is delivered in HTML format and is available in your Amazon.com Media Library immediately after purchase. You can view it with any web browser.Description: This paper introduces a heat pump system with a latent heat storage utilizing seawater installed in an aquarium. Heat from the seawater i… |
|
|
Pure Energy 20oz CO2 Tank (graphic may vary) $14.99 The Pure Energy 20-ounce CO2 tank is ideal for all levels of paintball play. Powered by Pure Energy technology, the tank ensures a consistent recharge rate while you’re in the field for maximum shooting efficiency. The tank offers such features as a recessed Pure Energy repeater valve that connects easily and conveniently to your marker, a safety purge valve installed from the factory, and durable… |
|
|
AQUATEK CO2 Paintball Tank CGA 320 Adapter $16.99 With this adapter, you can attach a CO2 regulator with CGA 320 thread to a paintball CO2 pin valve cylinder. Enhanced safety feature: pressure relief hole relieves overpressure when dettaching the adapter from CO2 cylinder (CO2 solenoid regulator and CO2 tank are not included; for demonstration purposes only)… |
|
|
AQUATEK CO2 Regulator with COOL TOUCH SOLENOID $79.99 Aquarium: Perfect for calcium reactor and Freshwater Plant CO2 injection applications. Calcium Reactors and CO2 fertilization require far more precision in their dosing. Our Deluxe CO2 Regulator with solenoid is the best we’ve seen. Unit comes with dual gauges each with dual reading of both psi & kg/cm. Left gauge meters tank capacity and right gauge output pressure. Green… |
Leave a Reply