Using Microsoft Access To Organize Your Life

http://www.beyourownit.com -Lean the basic functions of Microsoft Excel. A virtual walk through on creating a database, form, running a query and more. See more information at www.beyourownit.com

Category:

Howto & Style

Tags:

• how
• to
• use
• microsoft
• access
• database
• make
• mailing
• list
• organize
• lists
• query
• in
• table
• create
• advise
• technology

[Danaktsang]

I have data has date in it. I want set up query show me everyting 5days older than that date

[beyourownit]

@Danaktsang Look up SQL how to's.

What you are going to be looking for is something in the neighborhood of Select * from (name of table) Where (name of date field) > or < (date). I dont remember how the boolean operators interact with year dates. This should give you a start in the right direction though.

[lamody]

well thanks for the help!!

[beyourownit]

glad we could help

[lamody]

a database of saving and searching for names,surnames,age,male/female­.. e.t.c

[beyourownit]

sure what your looking for is a query, I can do something like that

[faheeta]

4:05 lmao

[4xEVERMORE]

ssssssssssssssssssssssssssssss­sssssssssssssssssssssssss

[HandA711]

Oh my god 2008... Why are you guys sending me videos from 3 years ago????????

[Coolboy529]

123 fake street? YOUVE BEEN WATCHING THE SIMPSONS!

[BJSteigner]

Can you change the state from WI to another state??



[coldplaywave]

Thanks a lot,mate!It was really helpful.

[bsbeitler]

Useful introduction video showing the back-end tools namely Tables and Queries being designed and used. It's only the start though and you will need to do some more research. If you want help, please contact me for advice. See my blog "AccessDatabaseTutorial" - Thanks to beyourownit for the video tutorial.

[fatrb38]

Excel works better for most of this sorta stuff in my case.  I can even make pretty graphs as well!

The million dollar question is which one is easier to integrate with other Office and non-Office applications?