Start learning with our library of video tutorials taught by experts. Get started
Viewers: in countries Watching now:
Discover how to manage data entry and reporting tasks more efficiently using Access 2010. Author Adam Wilbert presents lessons on designing forms, organizing and displaying data with form controls, creating flexible queries, and building a form-based navigation system. The course also shows how to build reports from wizards and queries, highlight important data with conditional formatting, and automate reporting processes with macros.
Throughout this title I'll often refer to the database as end-user and I wanted to take a moment to define who I think this person is and why they're important to keep at the front of your mind while designing your forms and reports. The end-user isn't anyone specific. They're more of a theoretical individual that is completely new to your organization. They maybe a new hire or an intern or maybe, even your grandmother, somebody that knows very little about your day-to-day tasks and even less about how to use Microsoft Access. As you develop your database application, occasionally put yourself in their position and look at your workflows as if you're brand-new to it.
If you can set up your navigation and data entry and reporting systems tailored to the end-user that uninitiated first day on the job employee then you'll be well on your way towards creating a successful application.
There are currently no FAQs about Access 2010: Forms and Reports in Depth.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.