Access 2007 Training Package
Learn How To Build A Solid, Secure & Scalable Database from Start to Finish
with Microsoft Access 2007!
Over 18 Hours of Hands On Video Training Helps
You Master Database Design Using Access 2007
...and Pass the 77-605 MCAS Exam!
By Heather Ackmann
Microsoft Certified Master
Do you want to master virtually every aspect of Access
2007, inculding all of the hot new features and interface? Would you like to pass
the 77-605 MCAS exam?
Whether you're a beginner or experienced user, this course will help you achieve
all of the above! Most importantly, unlike every other Access 2007 course on the
market, we actually teach you how to build a real, working database from scratch!
Other courses dabble in database design theory. But isn't the whole point of Access
2007 to build databases?
Train Signal's exciting new Access 2007 course will teach you exactly how to build
a robust, scalable and secure database for your organization. We guide you step-by-step
around real world challenges so you can tackle database design & troubleshooting
with confidence!
Why Waste 2-3 Years Trying to Learn Access 2007?
This Course Shortcuts the Learning Curve Dramatically!
 Learn the Hot New Features of Access 2007: the New Interface, Pivot
Tables and Pivot Charts, Queries, Calculations and Built-In Functions!
Create Tables, Forms, Queries and Impressive Reports with Expert Precision!
Why hire an Access consultant? Identify, troubleshoot, and avoid the
most common error messages, yourself!
"Total Experience Training" gives you virtual on the job experience! Build a database for a fictitious company to better manage employees, customers,
products, and sales.
And much more... scroll below to view our entire course outline...
"Can I Take This Access 2007 Training Course?"
 YES! Whether you're a total beginner to database design or Access 2007,
