Start learning with our library of video tutorials taught by experts. Get started
Viewed by members. in countries. members currently watching.
In Access 2010 Essential Training, Alicia Katz Pollock gives a comprehensive overview of creating databases in Access 2010, whether using predefined database templates or building from scratch. This course covers each step of constructing and modifying databases for custom purposes, as well as working with tables, forms, queries, macros, and reports and charts for record keeping and analysis. Exercise files are included with the course.
Reports also have another view, the Design View, which gives you complete control over your report. Understanding it, helps you with designing your reports, and you can use it to make freestyle changes. We explored many of the Design View features in the chapter about forms. So we're just going to highlight the ones most relevant here for our particular reports. Scroll down on the Navigation pane, and double-click on the Sales Reps Phone List Report. Here's what it looks like. Now, come up here to the Views, drop it down, and choose Design View.
Now let's look at the parts. There is a Report Header and a Report Footer. These appear at the top and the bottom of the report itself. This will be on the first page. This will be on the last page, no matter of how many pages the report is. The Page Header and the Page Footer will appear at the top and bottom of every single page in the report, whether it's one page or ten pages. Then the Detail will repeat itself over and over again for every record in the table.
Click on the Sales Reps Phone List Report label up here, and let's look at the Report Design tools. These are exactly the same as working in the Layout View. We have our Design tab, our Arrange tab - although most of the features are grayed out in the Design View - Formatting and Page Setup. Let's go to the Design tab. Over here on the right-hand side, we have the Property Sheet. Now, this gives you granular control over every single aspect of your report. It's dynamic, and it will change according to what you're clicked on.
In the Property Sheet, you'll see a Formatting tab - this is everything about the appearance of those controls - the Data, the information contained in the controls, Events, things that happen when you use the controls, a few Other features, then All brings them altogether in one long list. Now, click again on this Sales Reps Phone List Report, and then come over to the Property Sheet and go down to Special Effect. Right now, it says Flat. Click on it, and use the dropdown, and choose Raised.
Now, let's go take a look. Go back to the View, and toggle back over to the Report View. Now, our title has a nice 3D look to it. Click back on the Design tab, and go back to the View button, and click back on Design View. Working in the Design View allows you to modify your report down to the smallest detail, giving you complete control over its appearance.
Find answers to the most frequently asked questions about Access 2010 Essential Training.
Here are the FAQs that matched your search "":
Sorry, there are no matches for your search ""—to search again, type in another word or phrase and click search.
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.