Microsoft Office Access 2007 Inside Out
by Conrad, Jeff; Viescas, John L.Edition: 1st
Format: Paperback
Pub. Date: 2007-04-11
Publisher(s): MICROSOFT PRESS
Other versions by this Author
List Price: $49.99
Rent Book
Select for Price
New Book
We're Sorry
Sold Out
Used Book
We're Sorry
Sold Out
eBook
We're Sorry
Not Available
How Marketplace Works:
- This item is offered by an independent seller and not shipped from our warehouse
- Item details like edition and cover design may differ from our description; see seller's comments before ordering.
- Sellers much confirm and ship within two business days; otherwise, the order will be cancelled and refunded.
- Marketplace purchases cannot be returned to eCampus.com. Contact the seller directly for inquiries; if no response within two days, contact customer service.
- Additional shipping costs apply to Marketplace purchases. Review shipping costs at checkout.
Summary
You're beyond the basics, so dive right in and really put your database skills to work! This supremely organized reference is packed with hundreds of timesaving solutions, troubleshooting tips, and workarounds. It's all muscle and no fluff. Discover how the experts tackle Access 2007and challenge yourself to new levels of mastery! Create tables that support your database design strategy Import and link to data from spreadsheets, text files, databases, and other ODBC data sources Build simple to complex queries to manipulate data Learn advanced techniques for building and customizing user interface forms Design attractive reports to calculate and analyze large sets of data Automate your application with Microsoft Visual Basic for Applications Customize the Office Fluent Ribbon Explore using XML and Windows SharePoint Services to create Web-based applicationsCD includes: Fully searchable eBookplus bonus chapters Sample database applicationsincluding query, form, and report examples Articles from the experts: designing databases, understanding SQL, exporting data, and more Links to demos, blogs, and user communities References for finding Access 2003 commands in Access 2007 Windows Vista Product Guide eReference and other eBooks
Author Biography
Jeff Viescas was awarded Microsoft's Most Valuable Professional award from 2005 to 2007 before joining Microsoft for his continual involvement with the online Access community. He maintains a Web site with a wealth of information and resource links for those needing guidance with Access (http://www.AccessJunkie.com). He is the author of Microsoft Access 2010 Inside Out and co-authored the Microsoft Office Access 2007 Inside Out book with John Viescas. Jeff is currently employed by Microsoft as a Software Design Engineer in Test working with the Access development team.
Table of Contents
| What is Microsoft Access? | p. 3 |
| Exploring the new look of Access 2007 | p. 19 |
| Microsoft Office Access 2007 overview | p. 99 |
| Creating your database and tables | p. 141 |
| Modifying your table design | p. 203 |
| Importing and linking data | p. 253 |
| Creating and working with simple queries | p. 347 |
| Building complex queries | p. 413 |
| Modifying data with action queries | p. 485 |
| Using forms | p. 517 |
| Building a form | p. 559 |
| Customizing a form | p. 609 |
| Advanced form design | p. 685 |
| Using reports | p. 735 |
| Constructing a report | p. 757 |
| Advanced report design | p. 811 |
| Understanding event processing | p. 867 |
| Automating your application with macros | p. 887 |
| Understanding visual basic fundamentals | p. 941 |
| Automating your application with Visual Basic | p. 1051 |
| Publishing data on the Web | p. 1127 |
| Working with Windows SharePoint services | p. 1165 |
| Using XML | p. 1235 |
| The finishing touches | p. 1283 |
| Distributing your application | p. 1319 |
| See the companion CD for bonus content parts 7 and 8 | |
| Table of Contents provided by Blackwell. All Rights Reserved. |
An electronic version of this book is available through VitalSource.
This book is viewable on PC, Mac, iPhone, iPad, iPod Touch, and most smartphones.
By purchasing, you will be able to view this book online, as well as download it, for the chosen number of days.
Digital License
You are licensing a digital product for a set duration. Durations are set forth in the product description, with "Lifetime" typically meaning five (5) years of online access and permanent download to a supported device. All licenses are non-transferable.
More details can be found here.
A downloadable version of this book is available through the eCampus Reader or compatible Adobe readers.
Applications are available on iOS, Android, PC, Mac, and Windows Mobile platforms.
Please view the compatibility matrix prior to purchase.