This class is all about charts and graphs, what they do, why
they're useful, and how to build them. We'll learn about the different
parts of a chart, such as the axes, gridlines, legend, and title. We'll
see how to incorporate charts into our Access forms and reports.
We will learn lots of different chart formatting techniques, how
to customize the individual components of a chart, and how to fix chart
We'll learn how to build many different kinds of charts, including 3D
column charts with multiple data series.
You will learn how to build Pie Charts, and create data labels
and leader lines.
Next we will begin building a Dashboard form for our database.
We'll start by setting up some support queries, such as sales by rep for
the previous 30 days.
Then we'll construct the Dashboard form so you can see all of the
important information from your database summarized on one form.
This is the 31st class in the Access Expert series. If you're
serious about building quality databases with Access, and you have any
interest in charts, don't miss out on
this course. Of
course, if you have any questions about whether or not this class is
for you, please contact me.
Complete Outline - Access Expert Level
00. Intro (4:55)
01. Charts 1 (11:22)
What is a Chart
Why are Charts Useful
Horizontal X Axis
Vertical Y Axis
Chart Title & Legend
Create a Sales Chart
Add Chart to Form
02. Charts 2 (10:52)
Chart Formatting Options
Edit Chart Title
Format Data Series
Clip, Stretch, Zoom
03. Charts 3 (10:40)
Transparent Chart Background
Multiple Data Series
3-D Column Chart
3-D View & Effects
04. Charts 4 (12:03)
of First Slice
05. Charts 5 (9:28)
by Rep previous 30 days
06. Charts 6 (11:13)
in a Report
07. Review (4:49)
Charts & Graphs, microsoft access tutorial, microsoft access tutorial, microsoft access training, bar, line, pie, 3D, formatting