or even if you have self taught experience, this course will fill in the gaps and
provide you the most thorough Access 2007 training anywhere!
YES! If you are familiar with the other Office applications (i.e. Word and Excel) and
have a basic understanding of data entry. This course will get you up to speed and
make you a bonafide Access 2007 expert!
Access 2007 Training Course Outline
Video 1
Introduction
Meet your instructor, Heather Ackmann, as she introduces you to the features of this course
and well as the course design.
* Instructor’s Introduction
* Course Introduction
* Exam Objectives
Video 2
Overview Video
If you’re reluctant to use Access because you’ve heard that Access is
not a very good program, then this is the video for you as I attempt to explain how
Access has acquired a “bad reputation” among some IT professionals and
explain how learning the basics of the program will save you time in the future.
* Introduction to Relational Databases
* Relational vs. flat-file
* Most Important thing to remember: Access is NOT Excel!
* The General Order for Building Databases
* The Scenario for the course
* Building a database for Picaroon Publishing Unlimited, a small literary press,
to keep track of employees, customers, orders, authors, and more.
Video 3
The Microsoft Access 2007 Interface
This is a video for newbies and experienced users alike as I take students on a
tour of the new Access 2007 interface. Just like moving to a new town, taking
the time initially to learn where the grocery store or the hospital is will save
you valuable time “driving around” in the future.
* Getting Acquainted with the Getting Started Screen
* Using Microsoft Access Database Templates
* Creating a New Blank Database in Access
* Opening an Existing Access Database
* Enabling “Certain Content” Using the Message Bar
* The New Interface
* The Microsoft Office Button
* The New 2007 MS Ribbon
* The Quick Access Toolbar
* Dialog Box Launchers
* The Navigation Pane
Video 4
Introduction to Microsoft Access Objects
Designed for complete beginners to building a database, I walk the student through
each of the basic MS objects that make-up a database. Becoming familiar with these
objects is essential to the overall design process. This video is the “birds-eye”
view of everything we will be designing and building in Access. So, if you are like
me and must know where you are going before you go there, you’re going to
appreciate this video.
* Types of Basic Objects
* Tables
* Queries
* Forms
* Reports
* Getting Familiar with Basic Views in Access
* Datasheet View
* Design View
* Form View/Report View
* Pivot Table View
* Pivot Chart View
* SQL View
* Layout View
* Print View
* Relationships View
Video 5
Designing a Database
An essential video for anyone new to constructing databases, I walk students through
the whole design process from conducting a “Needs Analysis” and gathering
data to building a table structure and deciding how far you will need to normalize
your data.
* How NOT to Design a Database
* How to Design a Database
* Normalization (Basic Overview)
* Our Scenario
* Our Plan
Video 6
Building Tables
This is an essential video for anyone who hasn’t yet built a table. Using
the plan we created in the “Designing a Database” video, I walk students
through table basics and demonstrate all the different ways you can create a table
in Access 2007.
* Scenario: Build Tables to store company data for Picaroon Publishing Unlimited
* Building a Table from Datasheet View
* An Brief Introduction to Naming Conventions
* Overview of different Data Types
* How to Add Records
* How to Navigate in a Datasheet using both the mouse and Keyboard Shortcuts
* How to Build a Table in Design View
* Overview of different Data Types
* How to add Descriptions
* Using Advanced Properties
* How to Navigate in Table Design View (using both the mouse and Keyboard Shortcuts)
* Using the Microsoft Table Templates
* Advantages and Disadvantages Templates
Video 7
Modifying Tables
There are a lot more to tables than just building them. Here I show students the
more advanced features of constructing tables and controlling data entry.
* How to Control Data Entry
* Creating Input Masks
* Using Validation to restrict data entry
* Creating Lookup Fields
* Using the Access Find and Replace Dialog Box
* Sorting Data in Access
* Filtering Data in Access
Video 8
Extra Practice Building Tables
If you are like the vast majority of the population and need to be shown how to
do something more than once, then this is the video for you. Since tables can be
a confusing topic for beginners, I walk students through the creation of ALL the
tables we will be using throughout this course. No magic here, just building from
the ground up.
Video 9
Creating Basic Relationships
Once tables are built, they are going to need a way to “talk” to each
other. Here, students will learn about the various types of relationships as well
as the various ways of connecting data inside Access.
* Creating a One-To-One Relationship
* Creating a One-To-Many Relationship
* Enforcing Referential Integrity
* Turning on the Cascade Update Feature
* Turning on the Cascade Delete Feature
* Creating a Subdatasheet
* Entering Information
* Viewing information
Video 10
Advanced Relationships
Here I discuss some of the data limitations that can occur when builders rely on
only the basic relationship types (one-to-one and the one-to-many). Then we go through
how to build two slightly more advanced relationships in Access, the many-to-many
and pass-through relationships.
* Building a many-to-many relationship
* Creating Multiple Keys
* Building a Pass-through relationship
Video 11
Query Basics
Once you put data into Access, you’ll occasionally want to visit that data—you’ll
need a query for that. Here, I’ll show you the basics of building a select
query.
* The purpose of queries
* Types of queries
* Creating a Select Query
* Using the Query Wizard in Design View
Video 12
Finding Specific Data Using Queries
As your database grows, you’ll find it rare to want to see ALL of your data
all at once. To limit your query results, you’ll need to use a little something
called “criteria.” Here I’ll show you everything you could possible
want to know about criteria and operators.
* Introduction to Criteria
* An Introduction to using Operators
* Mathematical
* Relational/Comparison
* Logical
* String
* Other
* Using Wildcards
Video 13
Creating Flexible Queries
Flexibility is a quality I admire about people and MS Access. With parameter queries,
you can design one query that will output or retrieve multiple data results based
around user input. With parameter queries, you can save your end-users time and
give them the choice of what data they want to see when.
* Benefits of a using flexible query
* Creating a flexible query
* Using Wildcards with a flexible query
Video 14
Creating Calculations inside a Query
Creating calculations is essential for many aspects of data analysis, manipulation,
etc.; however, you can also use built-in functions to override table formatting
options, data normalization, and output. Here I introduce students to creating their
own custom calculations and show them how to use popular built-in functions.
* Introduction to Calculations
* Creating a Calculated Detail Field
* Calculating a Group of Records
* Introduction to Built-in Functions
* The DateDiff Function
* Format Functions
Video 15
Introduction to Joins
Most times users to Access use queries to see data that exists in their database.
Sometimes, though, users want to see data that doesn’t exist in their database.
You’ll need to know how to change the join type for that.
* Introduction to Query Joins
* Creating an Inner Join
* Creating an Outer Join
* Creating a Self Join
Video 16
Introduction to Action Queries
Rather than just having your query show you something, you might want to have your
query do something, like build a new table or add records to an already existing
table. In this video, I show students how to make queries work for them by demonstrating
how to build various action queries.
* Creating an Append Query
* Creating a Delete Query
* Creating a Make-Table Query
* Creating an Update Query
Video 17
Using Special Query Wizards
In addition to building queries yourself, Access provides you with several wizards
that are designed to perform very specific tasks. In this video, I’ll show
students how to use some special query wizards, such as the crosstab query wizard.
* The Crosstab Query Wizard
* The Find Unmatched Query Wizard
* The Find Duplicates Query Wizard
Video 18
Introduction to PivotTables and PivotCharts
If you are one of those crazy number crunchers, you’ll need to know how to
use a PivotTable and PivotChart. In this video, I’ll introduce you to the
basics of creating and modifying these elusive pivoting structures.
* Creating a PivotTable
* Modifying a PivotTable
* Formatting a PivotTable
* Creating a PivotChart
* Modifying a PivotChart
* Formatting a PivotChart
Video 19
Creating Basic Forms
If your database will have multiple hands inside your Access cookie jar, so to
speak, you’ll need to find a way to make your database more accessible to
end-users. Forms are the way to go! In this video, I show students the basics of
creating user-friendly forms.
* An overview of Form Views
* Creating Forms
* Using the wizard
* In design view
* Modifying Forms
* In layout view
* In design view
* Adding Special Tools
* Adding Images to forms
* Creating an Option Group Control
* Creating a Calendar Control
* Creating Command Buttons
Video 20
Designing Macros
Rather than performing a lot of simple actions over and over, why not have Access
just perform the series of actions with the click of one button? By learning to
write macros, students can find ways to automate a lot of commonly repeated tasks.
* Creating a Macro
* Adding a macro to form control
* Embedded Macros
* Controlling Data through Macro Conditions
* Building a macro to run automatically
Video 21
Creating Basic Reports
You won’t want you data to simply exist on a computer. At some point, you’ll
need to print the data in order to hand it over to someone else. In this video,
I’ll show you several methods for creating reports that will impress.
* Creating Reports
* Formatting Reports
* Adding Calculated Fields
* Sorting and Grouping Data
* Exploring Printing Options
* Adding a Chart to a Report
Video 22
The Switchboard Manager
When your database is close to being complete, you’ll need to build a switchboard
to help end-users locate the reports they use the most. That way, end-users won’t
go exploring and break something they shouldn’t be able to see in the first
place.
* Creating a Switchboard
* Editing a Switchboard
BONUS VIDEO #1
Importing and Exporting Data within Microsoft Office
In this video I show students how to move data in and out, this way and that way,
up and down, and all around the MS Office suite.
* Importing an Access Object
* Import a Microsoft Excel Spreadsheet
* Import a Text File
* Export a Table to Microsoft Word
* Export a Query to Microsoft Excel
* Export a Report to Microsoft Excel
* Create a Mail Merge with Microsoft Word
BONUS VIDEO #2
Creating a Data Collection Email
If you are sad that Data Access Pages are a thing of the past, you’ll need
another way to collect data from people who don’t have access to Access. Email
Collection is the way to go.
BONUS VIDEO #3
Access Management Tools
When your database design is finished, there are some extra tools Access gives you
to help manage your database. In this video, I’ll cover some of these extra
tools.
BONUS VIDEO #4
Getting Help When You Need It
Even though this is the most comprehensive course on the market, it still won’t
show you everything you can do with Access. There will be times in the future where
you’ll need extra help on some very specific task, and navigating the web
to find the answers can be very time consuming. In this video, I show you some of
my favorite places to go on the web to find the answers you are looking for.
* Microsoft Access Help
* Microsoft Communities
* Other Online Forums
The Only Microsoft Access 2007 Course that Will Teach You Exactly How to Build
a Database from Start to Finish!
Here's What You Get When You Order Today!
 22 Videos
