Viewing Thread:
"Anyone Good with Microsoft Access?"

Trying to do A2 level coursework at the moment and need some help with input masks; validation rules; queries and visual basic.

I'll post what i need help with here in the next few days if anyone can help.

Trying to do A2 level coursework at the moment and need some help with input masks; validation rules; queries and visual basic.

I'll post what i need help with here in the next few days if anyone can help.

There are a few people on here who will be able to help. I would help but it's been 18 months since i used it.

Try getting a book from the library. Access made simple is brilliant. Or the book do just about everything with access pretty much answers everything you really needed to know about access even the options.

Shepps 123 wrote:
> I'll post what i need help with here in the next few days if
> anyone can help.

I can probably help with most things. If not, I know a man I can ask...

I could probably dig up my old revision notes, that's if I didn't burn them (which is likely)

I did the same sort of thing at A2, and I can remember a few things, but unfortunately it's some months since I was building my damned database.

Input masks... I think 0 is a compulsary number and 9 is an optional one, L for letter? Jeez, I should know more than this!

Lots of online guides for visual basic, once you've got the commands in front of you it isn't at all bad. Append queries can be done without it though, if I remember correctly, I expect you'll need to use those.

Does anyone know how to create prescence cheks to check that dat exists in another table.

Access is a thoroughly nasty way to learn databases.

Can't help, sorry :p

Another thing, is it possible to manually chnage the bakcground colour of the database to a custom colour.

what do you mean, background colour? The form colour? table colour?