Microsoft Office Access 2007 Forms, Reports, and Queries


    "Everything you need to master Access 2007 forms, reports, and queries."-Charles Carr, Reviews Editor, ComputorEdge Magazine Create Forms for BusinessEnsure Data Entry AccuracyBuild Elegant Form InterfacesCollect Data Via EmailDesign Effective Business ReportsMake an Invoice ReportCreate Mailing LabelsExtract DataWork with Multiple TablesCalculate DiscountsAnalyze Data Develop your Microsoft Access expertise instantly with proven techniques Let's face it: Microsoft Access is a large, intimidating program. Most people never progress beyond creating simple tables and using wizards to build basic forms and reports. At the same time, you need information and you know that what you seek is embedded somewhere in your Access database. Without a more sophisticated knowledge of how to extract and present that data, you're forced to rely on office gurus and overworked IT people to provide canned reports or one-size-fits-all solutions. This book changes all that by giving you the skills to build efficient front-ends for data forms, publish the results in an attractive and easy-to-read format reports, and extract the data you need queries. This book shuns the big Access picture and instead focuses intently on forms, reports, and queries. This in-depth approach will give you the knowledge and understanding you need to get at the data and prove the old saw that knowledge is power.* Focuses on the three technologies that you must master to get the most out of Access: forms, reports, and queries.* Avoids database theory in favor of practical know-how that you can put to use right away.* Packed full of real-world examples and techniques to help you learn and understand the importance of each section.* Covers what's new and changed in Microsoft Access 2007. Introduction Part I: Creating Forms Chapter 1 Creating and Using a Form Chapter 2 Working with Form Controls Chapter 3 Designing Forms for Efficient and Accurate Data Entry Chapter 4 Designing Forms for Business Use Chapter 5 Creating Specialized Forms Part II: Designing and Customizing Reports Chapter 6 Creating and Publishing a Report Chapter 7 Designing Effective Business Reports Chapter 8 Designing Advanced Reports Chapter 9 Creating Specialized Reports Part III: Creating Powerful Queries Chapter 10 Creating a Basic Query Chapter 11 Building Criteria Expressions Chapter 12 Working with Multiple-Table Queries Chapter 13 Creating Advanced Queries Chapter 14 Creating PivotTable Queries Chapter 15 Querying with SQL Statements Index

    View more

    Number of Pages: 408
    Format(s): Paperback - ISBN: 9780789736697
    Publication Date:
    Listed in: Access
    Publisher: Que Corporation,U.S.

    Books by Paul McFedries


    RRP: £44.99

    Sale Price: £42.95

    Save: £2.04 per copy!

    Books TV & Movies

    You might also like...

    Latest from the blog

    Fantastic new recipe book from Sabrina Ghayour 'Sirocco'

    Sabrina Ghayour's long awaited second recipe book Sirocco is out this month and is a great follow up to Persianna. Read article

    Ten Great Bedtime Reads from The Great British Bookshop and Aspace

    We have teamed up with Aspace ( who create beautiful room for Children to bring you 10 great bedtime reads for your little ones. Read article

    Latest from Twitter

    • @TheGBBookshop - 2 years ago

      Lottery funding for dementia reading project £2m pledged for Reading Agency scheme to pair readers with dementia sufferers

      @TheGBBookshop - 2 years ago

      Harry Potter and the Cursed Child has held on to the number one spot for a sixth week #HarryPotter #CursedChild @littlebrown @pottermore

    • @TheGBBookshop - 2 years ago

      @thebookseller @MartinaCole @Jeffrey_Archer @Foyles

      @TheGBBookshop - 2 years ago

      Frith wins inaugural Klaus Flugge Prize for illustration

    • @TheGBBookshop - 3 years ago

      RT @Gue_de_Bost: #Dordogneholidaycottage available Sept tweet to book for more info

      @TheGBBookshop - 3 years ago

      The editor is just back from france @HomeAwayUK!