Need Help On Macros

Hey I'm really a newbie at this program, and I'm trying to design a simple form that will contain macros that when clicked, can perform query functions like sorting all duplicate records, unmatched records etc.

I know that I have to create the querys of course, but I just cannot figure out how to design the macros. Could anyone help?

I would like to set it up to have a splash screen on startup and hopefully have it as a switchboard for user comfort.

Thanks in advance for advice.

Mianji

This is a broad question and is hard to explain without some background in databases. Access has a form for switchboards and you can assign buttons to tasks and you can use the wizard to help in that respect. Splash screens you can design a form like a splash screen and place a button on it to close it. Startup will require you to start the splash form first and the button on the splash screen to open the switchboard. You can get more invovled by setting a counter and automating the splash to close on its own but that would require Visual Basic programming and it doesn't sound at this stage you have that experience. The sorting tasks you want to do require you to create queries and save them. Create a subform on the switchboard form. Run the queries useing the subform by attaching the queries to the buttons. You will need to know some VBA to do this. I see know way around this. A basic access book will have the basic VBA coding you would need. I hope it helps alittle.