|
Access 2007 in Easy Steps
Unlike other jargon-filled books of hernia-inducing proportions Access 2007 in easy steps is a slim, easily read tome that neatly demonstrates the important functions of Access 2007 in a clear and concise manner.
The guide closely follows the database development life cycle providing a natural progression from the first principles of good
database design to advanced features such as the creation of Forms and Reports.
It equips you with the basic skills needed to interact with Access 2007 on a daily basis using meaningful and appropriate examples that are based on real-life databases.
It even teaches how to integrate Access 2007 with Sharepoint Services, work with your Access 2007 database when away from the office, and collect data using email.
An indispensable guide if you're using Access for the first time or migrating from Excel, or for simply staying up-to-date with the new Access software.
Chapter 1: Getting Started
* What is Access 2007?
* The Getting Started Screen
* The Quick Access Toolbar
* Using the Office Button
* Personalizing Access 2007
* Converting Older Databases
* Using Office Online
* Get Training Online
* Downloading New Content
* Downloading New Templates
* Using Templates
* Using the Ribbon
* Using the Navigation Pane
* Using the Help System
Chapter 2: Designing Databases
* Relational Databases
* Relationship Types
* Database Design
* Before You Even Start Access
* Designing Tables
* Primary and Foreign Keys
* Fine-Tuning Your Design
Chapter 3: Creating Tables
* The Table Window
* Using Table Templates
* Using Datasheet View
* Adding and Deleting Fields
* Data Types in Datasheet View
* Using Design View
* Creating a Table
* Inserting a Design View Row
* Deleting a Design View Field
* Setting the Primary Key
* Using Data Types
* Using Attachments
* Specifying Field Properties
* Using Validation Rules
* Creating an Input Mask
* Setting a Default Value
* Using Indexes
* Creating a Lookup Column
Chapter 4: Defining Relationships
* The Relationships Window
* Adding Tables
* Specifying Relationships
* Referential Integrity
* Specifying Join Properties
* Left and Right Joins
Chapter 5: Working With Data
* Entering Data
* Inserting Rows
* Using the Clipboard
* Copying and Pasting Data
* Copying Directly from Excel
* Copying Data to Excel
* Importing Data from Excel
* Importing Data from Access
* Linking to Access Databases
* Managing Import Tasks
* Collecting Data with Email
* Filtering Data
* Totalling Columns
* Spell-Checking Data
* Formatting Data
Chapter 6: Querying Databases
* What is a Query?
* Using the Query Wizard
* Query Design View
* Adding Criteria to a Query
* Querying Multiple Tables
* Using Criteria for Numbers
* Using Criteria for Text
* Creating a Make Table Query
* Creating an Append Query
* Creating an Update Query
* Creating a Delete Query
Chapter 7: Using SQL
* Using SQL
* The Three Languages of SQL
* Opening the SQL Window
* Using the SELECT Clause
* Using the WHERE Clause
* SQL Aggregate Functions
* Creating Union Queries
Chapter 8:Creating Forms
* What is a Form?
* The Anatomy of a Form
* Using a Form for Data Entry
* Filtering Forms
* Applying a Detailed Filter
* Using the Form Wizard
* Creating a Simple Form
* Using Split Forms
* Using Multiple Item Forms
* Finding a Record
Chapter 9: Fine-Tuning Forms
* Using Design View
* Using Layout View
* Using the Field List
* Adding Headers and Footers
* Adding Controls to a Form
* Fine-Tuning Controls
* Changing Control Properties
* Creating Calculated Controls
* Changing Tab Order
* Creating a Tabbed Form
* Using Buttons
* Creating a Modal Dialog
* Using Macros
Chapter 10: Creating Reports
* Using the Report Wizard
* Creating a Simple Report
* Using Report Design View
* Adding Fields to a Report
* Adding Controls to a Report
* Adding Headers and Footers
* Sorting and Grouping Data
* Printing Labels
* Setting Custom Label Sizes
* Using Print Preview
* Printing Reports
* Send Your Report via Email
Chapter 11: Sharing Access
* Password Protection
* Making an ACCDE Database
* Backing-up Access Databases
* Splitting a Database
* Interacting with SharePoint
|