(18hrs : 02mins : 25secs) will be provided
in High-Quality AVI and WMV format. In other words, you get perfect
quality and replication of your instructor's screens. An easy-to-use table of contents
allows you to navigate to key areas you wish to focus on.
 22 iPod video files to watch Train Signal on the go! A popular request
amongst our students who wish to study while they commute (i.e., train, plane, bus).
These 320x240 .m4v files are compressed versions of the original course, and play
on any iPod that supports video. Also great for reviewing and refreshing your mind
"on the job."
 22 MP3
Files to listen to Train Signal on the go. Some of our students have
requested this option. People would like to be able to listen in their car or while
working out. Can be burnt to a CD or copied to portable device. Great supplemental
training to the videos.
 Instructor
Notes – These PDF documents can be printed out and contain the
slides used by the instructor throughout the videos. These allow the user a quick
easy reference to notes on the slides and make any additional notes for their own
learning process.
A Tremendous Value for Your Modest Investment... Fully Backed by Our 90-Day "Total
Experience" Guarantee!
 To get this level of training from any other CBT, online class, instructor-led class,
workshop, bootcamp, or book, you would pay well over $995.00!
However, you can receive the same high-level professional training via Train Signal
for Only $995! Limited-Time Offer
Only $97!
PLUS! Because we are so confident in our training and reputation,
we guarantee your complete satisfaction for 90 Days! No one else
in the industry offers such a powerful guarantee! (If they offer one at all!)
Order Our Microsoft Access 2007 Training Today, and
Receive:
PROFESSIONAL TRAINING
Over 18 Hours of Access 2007 Training Videos on 5 Jam Packed DVDs!
(Total Running Time: 18hrs : 02mins : 25secs)
BONUS Course Just Added! "When DBs Attack! Tools for Maintaining
Your Access 2007 Database!" Will be shipped FREE with your order!
Multiple
File Formats Make It Convenient for You To Learn Anywhere You Go! iPod
Video, Mp3 Audio, .WMV & high quality .AVI video
PDF of Instructor Notes allow you to follow along with the videos
and take more organized notes.
77-605 MCAS EXAM PREPARATION
Pass the
Exam & Get Certified! This Course Has Complete Exam Coverage for
"70-605 MCAS: Using Microsoft Access 2007."
Total Package Value $995!
Limited-Time Offer Only $97!
Meet Your Certified
Microsoft Access 2007
Instructor, Heather Ackmann
(Microsoft Certified Master)
 Heather
