Estudiante

Microsoft® Access 2007: introduction Lessons

Even if you have no experience with databases, Microsoft Access 2007 lets you create a user-friendly database for storing business or personal records, such as addresses, product data and business transactions. In this tutorial, you'll learn how to use Microsoft Access and become familiar with the Access 2007 interface, as well as create a simpledatabase that includes tables, queries and forms. 1. What is Microsoft Access used for? Microsoft Access 2007 is one of the easiest databases to use, thanks to the tabbed command system. In this lesson, you'll tour the Access 2007 interface, learn where commands are located and understand the purpose of database objects, tables, forms and queries. 2. Microsoft Access how to: work with databasetables To build a useful, accurate database, you need to use tables. This lesson begins by showing you how to create a new database. Then you'll explore tables, learning how to use table relationships to connect information within a database.

Welcome to the class

What is Microsoft Access used for?

3. Microsoft Access how to: create and use queries In this lesson, you'll learn how to constructqueries in Access 2007 that sort and filter data. You'll use queries to join two or more tables, and even add, change or delete data in multiple records at once. 4. Microsoft Access how to: work with forms When you use a database, you want it to be as simple as possible to enter, edit or display data. Forms are the best way to achieve simplicity in an Access 2007 database. This lesson shows youhow to create, modify and use forms.

Microsoft Access 2007 is one of the easiest databases to use, thanks to the tabbed command system. In this lesson, you'll tour the Access 2007 interface, learn where commands are located and understand the purpose of database objects, tables, forms and queries.   Microsoft Access 2007 is a full-featured database application which you can use to manage, trackand share information from multiple sources. Even if you have no experience with databases, Access 2007 lets you easily create a userfriendly database for storing business or personal records, such as addresses, product data and business transactions. In this Microsoft Access tutorial for beginners, you'll become familiar with the Access 2007 interface, learn about basic database design and createa simple but complete database that includes tables, queries and forms. This class is geared toward employees in small to medium-size businesses who are new to databases and Access 2007 software. However, personal users can also benefit from the class by learning the fundamentals of Access 2007.

»  Microsoft Access

There are four lessons in this class, described as follows:

Lesson 1explores the Access 2007 interface, shows you where commands are located and explains the purpose of database objects, tables, forms and

Beyond the lessons, be sure to complete the assignments and quizzes. They're designed to reinforce important topics covered in the lessons and enable you to practice some new skills. Throughout this class, we provide Flash examples. To view these examples, youneed the Adobe Flash Player. Keep an eye out for notes with links that say "See how to ____" or something similar. Some of these files are very large (10 MB or so) and may take a while to appear or download if you have a slow connection.  

As you work through the lessons, you'll see references to an Access sample database called Northwind 2007. This sample database is especially useful for usersnew to Access; you can use it to see how various functions and features work before you create them on your own.

queries. Lesson 2 shows you how to create a new database, and examines how tables and table relationships can help you connect information within a database. Lesson 3 explains how to construct queries that sort and filter data. You'll also learn how to join two or more tables, and...