Access 2003
Publisher: Bookboon.com
Published: 2013
ISBN-13: 9788740300444
Table of contents: title: Obsah; title: Section 1 Screen Layout; title: Windows Concepts; title: The Screen Layout; title: Using Help; title: Section 2 Access Overview; title: What is a database?; title: Naming Conventions; title: Planning a Database; title: Section 3 Creating a Database; title: Starting and naming a database; title: Creating a Table; title: Setting a Primary Key; title: Field Properties; title: Other Field Properties; title: Editing the Table Structure; title: Saving Tables; title: Creating a Table using a Table Wizard; title: Section 4; title: Switch between Views of a Table; title: Adding New Records; title: Selecting Fields & Records in Datasheet View; title: Editing Table Data; title: Moving Around a Table; title: The Undo/Redo Command; title: Spell Checking Feature; title: Searching & Replacing Information; title: Searching and Replacing Data; title: Section 5 Table Properties; title: Changing the Table Appearance; title: Modifying the Row Height; title: Altering Column Order; title: Freezing Columns; title: Sorting Data in a Table; title: Section 6 Importing and Linking Data; title: Importing from Access and Excel; title: Importing form Excel; title: Linking to Access and Excel; title: Round Tripping between versions; title: Renaming and Copying Tables; title: Section 7 Using Filter and Select Queries; title: Filtering Data in a Table; title: Filtering Data in a Table; title: Running a Select Query; title: Specifying text, numeric, date, and logic criteria; title: Calculated Fields; title: Using Query Wizards; title: Section 8 Relationships; title: Why do we need relationships; title: Different Types of Relationships; title: Creating a relationship; title: Section 9 Multi-table Queries; title: Multiple Table Queries; title: Deciding which tables to Join; title: Joining Tables for a query; title: Joining Tables in Queries; title: Find Unmatched Query Wizard; title: Find Duplicates Query Wizard; title: Section 10 Creating Forms; title: Using Forms; title: Viewing Forms; title: The Form Wizard; title: Section 11 Form Layout and Formatting; title: Editing Forms; title: The Field List box; title: Formatting Controls; title: Format Painter; title: Section 12 Creating Reports; title: Creating Reports; title: Page Components; title: Grouping and Summarising Data; title: Viewing Reports; title: Mailing Labels