Deliver to your Kindle or other device

 
 
 

Try it free

Sample the beginning of this book for free

Deliver to your Kindle or other device

Special Edition Using Microsoft Office Access 2007
 
 

Special Edition Using Microsoft Office Access 2007 [Kindle Edition]

Roger Jennings
4.5 out of 5 stars  See all reviews (4 customer reviews)

Print List Price: £35.99
Kindle Price: £27.80 includes VAT* & free wireless delivery via Amazon Whispernet
You Save: £8.19 (23%)
* Unlike print books, digital books are subject to VAT.

Free Kindle Reading App Anybody can read Kindle books—even without a Kindle device—with the FREE Kindle app for smartphones, tablets and computers.

To get the free app, enter your e-mail address or mobile phone number.

Formats

Amazon Price New from Used from
Kindle Edition £27.80  
Paperback, Special Edition £30.74  
Earn a Free Kindle Book
Earn a Free Kindle Book
Buy a Kindle book between now and 31 March and receive a promotional code good for one free Kindle book. Terms and conditions apply. Learn more

Product Description

Product Description

This book offers you comprehensive, information on using the new version of Access. Not only updated for the latest version, new chapters have been added on application automation with Access macros and collaboration with Microsoft SharePoint Team Server, both of which are hot topics.- All chapters are updated for the transition from Jet to the new Access database engine. Detailed, step-by-step instructions with icons guide you through-Access through table design, data addition, importing data from external sources, query design and execution, and designing data entry forms and printed reports.

Note - This Kindle edition does not include CD-ROM.

From the Back Cover

<>This book offers you comprehensive, information on using the new version of Access. Not only updated for the latest version, new chapters have been added on application automation with Access macros and collaboration with Microsoft SharePoint Team Server, both of which are hot topics.  All chapters are updated for the transition from Jet to the new Access database engine. Detailed, step-by-step instructions with icons guide you through Access through table design, data addition, importing data from external sources, query design and execution, and designing data entry forms and printed reports.

 

FM

Introduction

I Getting Acquainted with Access 2007

1 Access 2007 for Access 200x Users: What’s New

2 Building Simple Tracking Applications

3 Navigating the New Access User Interface

II Learning the Fundamentals of Access

Databases

4 Exploring Relational Database Theory and Practice

5 Working with Access Databases and Tables

6 Entering, Editing, and Validating Access Table Data

7 Sorting, Finding, and Filtering Data

8 Linking, Importing, and Exporting Data

III Transforming Data with Queries and

PivotTables

9 Designing Queries for Access Databases

10 Understanding Access Operators and Expressions

11 Creating Multitable and Crosstab Queries

12 Working with PivotTable and PivotChart Views

13 Creating and Updating Access Tables with Action

Queries

IV Designing Forms and Reports

14 Creating and Using Basic Access Forms

15 Designing Custom Multitable Forms

16 Working with Simple Reports and Mailing Labels

17 Preparing Advanced Reports

18 Adding Graphs, PivotCharts, and PivotTables

V Moving to Networked Multiuser Applications

19 Linking Access Front Ends to Access and

Client/Server Tables

20 Exploring Access Data Projects and SQL

Server 2005

21 Moving from Access Queries to Transact-SQL

22 Upsizing Access Applications to Access Data

Projects

VI Collaborating with Access Data

23 Importing and Exporting Web Pages

24 Integrating with XML and InfoPath 2007

25 Collaborating with Windows SharePoint Services

VII Programming and Converting Access

Applications

26 Automating Access Applications with Macros 2007

27 Learning Visual Basic for Applications

28 Handling Events with VBA and Macros

29 Programming Combo and List Boxes

30 Understanding Data Access Objects, OLE DB,

and ADO

31 Upgrading 200X Applications to Access 2007

VIII Appendix

A Glossary

Index


Product details

  • Format: Kindle Edition
  • File Size: 60553 KB
  • Print Length: 1488 pages
  • Simultaneous Device Usage: Up to 5 simultaneous devices, per publisher limits
  • Publisher: Que Publishing; 1 edition (27 April 2007)
  • Sold by: Amazon Media EU S.à r.l.
  • Language: English
  • ASIN: B000RH0DNU
  • Text-to-Speech: Enabled
  • X-Ray:
  • Word Wise: Not Enabled
  • Average Customer Review: 4.5 out of 5 stars  See all reviews (4 customer reviews)
  • Amazon Bestsellers Rank: #1,010,008 Paid in Kindle Store (See Top 100 Paid in Kindle Store)
  •  Would you like to give feedback on images?


More About the Author

Discover books, learn about writers, and more.

Customer Reviews

4 star
0
2 star
0
1 star
0
4.5 out of 5 stars
4.5 out of 5 stars
Most Helpful Customer Reviews
8 of 8 people found the following review helpful
3.0 out of 5 stars Not quite what I expected. 20 July 2008
Format:Paperback
A beautifully produced book with clear diagrams.
It was not as orderly as I expected and though it says on the back that the user level is 'Beginner - Advanced', it does not show you how to make a database and says as much on the inside.
It is too advanced for me and I wont be able to use it until I have mastered Acces by which time I probably wont need to use it.

Although the front cover states 'The only access book you need', I would suggest that unless you are already accomplished at acces this is not the book for you.

I will perservere and I know I will get my monies worth from it, but that will be a while in coming.

Would I recommend it? yes if you have a basic knowledge before you open the cover and can alaready build a database, otherwise I would suggest something that starts with how to build a database first.
Comment | 
Was this review helpful to you?
4 of 4 people found the following review helpful
5.0 out of 5 stars Access 2007 an excellent Book 23 Mar 2009
Format:Paperback
I have been using Access since the days of Access 2. I have written many databases but found that Microsoft had changed many things in this version. This book which I am still working through is very clear and precise. I would recommend it as an excellent way to convert from previous versions of Access.

Barry
England 23 March 2007
Comment | 
Was this review helpful to you?
8 of 9 people found the following review helpful
5.0 out of 5 stars Very good, from begginner to pro! 23 Feb 2008
Format:Paperback
This book is great if like me you need to build a database with lots of linking tables and needed the forums and other data entry forms to be easy and simple to use. The book comes with a CD which is great for examples as they are all on the disk!

The lang used in the book is pro form the start, but does give a definition. Just got to remember them all. Once the have the book is easy to work which. Some users made find they know a lot of the stuff at the start and just pick up on tips, but the database you make in the book has all the stages on the disk so you dont have to spend time going thought the whole book just to get to were you want.

Recommended! 10/10
Comment | 
Was this review helpful to you?
5.0 out of 5 stars Using Access 2007 23 Jun 2014
Format:Paperback|Verified Purchase
This book was a joy to read and just the technical manual I was looking for
It is clearly laid out with good examples and the language used was precise and simple to follow
It is a publication one dips into when necessary and I use it in conjunction with internet look ups
Comment | 
Was this review helpful to you?
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com: 3.9 out of 5 stars  22 reviews
66 of 68 people found the following review helpful
5.0 out of 5 stars Summary Review of Access 2007 Books 22 Mar 2008
By Read to live - Published on Amazon.com
Format:Paperback
This is the summary review of four Access 2007 books:
"Special Edition: Using Access 2007" (Special)
"Access 2007 Bible" (Bible)
"The missing Manual of Access 2007" (Manual)
"Access 2007 for dummies" (Dummies)

In sum, the special edition is the best. Buy the special edition. Even you are a fresh beginner on Access.

(My story? Well, I read the dummies first. Then looked at Manual, doesn't like it. So I got the bible. Still unsatisfied. Finally, I got the special edition.)I know some basics on Access 2003 and only use Access when Excel is not enough to handle my data. I started with "Access 2007 for dummies" and finished it in a couple of hours. Then I turned to "Access 2007 Bible" and "The missing Manual", the manual is the worst one and the bible just provides basics, well, maybe a bit more than, that the dummies book already covers.

The special edition provides more examples and detailed explanation on: Query, Forms, Reports, Pivot table.Not sure about the VBA part.

I also like very much the reader-friendly layout and enjoy its "what is in real world" sections at the end of several chapters.

This book also provides a good summary of basic database concepts like normalized, the importance of index, joints. The summary is very helpful especially you are a beginner.

The cover of the special edition claims that the special edition is the only Access book you need. Well, maybe not the only one, but if you have the special edition, you definitely don't need the Access 2007 Bible, The missing manual and the dummies book.
26 of 27 people found the following review helpful
3.0 out of 5 stars A 1/4 mile wide an an inch deep. 16 Dec 2008
By Juicemixer - Published on Amazon.com
Format:Paperback
"Special Edition Using Microsoft Office Access 2007" by Roger Jennings is an adequate Refrence Manual for getting up to speed with the many new features of the product.

However, as someone who is an experienced Access developer, I was somewhat disappointed with the depth of knowledge. It had very little VBA reference and few code examples. I would have liked to see a little more insight into collection objects and how to use the attributes and methods.

The index was too sparse. Several things that I looked up in the index were not there only to find information later when reading more in depth.

I'd say this book caters more to your super user than a developer. It would be good for getting up to speed quickly but lacks the proper depth to make solid applications.
10 of 12 people found the following review helpful
5.0 out of 5 stars Using Access 12 Jan 2009
By William L. Mcnulty - Published on Amazon.com
Format:Paperback
This is the book needed for (USING ACCESS) it states that on the cover...
It is a very good in depth, quality(user-frendly) information provider
Access 2007 has changed all the rules. Today a simiskilled Access user, can now in very little time, armed with this book, build, complete or modify complete Access data bases.
Building indepth data structures for custom applications is a snap by sprinboarding off already created templates and then modifying queries, adding operators and expressions for detailed multilevel structured reports. Get (Mircosoft Office Access 2007 templates (Zac Woodall) Zac climbs the ladder of Access Template creation and modifications))
The new well explained Infopath intergration capabilities are just awesome, we are getting closer to complete intergration of MS Office without a single line of code, and that should be the goal..
The Dashboard building capability for Access, brings to life the ability of Access to create custom applications; endless professional looking designs, without the need for coding..
Programing is less than 100 pages, again the title is USING ACCESS
The MS Access Team and Roger Jennings are bringing this already user frendly Data Base application to a new level with little or no VBA needed.. The book is packed with info, so get out your markers and tabs.
5 of 5 people found the following review helpful
1.0 out of 5 stars D Shattuck 22 Mar 2010
By Donald M Shattuck - Published on Amazon.com
Format:Kindle Edition|Verified Purchase
I have to assume this is a good book but I am not going to page through this book page by page to find material. The table of contents is not linked to the contents of the book. As a refernce book the user needs to be able to go to specific parts of the book in an efficient manner. This book does not allow it.
3 of 3 people found the following review helpful
4.0 out of 5 stars Always a good source of reference for Access 8 Mar 2010
By BBQ King - Published on Amazon.com
Format:Paperback|Verified Purchase
I've used earlier editions of Jennings' Access Special Editions before and as usual find them packed with useful information and well structured for learning about the product. Sometimes I wish there was a manual that covered the top 25 things that most everyone needs to know to use Access in three chapters and a good index to find the details and in-depth usage in a separate 30 chapter section. This book has just gotten so very large that I can use it as a free weight instead of going to the gym.
Seriously though, my main complaint, as in previous editions is the index. Individual commands are not listed or referenced as such, you have to know where they are used as a group and maybe then you can find them. I have to add a separate index of my own when I finally find what I'm looking for. (Try to find IIf sometime.)
Were these reviews helpful?   Let us know
Search Customer Reviews
Only search this product's reviews

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
 

Search Customer Discussions
Search all Amazon discussions
   


Look for similar items by category