I am trying to create a page in my WordPress Admin Area that displays excerpts of posts and various custom field meta in a table-style layout.

If this were a front-end WordPress Template, I could do this very easily using a WordPress Loop and Query, however, I am not so sure how I would go about doing this on a page in the admin area.

Would it be the same, or would I need to use a completely new method? If so, could someone please provide a working example of how I would do this?

The admin page will be created using an included file within my functions.php - or at least that is the plan at the moment, so I just need help in figuring out how to pull the WordPress Excerpts and Post Meta.