|
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
distortion problems.
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
31
00. Intro (4:55)
01. Charts 1 (11:22)
What is a Chart
Why are Charts Useful
Chart Area
Data
Series
Data Points
Chart Axes
Horizontal X Axis
Vertical Y Axis
Chart Title & Legend
Chart Gridlines
Create a Sales Chart
Chart Wizard
Add Chart to Form
Chart Types
02. Charts 2 (10:52)
Chart Formatting Options
Chart Datasheet
Components
Dropdown
Edit Chart Title
Format Data Series
Change
Colors
Fixing Distortion
Clip, Stretch, Zoom
03. Charts 3 (10:40)
Transparent Chart Background
Multiple Data Series
Preview
Chart Button
3-D Column Chart
3-D View & Effects
Elevation, Rotation |
04. Charts 4 (12:03)
Data
Series Shape
Data
Labels, Value
Gap
Width, Depth
Chart
Depth
Format
Walls, Floor
Aggregating Data
Add
Trendline
Pie
Charts
Angle
of First Slice
Data
Labels
Leader
Lines
05. Charts 5 (9:28)
Review
PCResale Database
Sales
by Rep previous 30 days
Chart
Dashboard
Setup
Queries
06. Charts 6 (11:13)
Build
Dashboard
Chart
in a Report
07. Review (4:49)
|
|
| Keywords:
Charts & Graphs, microsoft access tutorial, microsoft access tutorial, microsoft access training, bar, line, pie, 3D, formatting |
