How can I create a query that will bring up all the accounts that I created since yesterday or week ago? What condition?

Use Query Builder. Add a condition where the CreateDate is within the last X days - in the drop-down you will find "within" as an operator for columns that are dates.

Mike