Adaptive Database/Table

[dagdago]

Dear forum users,

I wish to implement database/table that includes 2 columns: serial number and status field.
The serial number should consist of a 9 digits. The status field should contain one of three words (e.g. monkey, donkey and funky :)).

The databse/table should be empty at first and grow as the users insets new rows at will.

* The application should let the user the option either to add or remove new lines at any time.
* It should provide the option of seraching a row by its serial number.
* and should produce cross sections of the databse/table when asked to.

I'm new to access and don't really now it capabilities. Could any one tell me if this is the right tool? In addition a direction to a source code/lead would be welcome.

Thx, dagdago

[OBP]

Which version of Access do you have?
The requirements that you have laid out are very simple to achieve in Access and Source Code is unecessary.
It can be done with a Table, some Queries and Forms.

[dagdago]

I have access 2003.

Can it provide a user menu for the various options?

dagdago

[OBP]

Yes you can create very sophisticated menus.

[dagdago]

Where do I begin? Tuts? Source file?

[OBP]

Do you have any data currently held anywhere?
The place to start is to create a Blank Database and then your Table with your 2 fields.
Then Create a Query based on your table, the Query Wizard will do that for you.
Finally Create a Form based on your Query, a Form Wizard will do that for you also.
Or alternatively I can do it for you, it depends on whether you want to learn - as - you - go.