Microsoft Access 2007 Quick Tips Guide: (No. 9 Microsoft Quick Tips Guides)

Microsoft Office Access 2007 Quick Tips Guide - WOW! What can we say, probably the most comprehensive and daring Quick Tips Guide in our range to date! This guide is a complete meal all in one. Microsoft Office Access is traditionally a product that only the die-hard veterans attempt to use and understand and only after flicking through pages and pages of badly written books with titles like "Beginners Guide to - ", "Access for - " and "All you need to know about Access - " Our existing series of "Microsoft Quick Tips Guides" get you straight to the point and allow you to get the job done without having to trawl through pages and pages of blurb. This brand new title certainly doesn't let the side down. The guide is a complete step-by-step walk through of each of the key features and functions of Microsoft Access. Using this guide, you truly start from scratch building a working database element by element and adding features and functionality as you go. You will finish the project culminating in a neatly created dashboard that will help you navigate swiftly around your database. The skills you learn here can then be used to create a bespoke database specifically targeted at your own environment. As usual this guide is written in clear understandable English. The authors are Microsoft Certified Trainers with years of practical experience in training people. If you buy any guide at all then buy this one and forget the others as you won't be disappointed! A must have booklet worth its weight in gold! The Microsoft Office Access 2007 Quick Tips Guide has over 60 pages of real "step-by-step" how to's with detailed instructions. Virtually every page contains full colour pictures of the actual screen Dialog Boxes or Menu Items you will need to complete a task. Unlike other Quick Tips Guides with 200 plus pages, we think our Microsoft Office Access 2007 Quick Tips Guide is extremely practical and teaches you the core skills and how to apply them to different situations!

Table of Contents:
Introduction; Common Database Terminology; The Access 2007 Interface; Getting Started with Microsoft Office Access Page; The Office Button; The Quick Access Toolbar; Moving the Quick Access Toolbar below the Ribbon; Adding Commands to the Quick Access Toolbar; The Ribbon; Minimising the Ribbon; Viewing Dialogue Boxes Contextual Tabs; Customising the Access Environment; Access File Formats: Accdb Vs Mdb; Benefits of Using the New ACCDB File Format; Should I use the ACCDB Format for New Databases?; Limitations of the ACCDB Databases; Should I Convert Existing Databases to the ACCDB Format?; Shortcuts; Opening Databases; Printing and Saving; Using a Combo Box or List Box; Finding and Replacing Text or Data; Working with Wizards; Working in Design View; Editing Controls in Form and Report Design View; Selecting and Moving a Column in Datasheet View; Entering Data in Datasheet or Form View; Using the Keyboard with the Ribbon; Creating A Database From Scratch; Employees And Project Scenario - Microsoft Access Data Model; Relationships For Employee Projects; Creating The Access Database (Employee_Projects.Accdb); Navigating The Access 2007 User Interface; Creating The Tables; Tips On Creating Tables; Creating The Employees Table Step-By-Step Using Design View; Microsoft Office Access Views - Design And Datasheet Views; Switching Between Views; Field Data Types; Setting The Primary Key(S); Saving The Table Design And Switching To Datasheet View; Creating The Other Required Tables; Creating The Project Tables; Creating The Department Table; Creating The Employee_Projects (Link / Junction) Table; Table Relationships; Creating A Table Relationship; Enforcing Referential Integrity; Deleting A Table Relationship; Changing A Table Relationship; Creating The Other Required Table Relationships; Closing The Relationship Window; Queries; Microsoft Office Access Query Types; Select Query; Action Query; Parameter Query; Aggregate Or Crosstab Query; Creating A Select Query; Customising Or Modifying The Query; Saving The Query; Useful Criteria Examples; Creating An Action Query; Creating A Make Table Query; Creating Calculated Fields In A Query; Opening The Newly Created Table; Exporting The Table Into An Excel Format; Creating An Parameter Query; Example Parameter Query Validating The Parameter; Creating An Crosstab Query; Example Crosstab Query; Forms; Form Tools; Creating A Single Item Form By Using The Form Tool - Employees Form; Saving The Form; Understanding Layout View, Design View And Form Sections; Layout View; Design View; Form Sections; Modifying The Form In Layout View; Modifying The Form In Design View; Creating Command Buttons; Enhancing The Command Buttons; Form Properties In Design View; Creating More Forms - Projects And Department Forms; Reports; Report Tools; Understanding Report Sections; Creating A Report Using The Report Tool; Modifying The Report In Layout View; Modifying The Report In Design View; Saving The Report; Creating A Database Switchboard; Creating A Switchboard By Using The Switchboard Manager; Customising The Switchboard Form; Displaying The Switchboard At Startup.