Authentic voices. Remarkable stories. AOL On Originals showcase the passions that make the world a more interesting place.
Gwyneth Paltrow and Tracy Anderson spend time with women who've overcome hardship, injury, and setbacks to triumph in the face of adversity. We'll hear their inspiring stories firsthand, whether fighting back from a career-ending injury or transforming their lives and bodies through diet and exercise.
Enter the graceful but competitive world of ballet through the eyes of executive producer, Sarah Jessica Parker. This behind-the-scenes docudrama reveals what it takes to perform on the ultimate stage, the New York City Ballet. Catch NYCB on stage at Lincoln Center.
The Future Of Us is a powerful original series from television personality, futurist, filmmaker and techno-philosopher, Jason Silva. In this series, Silva shares his excitement around recent discoveries and inventions.
ACTING DISRUPTIVE takes viewers inside the businesses and passion projects of Hollywood’s top celebrities.
They say every picture tells a story and AOL On's new original series My Ink proves it. Travel along as some of the world's greatest athletes bring their tattoos to life through exclusive interviews and visits to their favorite tattoo parlors.
Explore what it means to be human as we rush head first into the future through the eyes, creativity, and mind of Tiffany Shlain, acclaimed filmmaker and speaker, founder of The Webby Awards, mother, constant pusher of boundaries and one of Newsweek’s “women shaping the 21st Century.”
Discover crowdfunded small business success stories with author, comedian, and entrepreneur Baratunde Thurston.
Go behind-the-scenes with racing's hottest, young talent, 17-year-old Dylan Kwasniewski, as he aspires to make it in the #1 motorsport in America – NASCAR
Follow Scott Schuman, the Sartorialist, from the streets of NYC to the capitals of Europe on his quest to photograph and document the best in culture and fashion.
Iconic potter, designer, author and personality Jonathan Adler shares his unique perspective on creativity. Showcasing the inspiration Jonathan finds in the most unlikely people and places, Inspiration Point will add style, craft and joy to your life.
Serving Innovation gives a fresh look into the stories and passions that motivate some of the most innovative tastemakers in America.
A documentary directed by Alex Winter exploring the Napster downloading revolution; the kids who created it, the bands and businesses that were affected and its impact on the world at large.
Nicole Richie brings her unfiltered sense of humor and unique perspective to life in a new series based on her irreverent twitter feed. The show follows the outspoken celebrity as she shares her perspective on style, parenting, relationships and her journey to adulthood.
Learn how to explore the different features and functions of Microsoft Access Database objects.
Tags:database,database objects,microsoft access 2007 essentials,microsoft excel,microsoft windows,total training
Grab video code:
A database is a collection of database objects. When you are working with Word and you are working with Excel, you are typically using one file bit Access is a sum of the parts of all the database objects contained within it. Right now I am going to do an Alt+Tab and I am going to switch to the contact sample database in Access. I just want to explain to you briefly what database objects are? In a layer list and I will show you how to open up a Microsoft sample database just like you see on your screen at the moment.
In Access we have tables, queries, forms, reports, Macros and modules. Modules are more of an advanced Access topic and we will not be covered in this series but I encourage you to continue studying Access and learn about the more advanced features available in Access 2007. Right now I am going to up a table and on screen you see a generic table with no records in it. If it helps think of database objects as such Tables store data, queries fetch or retrieve data. Forms help you enter and edit data, reports help print data on paper or in various formats and macros and modules help automate your application. In some ways that's a simple way of looking at things but that should help you understand the differences. Right now you still should see the contacts table open in Data sheet view.
I am going to close this one now and you can see in here I am opening up a query looks very similar to a table of data sheet. I am going to open up a form and you can see a form looks a little bit different than a table and reports there is away to print data or just view it on screen, I am going to close that one and we have macros down here. All of these database objects comprise this one database called contacts. All this information is stored within one particular file but each database objects serves a specific purpose.
In part two of this series, you will learn how to create and edit these various database objects to build a complete working database. If these terms seem foreign to you right now, don't panic, I will help guide you through the process. In a relational database system remember that all data is stored within tables. This sample database only has one table, so it’s a very simple database, but it does provide a good list of all the contacts. I am going to open that table in Data sheet View.
This table has no records in it right now because its a blank one. In a later lesson we will study some databases with a lot of information store in many tables and will have relationships defined between those tables. So you will really begin to understand how a relational database system works. For this particular sample I just wanted to illustrate the various database objects that you will see and through each lesson as we go through this series you will begin to understand how all these objects relate to one another.