|
|
 |
|
|
|
|
- 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
|
Feb 9, 2010
(Edited about 1 hour ago)
access 07 class
I DID NOT LEARN ONE THING... TOO COMPLICATED FOR MY SKILL LEVEL
My review for MS Access 2007: Introduction
This class was very informative and productive. I learned a lot about tables, relationships, queries and etc. Even though this was not an easy task for me, however, it was quite interesting. I stuck to the assignment(s) and completed this course.
MS Access 2007: Intor
Great Presntation, Today i had a good learning session of MS Access 2007 how to use and what are all the commands available in the ribbon.. Awaited to see more in Ms Access..Thanks.
Access 2007
Very good for teaching an OLD FoxPro DOS person (haven't programed in 15 years) some of the differences between that and Access terminology. Many things I was capable of doing in Foxpro I can't figure out in Access ( I know they are possible). Forms have been troublesome, Queries have not been so hard to understand, Printing capabilities are fantastic.
» Read all 70 reviews
|
Printable version