I am doing a data base in my company and the current time ..

I chose Access because its what I am mostly fammiler with and I find it intresting.

Any way, I am sure from time to time I would need help as I am new to Access too.

My first question:
How to make the field size accept large numbers example: ID Card number??
The field size is for the tables

Table>Design View>...select the type of data you want.

Text is usually fine. Field size will default to 50 for text. Now you can specify in the lower box below...the size of the field and other options for this fields data.

yah jack .. I know that .. but I was talking about numbers ..

I go to tabels>design view>number> (and here is my question, I want to fit in ID numbers and account number .. both integer and long Integer do not fit .. what type shall I use? )

Don't use number....use text. I know this sounds backwards, but If my memory serves me you want to use text as field type.

Then you can set a "input mask" (ie format) that will make you add the correct number or format of your field.

Like a telephone number would be 555-555-5555

Once you set the mask it wont accept the data in any other format it has to be exactly like you set your input mask.

Oh Thanx!!

it worked :D

ok Question 2:

if I have already created table field .. and then I managed to find the data I want in other tables (seperated, meaning differnet tables for all the information I need), can I copy paste the data into the new field I created, or at least import it?

Yes you can copy and paste from other tables.

You can also import...File>Get External Data>Import

Thanx Jack ...

hmm you are now officially employed as my personal computer speed-feedback assistant :D

Thanx, and if I need any more help I will ask again here .. am doing fine now :)

Your welcome....the least I can do for a Princess ;)

and my fees are cheap....:D

hmmm jaack .. u asked for trouble .. another question poped up now :p

Qurstion:
If for example, I have a field that could contain multiple data. how can I join them along with other tables?
exp: Allowances. A employee have allawance type A, B, and C. along with all his other informations, I want to specify those allowances and the amount.

What I did was, I created another table with all the information I need. I set the Autonumber as my primary key and so I am planing, to enter the employee name and staff number more than one time. so for example, when I search for the data, it gives me all the allwances I need.
Is this the only way???

Relate the two tables with a common field.

Use the relate button on the menu bar to do this.

Once you get all your tables built like you want....build a form that you can enter all data in one place and it will add the data to the correct table.

but I still need to enter the employee staff number in the second table more than once so I can have the extra data, right?

Yes I think so :confused:.....I havn't done this in a while. The "employee staff number" can be your common field you use to relate the two tables.

thanx Jack ..
I didnt reach to that level yet any way ... will update you when am there then :)

back with questions :)

Well I wanted to created a search query ..

I refered back to my school notes .. and the query given there was:

[eployee name ":"] --- > for exact search
and
Like "*" & [employe name ":"] & "*" ---> for partial search


however, when I creat this query .. the result brings me the single entry but repeated again in the number of total entries.

isnt something wrong with the data (the single entry is not repeated in the data itself) or with the query?