Ackmann is an accomplished instructor who has taught over 4,000 students at the
high school, college, and adult levels.
Specializing in computer applications, writing, and literature, she holds a degree
in English and Secondary Education, an Illinois Type 09 Initial Teaching Certificate,
and is a Microsoft Certified Master for Office 2003.
While her energetic and easy-to-follow style is ideal for beginners to computer
applications, her knowledge, thoroughness, and foresight in potential problems will
satisfy the more proficient user.
On the side, she works as the Assistant Editor for the literary journal Relief:
A Quarterly Christian Expression designing, editing, and proofing the print journal.
She also maintains their Access Database, builds Excel and Word templates for their
editors, and answers end-user questions for Relief’s online submission system.
What Our Loyal Students
Say About Train Signal's
"Total Experience" Training
"Train Signal products not only teach me how to maintain my network, I actually
gain understanding that is invaluable for the tests as well..."
I just wanted to send in my thanks. It’s really nice to have a product out
there for net admins that really delivers.
Everyone else seems to brag about how you can use their products to pass a test.
I've taken and passed several tests, and few contained the content I need on a day-to-day
basis.
Train Signal products not only teach me how to maintain my network, I actually gain
understanding that is invaluable for the tests as well. I bought your product at
my previous employer and will buy it for my current employer as funds become available.
Though your product is amazing, I would like to make one request that I feel would
complete the package. Most admins are clueless when it comes to scripting.
Everyone seems to have tons of advanced scripting, but just like everything else,
there are little to no explanations for the beginner. Could you please consider
adding something in that area to your training? Keep up the good work.
Thanks
David Morehead
www.wcsmiami.org
"...the best paying job of
my IT career. Your videos
had a big part in that..."
I wanted to let you know I was asked today (3/16/2007) to provide references for
a Network Engineer position at a large world-wide law firm. Providing references
is typically the last step before an offer. This potentially could be the best paying
job of my IT career. Your videos had a big part in that.
I have two and half years experience with Active Directory and Exchange 2003, but
your videos showed me just what I needed to pass their skills assessment test. The
price was well worth it.
-Bill Boyd
"I ordered this course and within a week I had my exchange server up and going
properly."
I would like to take this time and tell you how helpful found these videos. I have
gone through books, online sessions, forums and I never really understood exchange
in and out.
I ordered this course and within a week I had my exchange server up and going properly.
I couldn't have asked for a better product and sometimes its nice to hear that instead
of the bad stuff. Thank you.
James Latham, Jr.
Network administrator
Laro Maintenance Corp.
"You guys have a unique ability to explain and visually demonstrate these esoteric
topics in a way that is easy to understand..."
I just wanted to let you know I have been very impressed with the orders we have
placed with you.
Last year we bought the Microsoft Server Complete Library. It is one of the best
I have seen.
You guys have a unique ability to explain and visually demonstrate these esoteric
topics in a way that is easy to understand.
I have attended many training classes where I was getting good information but because
of the way it was taught I had to force myself to pay attention and in some cases
just try not to fall asleep.
These videos are just the opposite. If I am not careful I will sit up too late watching
them.
Well, we just received our most recent order. This time we decided to order all of
your VMWare Videos. If they are as good as your other work then I know I'm going
to be happy.
Thanks for the help and keep up the good work.
Del Bullion
VDI Communications, Inc.
"I will recommend TrainSignal to all of my tech buddies..."
I wanted to write and express my great satisfaction with the Exchange Server 2003
for SophiesToyBox.com. I am very impressed with the course. I felt as though I was
actually performing the tasks during the course.
Scott was great at explaining things and even going through the quirks that would
surely happen during an install. I am very pleased with the material and plan to
be back to purchase more. Great job. I will recommend TrainSignal to all of my tech
buddies.
William R. Cunningham (Reggie)
Systems Administrator
Institute for Safe Medication Practices www.ismp.org
"I am on my way to becoming an MCSE and have found your videos very informative.
However, your service deserves even more praise."
I inadvertently ordered two of the same course on Routing and Remote Access and
when I discovered my mistake, I was very upset.
Internet based companies are often hard to deal with. If you try to return something,
they put you off -sometimes indefinitely. I was almost sure that I would encounter
problems when I attempted to exchange the video.
I called Ashley on the phone and informed her of my intent to exchange the duplicate
video for another. She told me that she would send the other video when I returned
mine.
I sent the video back by UPS and within a few days I received a package with the
new Active Directory tutorial movie. I was so impressed that your company did not
try to hold the movie hostage or to delay sending it. Even though I am an avid supporter
of technology, I have to agree with those who say that the age of impersonal commerce
has opened doorways to poor service.
I hope your company is successful and that others realize the benefit of doing business
with someone they can trust!
Sincerely,
Nancy Ashley Ware
"I will be happy to recommend your products to anyone I know..."
Just to let you guys know I received my order this morning. Extremely happy with
the fast delivery service, since I ordered the product on Tuesday afternoon and
I received them Thursday morning (48hrs delivery from the US to the UK, that puts
to shame some mail order companies in the UK) I will be happy to recommend your
products to anyone I know.
Daniel Jenkins
Surrey, Great Britain
"Train Signal Rocks!"
Keep kicking butt! I have purchased CBT nuggets before. They are good on theory
and very little application. Yours is both. Please keep up the great work Scott.
You are very gifted.
What I love about your stuff is you have the theory and then you apply and then
you test it! You go full circle. CBT nuggets leaves too many things open ended.
People don’t realize from the home CBT user. You need to go full circle theory,
application how to use it, and then prove it. Mistakes and proving things help us
see why? And help us handle the unexpected better. I also am a teacher at my work,
and this is what I do with effectiveness.
I also bought all of your courses all 21... I am studying for MCSE 2003 and your
course rocks better than classroom. Way better.
Keep up the great work. Train Signal rocks!
Robert W. Van Dyke
IS Assistant
Bulls Eye Credit Union
"I’m sure I will be buying a lot more videos from you. :)"
I bought the entire Windows training package and I am probably about half way through
it. I am definitely happy with the product. So far I’ve watched videos from
both Scott Skinger and Obaid Chhatriwala…both do a very good job.
Again, I am really happy with the product and I think the instruction quality
of both Scott and Obaid is great! I’m only commenting on this because I’m
sure I will be buying a lot more videos from you. :)
David Copenhaver
IT Manager / Network Administrator
HESSTECH, LLC
"Your way of running business is a rare example..."
There truly is power in a good name and a way of running business. Good impressions
and positive experiences with a company definitely affect how people think when
they think of your name - in this case, Train Signal.
All that is to say thank you and that I will truly enjoy the material. I have studied
all the other many hours diligently and will continue on my certification path.
You guys are doing it right; it's great to take part in your program and business.
Sincerely,
John Archer
"Just wanted to take this opportunity to say how effective your training DVDs
are."
Few weeks back, I had no idea what Active Directory, DNS, WINS, DHCP etc. are all
about, but after watching your training videos all are as clear as crystal.
Thank You,
Abid Malik
Raleigh, North Carolina
"Its like having a Veteran walk you through training camp, building your confidence
so you know what it takes to get it done."
Just want to say great job by you and the team on the training videos. The videos
and the lab books trail each other so you align the image of it being done with
the instructional reading. Its like having a Veteran walk you through training camp
building your confidence so you know what it takes to get it done.
If your goal is certification then partner the video with test questions and you
will solidify the knowledge from the video in your mind for the test and while really
getting to know your craft!
- Andrew (MCSE, A+, N+)
"You guys are unbelievable
at what you do."
I'm one exam away from becoming MCSE, MCSA and Security+ Certified. After purchasing
the entire set of your videos things slowly started to come together. You guys are
unbelievable at what you do. Obaid, all the command line knowledge for AD... WAY
TO GO!!! I was relieved, and a bit disappointed, that I didn't get any command line
stuff on my AD exam.
Scott, incredible live troubleshooting! It just shows how well you know the content
you teach. Anywho, It takes a long time to go through the videos (so much content)
but every second was valuable. This is the best investment a person can make when
getting MCSE certified. On behalf of all "MCSEs to be"... Thank you!
D.C.
"I shall continue to buy
your products without a question of a doubt."
I have purchased almost all of your videos so far and I must say that they have
been value for money; in as much as that I have gained lots of new skills.
Moreover, I find your service absolutely excellent and I feel totally appreciated
as a customer. I shall continue to buy your products without a question of a doubt.
Kind regards,
Keith Greaves
Fruitree director
"I highly recommend your products and I buy every new release that comes out."
I would like to say that I have had many “live” classes in everything
from MCSE to CCNA and your classes are as good or better. You can play the CDs over
and over or go back and review something that you did not really understand the
first time.
I highly recommend your products and I buy every new release that comes out. Please
keep up the great work!
Thanks,
Joseph McElveen
Insync Network Systems
Savannah, Georgia
|