Learning

Feb 24, 2005

Hi everyone . I am very new to the database world . I have been creating a basic "flat table" for a fishing club i belong to . We hold major auctions twice a year and i have been desiging booking in forms to enter in information about the product for auction etc.I have managed to create my table , some queries and reports using access 2000. I have managed to create combo boxes with set parameters . what i need to know is :

1. I have form that has the following fields.
Lot #
Name
Title (combo box containing Mr,Mrs,Miss etc).
Description
Numbr of items ( combo box )
Reserve price

I can enter in values , that is no problem . What i want to know is , if a name or product description ,is already entered into the database how do i set this up so a pull down menus appears with existing values , or if the name or product description is not currently in the table i can enter in the new information. ( i hope you understand what i am saying).

My auction table consists of the following:

ID ( auto generated)
Lot # (number)
Name (text)
Contact number (number)
Description (text)
Number of items (number, combo box)
Reserve price (currency)
Auction Price (currency)
Money paid to seller (currency)
Nett$ (currency)
Invoice (text, combo box "yes or No")
Invoice # (number)

Any help would be much appreciated.

chris :rolleyes:

View Replies


ADVERTISEMENT

Access Quick Learning

Jun 15, 2005

Hello everyone, I am new to the forums. I need to learn Microsoft Access very quickly, but I do not understand a thing! I have a list of features of Access that I need to learn: what they are and how to execute them. Could anybody help me please?

The features include:

Field-type
Field-insert/delete
Query – create using criteria
Record – insert/delete
Sort-simple
Structure – file/table
Objects types
Form – columnar
Form – tabular
Form – header/title
Report – create
Report – query report
Filter

Thanks

View 3 Replies View Related

Learning About An Unfamiliar Access Setup?

Aug 8, 2006

I've just been given the task of "fixing" a too-big Access database. It's actually about 250 tables in 29 .mdb files scattered over a filesystem. But I'm very green at Access (although I'm pretty OK at SQL in general). So here's my question: how the heck would you all explore/learn about this Access setup? Is there an automated way to cruise through all the .mdb files, get lists of all the tables, and even lists of field names? What about getting a list of the type & relationship of each field?I know I can get some of this by opening a file, right-clicking on a table, and selecting "Design View." But doing this 250 times sounds painful, and the properties window cannot be printed, anyway.Any tips about this?-Tony

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved