Access 2013 Absolute Beginner's Guide

Que Publishing
6
Free sample

Make the most of Access 2013—without becoming a technical expert! This book is the fastest way to master Access and use it to build powerful, useful databases of all kinds—even web application databases! Even if you’ve never used Access before, you’ll learn how to do what you want, one incredibly clear and easy step at a time. Access has never, ever been this simple!

Who knew how simple Access® 2013 could be? This is the easiest, most practical beginner’s guide to using Microsoft’s incredibly powerful new Access 2013 database program… simple, reliable instructions for doing everything you really
want to do! Here’s a small sample of what you’ll learn:

• Create tables to efficiently store and navigate your data

• Build queries that retrieve exactly the information you want

• Design intuitive forms that help your users work more efficiently

• Build reports that answer key questions intuitively and visually

• Learn easy techniques for designing more reliable databases

• Work faster with AutoForms, AutoReports, and other shortcuts

• Automate repetitive tasks and build more polished databases with macros

• Share Access data with Excel, SQL Server, and other applications

• Solve complex problems with advanced query, form, and reporting techniques

• Build modern web databases that serve users through browsers

• Run your database on the cloud through Microsoft Office 365

• Construct a complete database application from start to finish

• And much more…

Alison Balter, President of InfoTech Services Group, Inc., has spent 25 years training and consulting on Microsoft Access and related applications with top organizations such as Cisco, Shell, Accenture, Northrop, the U.S. Drug Enforcement Administration, Prudential, Transamerica, Fox Broadcasting, and the U.S. Navy. She travels throughout North America delivering seminars on Access and has authored 14 books and videos for Pearson, including Microsoft Access 2010 LiveLessons and Alison Balter’s Mastering Access 2007 Development. She is past president of the Independent Computer Consultants Association of Los Angeles.

Category: Databases

Covers: Microsoft® Access® 2013

User Level: Beginning

Read more

About the author

Alison Balter is the president of InfoTech Services Group, Inc., a computer

consulting firm based in Newbury Park, California. Alison is a highly experienced

independent trainer and consultant specializing in Windows applications training

and development. During her 28 years in the computer industry, she has trained

and consulted with many corporations and government agencies. Since Alison

founded InfoTech Services Group, Inc. (formerly Marina Consulting Group) in

1990, its client base has expanded to include major corporations and government

agencies such as Cisco, Shell Oil, Accenture, Northrop, the U.S. Drug Enforcement

Administration, Prudential Insurance, Transamerica Insurance, Fox Broadcasting,

the U.S. Navy, the University of Southern California , Massachusetts Institute of

Technology, and others.

Alison is the author of more than 300 internationally marketed computer training

videos and CD-ROMs, including 18 Access 2000 videos, 35 Access 2002 videos, 15

Access 2003 videos, 14 Access 2007 User Videos, and 18 Access 2007 Developer

Videos. Alison travels throughout North America giving training seminars on

Microsoft Access, Microsoft SQL Server, and Visual Basic for Applications.

Alison is also the author of 13 books published by Sams Publishing: Alison

Balter’s Mastering Access 95 Development, Alison Balter’s Mastering Access 97

Development, Alison Balter’s Mastering Access 2000 Development, Alison Balter’s

Mastering Access 2002 Desktop Development, Alison Balter’s Mastering Access

2002 Enterprise Development, Alison Balter’s Mastering Microsoft Access Office

2003, Teach Yourself Microsoft Office Access 2003 in 24 Hours, Access Office 2003

in a Snap, Alison Balter’s Mastering Access 2007 Development, three e-books on

Microsoft Access 2007, and Teach Yourself SQL Express 2005 in

24 Hours. Alison is a co-author of three Access books published by Sams

Publishing: Essential Access 95, Access 95 Unleashed, Access 97 Unleashed, and

Using Microsoft Access 2010.

An active participant in many user groups and other organizations, Alison is a past

president of the Independent Computer Consultants Association of Los Angeles

and of the Los Angeles Clipper Users’ Group. She served as president of the

Ventura County Professional Women’s Network for 2 years.

Alison’s firm, InfoTech Services Group, Inc., is available for consulting work and

onsite training in Microsoft Access, Visual Studio .NET, and SQL Server, as well as

for Windows Server 2008, Windows Vista, Windows XP, Windows 7, Windows 8,

PC networking, and Microsoft Exchange Server. You can contact Alison by email

at Alison@TechIsMyThing.com, or visit the InfoTech Services Group website

at http://www.TechIsMyThing.com.

Read more
4.3
6 total
Loading...

Additional Information

Publisher
Que Publishing
Read more
Published on
Apr 18, 2013
Read more
Pages
416
Read more
ISBN
9780133260892
Read more
Read more
Language
English
Read more
Genres
Computers / Desktop Applications / Databases
Read more
Content Protection
This content is DRM protected.
Read more
Eligible for Family Library

Reading information

Smartphones and Tablets

Install the Google Play Books app for Android and iPad/iPhone. It syncs automatically with your account and allows you to read online or offline wherever you are.

Laptops and Computers

You can read books purchased on Google Play using your computer's web browser.

eReaders and other devices

To read on e-ink devices like the Sony eReader or Barnes & Noble Nook, you'll need to download a file and transfer it to your device. Please follow the detailed Help center instructions to transfer the files to supported eReaders.
This is the eBook version of the printed book.

Access 2007 is tightly integrated with SharePoint. This Short Cut provides readers with everything that they need to know about working with Access 2007 and SharePoint. Topics covered include why SharePoint is important to an Access 2007 developer, how to move your database to a SharePoint site, and how to open and work with SharePoint lists from within Access 2007. It also covers how to integrate with the SharePoint workflow, how to work with SharePoint services off-line, and how to map Access data to SharePoint data. All of these topics are necessary when integrating Access 2007 and SharePoint.

Alison Balter has been writing about Access since Access 95. She has written eight books, co-authored two books on Access, and has written one book on Microsoft SQL Server 2005 Express. Her books include Essential Access 95, Alison Balter's Mastering Access 95 Development, Alison Balter's Mastering Access 97 Development, Access 97 Unleashed, Alison Balter's Mastering Access 2000 Development, Alison Balter's Mastering Access 2002 Desktop Development, Alison Balter's Mastering Access 2002 Enterprise Development, Alison Balter's Mastering Office Access 2003 Development, Access 2003 In-a-Snap, Access 2003 in 24 Hours, SQL Server Express in 24 Hours.

Alison has over 13 years of practical experience working with Access and Access applications. Her clients’ projects range from small end-user projects through enterprise-wide applications. Clients include Archdiocese of Los Angeles, Southern California Edison, Accenture, Prudential Insurance, and the International Cinematographer's Guild.

Her Access skills are not limited to writing and programming. Alison has also been teaching Access and speaking at conferences for more than 12 years. Her training has included everything from end-user training to corporate training, in both the United States and Canada.

Table of Contents

Section 1: What is SharePoint Server 2007 and Why Integrate It With Your Access Applications?

Section 2: The Access 2007 (accdb) File Format and SharePoint

Section 3: Exporting Data to a SharePoint Site

Section 4: Publishing Data to a SharePoint Site

Section 5: Opening Access Forms and Reports from a SharePoint Site

Section 6: Linking to and Importing from SharePoint Lists

Section 7: Taking SharePoint Lists Offline with Access

Section 8: The Basics of Working with SharePoint

Section 9: Re-establishing Links When a SharePoint Site has been Moved

Section 10: Modifying the Design of an Access Database Stored on a SharePoint Server

Compared to industrial-strength database products such as Microsoft's SQL Server, Access is a breeze to use. It runs on PCs rather than servers and is ideal for small- to mid-sized businesses and households. But Access is still intimidating to learn. It doesn't help that each new version crammed in yet another set of features; so many, in fact, that even the pros don't know where to find them all. Access 2007 breaks this pattern with some of the most dramatic changes users have seen since Office 95. Most obvious is the thoroughly redesigned user interface, with its tabbed toolbar (or "Ribbon") that makes features easy to locate and use. The features list also includes several long-awaited changes. One thing that hasn't improved is Microsoft's documentation. To learn the ins and outs of all the features in Access 2007, Microsoft merely offers online help.

Access 2007: The Missing Manual was written from the ground up for this redesigned application. You will learn how to design complete databases, maintain them, search for valuable nuggets of information, and build attractive forms for quick-and-easy data entry. You'll even delve into the black art of Access programming (including macros and Visual Basic), and pick up valuable tricks and techniques to automate common tasks -- even if you've never touched a line of code before. You will also learn all about the new prebuilt databases you can customize to fit your needs, and how the new complex data feature will simplify your life. With plenty of downloadable examples, this objective and witty book will turn an Access neophyte into a true master.

This is the eBook version of the printed book.

Microsoft Office Access 2007 includes a plethora of new features that could prove difficult to find for even seasoned users of previous versions of Access. Alison Balter's What's New in Microsoft Office Access 2007? includes a discussion of all the new features in Access 2007, providing details and practical examples on the use of each feature. Her teaching style is clear and succinct, providing you with a great jump-start to working with Access 2007. The topics covered include what's new with tables, the new and improved embedded macros, and what's new with importing and exporting.

Table of Contents

Section 1 What's New with the User Interface?

Section 2 Exploring the New Database Templates

Section 3 What's New with Tables?

Section 4 What's New in Datasheet View?

Section 5 What's New in Forms?

Section 6 What's New in Reports?

Section 7 The New and Improved Embedded Macros

Section 8 The New and Improved Help Viewer

Section 9 What's New in Importing and Exporting?

Section 10 Access 2007 and Outlook 2007 Integration

Section 11 What Else Is New with Microsoft Office Access 2007?

Section 12 Additional Tips and Tricks

Alison Balter has been writing about Access since Access 95. She has written eight books and co-authored two books on Access and has written one book on Microsoft SQL Server 2005 Express. Her books include Essential Access 95, Alison Balter's Mastering Access 95 Development, Alison Balter's Mastering Access 97 Development, Access 97 Unleashed, Alison Balter's Mastering Access 2000 Development, Alison Balter's Mastering Access 2002 Desktop Development, Alison Balter's Mastering Access 2002 Enterprise Development, Alison Balter's Mastering Office Access 2003 Development, Access 2003 In-a-Snap, Access 2003 in 24 Hours, and SQL Server Express in 24 Hours.

Alison has more than 13 years of practical experience working with Access and Access applications. Her clients' projects range from small end-user projects through enterprisewide applications. Clients include the Archdiocese of Los Angeles, Southern California Edison, Accenture, Prudential Insurance, and the International Cinematographer's Guild.

Her Access skills are not limited to writing and programming. Alison has also been teaching Access and speaking at conferences for more than 12 years. Her training has included everything from end-user training to corporate training, in both the United States and Canada.

©2018 GoogleSite Terms of ServicePrivacyDevelopersArtistsAbout Google|Location: United StatesLanguage: English (United States)
By purchasing this item, you are transacting with Google Payments and agreeing to the Google Payments Terms of Service and Privacy Notice.