|
|
 |
|
|
|
|
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 simple database that includes tables, queries and forms.
|
|
|
|
| You can enroll for free at any time! |
|
|
|
|
|
|
- Explore the Access 2007 interface, including the Access Ribbon and Navigation Pane
- Understand the function and components of a database
- Create a simple Microsoft Access database
- Create an Access 2007 input form
- Construct and use queries
- Learn some Microsoft Access tips and tricks
|
|
|
|
|
|
|
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.
|
|
|
Lesson 2: Microsoft Access how to: work with database tables
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.
|
|
|
Lesson 3: Microsoft Access how to: create and use queries
In this lesson, you'll learn how to construct queries 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.
|
|
|
Lesson 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 you how to create, modify and use forms.
|
|
|
|
|
|
|
|
|
|
|
|
» Faithe Wempen
Faithe Wempen, M.A., is a nationally known expert on Microsoft Office applications and A+ certification, and the author of more than 90 technical books, including Microsoft PowerPoint Advanced Presentation Techniques, Windows XP Home Edition Simply Visual, Learning Microsoft Publisher 2003, and PC Maintenance: Preparing for A+ Certification. Her articles and reviews of computer hardware and software have appeared on TechProGuild.com, TechRepublic.com, and CertCities.com, and in Microsoft Office Solutions and Microsoft OfficePRO magazines. Faithe is an adjunct faculty member at Indiana University/Purdue University at Indianapolis in the Computer Information Technology department, where she teaches Computer Hardware and Software Architecture and is part of a team designing a new learning approach to Microsoft Office skills based on multiple learning styles. Faithe is also the co-owner and business manager for Sycamore Knoll Bed and Breakfast in Noblesville, Indiana, and is working on a B.S. in Computer Information Technology. In her spare time (which is not much!) she likes playing with her three Shetland sheepdogs and vacationing in Las Vegas.
|
|
» Interact with Faithe and other students on the message
board
|
|
|
|
|
|
|
|
|
|
|
|
»
Microsoft® Excel 2007: create a PivotTable
|
|
|
»
Microsoft® Excel 2007: filter data
|
|
|
»
Microsoft® Excel 2007: intermediate
|
|
|
»
Microsoft® Excel 2007: introduction
|
|
|
»
Microsoft® Excel 2007: link and unlink content between two workbooks
|
|
|
»
Microsoft® Excel 2007: record a simple macro and edit it in VBA
|
|
|
»
Microsoft® Excel 2007: take a tour of the interface and learn basic skills
|
|
|
»
Microsoft® Word 2007: intermediate
|
|
|
»
Microsoft® Word 2007: take a tour of special features
|
|
|
»
Microsoft® Word 2007: take a tour of the Ribbon
|
Microsoft Access 2007 : Introduction
Excellent introduction to Access 2007 databases. Looking forward to an Intermediate and ultimately Advanced course that you'll hopefully will be running soon
Beginning Access
Good beginning
Nov 18, 2009
(Edited about 5 days ago)
Access 2007 Introduction
Good introductory course but could have provided a little more depth on queries and forms. However, the quizzes weren't challenging enough. True-False questions just don't make the grade. Looking forward to reading instructor's book in the Visual series as well as an intermediate course in this series.
Nov 18, 2009
(Edited about 5 days ago)
Online training
I intend to finish my MCAS exams in 2 weeks so these lessons are being used as refreshers. A great way to learn. Thanks
» Read all 32 reviews
|
Printable version