Microsoft® Office AccessTM 2007 Step by Step.

Format:

Book

Author/Creator:

Lambert, Joan.

Contributor:

Lambert, Steve, 1945-

Lambert, M. Dow, III.

Series:

Step by step

Step by step Microsoft Office Access 2007 step by step

Language:

English

Subjects (All):

Microsoft Access.

Database management.

Microsoft Office.

Local Subjects:

Database management.

Microsoft Access.

Microsoft Office.

Physical Description:

1 online resource (0 p.)

Edition:

1st edition

Other Title:

Access 2007 step by step

Place of Publication:

Sebastopol : Microsoft Press, 2009.

Language Note:

English

System Details:

text file

Summary:

Experience learning made easy-and quickly teach yourself how to build database solutions with Access 2007. With Step By Step, you set the pace-building and practicing the skills you need, just when you need them! Build databases from scratch or from templatesExchange data with other databases and Office documentsCreate forms to simplify data entryUse filters and queries to find and analyze informationDesign rich reports that help make your data meaningfulHelp prevent data corruption and unauthorized access

Contents:

Microsoft® Office AccessTM 2007 Step by Step; M. Dow Lambert III; Joan Lambert Preppernau; The Team; Online Training Solutions, Inc. (OTSI); Introducing Access 2007; If You Are Upgrading from Access 2002; If You Are Upgrading from Access 2000; Let's Get Started!; Information for Readers Running Windows XP; Using the Start Menu; Navigating Dialog Boxes; The Microsoft Business Certification Program; Becoming a Microsoft Certified Application Specialist-Microsoft Office Access 2007; Taking a Microsoft Business Certification Exam; Certification; More Information

Features and Conventions of This BookUsing the Book's CD; Minimum System Requirements; Step-by-Step Exercises; Installing the Practice Files; Adding the Practice File Folder to the Trusted Locations List; Using the Practice Files; Removing and Uninstalling the Practice Files; Getting Help; Getting Help with Access 2007; More Information; Quick Reference; 2. Creating a Database; 3. Populating a Database; 4. Sharing and Reusing Information; 5. Simplifying Data Entry by Using Forms; 6. Locating Specific Information; 7. Keeping Your Information Accurate; 8. Working with Reports

9. Making Your Database Easy to Use10. Securing and Sharing Information; 1. Exploring Access 2007; Understanding Database Concepts; Opening an Existing Database; Exploring Tables; Exploring Queries; Exploring Forms; Exploring Reports; Exploring Other Access Objects; Modules; Previewing and Printing Access Objects; Key Points; 2. Creating a Database; Creating a Table Manually; Creating a Table from a Template; Manipulating Table Columns and Rows; Key Points; 3. Populating a Database; Importing Information from an Excel Worksheet; Importing or Linking to a SharePoint List

Collecting Data Through E-MailImporting Information from a Text File; Importing Information from an XML File; Importing Information from an HTML File; Importing Information from an Outlook Folder; Importing Information from a dBASE File; Key Points; 4. Sharing and Reusing Information; Exporting Information to Excel; Exporting Information to a SharePoint List; Exporting Information to Word; Exporting Information to a Text File; Exporting Information to an XML File; Exporting Information to an HTML File; Copying Information to Other Office Programs; Key Points

5. Simplifying Data Entry by Using FormsRefining Form Properties; Changing the Arrangement of a Form; Adding Controls to a Form; Entering Data in a Form by Using VBA; Creating a Form by Using an AutoForm; Adding a Subform to a Form; Key Points; 6. Locating Specific Information; Filtering Information in a Table; Filtering Information by Using a Form; Locating Information That Matches Multiple Criteria; Creating a Query Manually; Creating a Query by Using a Wizard; Performing Calculations by Using a Query; Key Points; 7. Keeping Your Information Accurate

Restricting the Amount of Data in a Field

Notes:

Description based upon print version of record.

ISBN:

9780735635975

0735635978

OCLC:

609857098