MS Access New User

[Alex501]

Hi All

I've never used Access before but have been tasked with creating a DB which is as simple as possible to use for the end user.

Ideally it needs so be a simple front end that they can use the seach and add customers.

Is Access the best tool for this or shall I look elsewhere?

Thanks

Alex

 

[ranman256]

yes, best tool but there's a learning curve since it's NOT excel.
most everything can be done with macros.

make a form, fFind,
then add a box for the search word, txtWord
then make a query to open the data using this word
qsFind = select * from table where [lastName]=forms!fFind!txtWord

then make a macro to run when the Find btn is pressed:
in macro: mFind
add event: OPENQUERY
qry name: qsFind

add the macro to the button event: ON CLICK

 

[Alex501]

yes, best tool but there's a learning curve since it's NOT excel.
most everything can be done with macros.

make a form, fFind,
then add a box for the search word, txtWord
then make a query to open the data using this word
qsFind = select * from table where [lastName]=forms!fFind!txtWord

then make a macro to run when the Find btn is pressed:
in macro: mFind
add event: OPENQUERY
qry name: qsFind

add the macro to the button event: ON CLICK

Thanks Ranman, I'll give it a go - most likely be back.

 

[Joe4]

Note that there are many pre-made Access database templates (some of them free) that you can find which a simple Google search.
So maybe search on things like "microsoft access customer database template".