Muutke küpsiste eelistusi

FileMaker 8 @work: Projects and Techniques to Get the Job Done [Pehme köide]

1.00/5 (2 hinnangut Goodreads-ist)
  • Formaat: Paperback / softback, 240 pages, laius x paksus: 232x15 mm, kaal: 383 g
  • Ilmumisaeg: 09-Feb-2006
  • Kirjastus: Sams Publishing
  • ISBN-10: 0672328569
  • ISBN-13: 9780672328565
Teised raamatud teemal:
  • Pehme köide
  • Hind: 39,69 €*
  • * saadame teile pakkumise kasutatud raamatule, mille hind võib erineda kodulehel olevast hinnast
  • See raamat on trükist otsas, kuid me saadame teile pakkumise kasutatud raamatule.
  • Kogus:
  • Lisa ostukorvi
  • Tasuta tarne
  • Lisa soovinimekirja
FileMaker 8 @work: Projects and Techniques to Get the Job DoneSuurem pilt
  • Formaat: Paperback / softback, 240 pages, laius x paksus: 232x15 mm, kaal: 383 g
  • Ilmumisaeg: 09-Feb-2006
  • Kirjastus: Sams Publishing
  • ISBN-10: 0672328569
  • ISBN-13: 9780672328565
Teised raamatud teemal:
Püsilink: https://www.kriso.ee/db/9780672328565.html
Märksõnad:
Most books on databases approach the reader with descriptions of how to use tools, and make some reference to putting those tools into a real-world context. FileMaker 8 @Work: Projects and Techniques to Get the Job Done turns this approach on its ear by introducing key tools in a single chapter, then moves on to what you really want to know - how to use the product to complete the projects that they face at work. This book provides step-by-step coverage of how to complete a variety of projects that a panel of users has verified as common projects those using the application are asked to complete. Tips, tricks, and notes are provided with the information you need to carry over what you learn on these projects to others you'll undoubtedly be asked to create.

Muu info

Most books on databases approach the reader with descriptions of how to use tools, and make some reference to putting those tools into a real-world context. FileMaker @work: Projects and Techniques to Get the Job Done turns this approach on its ear by introducing key tools in a single chapter, then moves on to what readers really want to know-how to use the product to complete the projects that they face at work. This book provides step-by-step coverage of how to complete a variety of projects that a panel of users has verified as common projects those using the application are asked to complete. Tips, tricks, and notes are provided to readers with the information they need to carry over what they learn on these projects to others they'll undoubtedly be asked to create.
Introduction 1(1)
Organization of This Book
2(1)
Downloading the Book's Project Files
3(1)
Conventions Used in This Book
3(4)
Part I: Getting Started
Hands-On with FileMaker
7(16)
State-of-the-Art FileMaker
7(3)
FileMaker Through the Decades
8(1)
The FileMaker Family of Products
9(1)
Introducing the Database for This
Chapter
9(1)
Using FileMaker to Browse and Find Data
10(7)
Using the Status Area
11(1)
Browsing Data
12(1)
Finding Data
13(2)
Sorting Data
15(1)
Using Data Entry Fields
16(1)
Exporting FileMaker Data
17(1)
Using Table and List Views
17(1)
Using FileMaker Layout Mode
17(3)
Creating a Layout with FileMaker's Assistance
18(1)
Using FileMaker Fields in Layout Mode
18(2)
Using Layout Parts
20(1)
Creating Reports
20(1)
Using FileMaker Preview Mode
20(3)
Automating FileMaker
23(18)
Introducing ScriptMaker
24(8)
Writing a Basic Script
24(2)
Designing a Script Architecture
26(2)
No Interaction Means No Interaction---Set Error Capture
28(1)
Exploring ScriptMaker Features
29(1)
Using Control Script Steps
30(2)
Debugging Scripts
32(2)
Using Data Viewer
34(1)
Using Script Parameters
35(1)
Using Calculations
36(1)
Developing a Runtime (Standalone) Solution
37(4)
Part II: Projects
Building FileMaker Solutions
41(12)
About the Project
41(1)
Prerequisites
41(1)
Planning a FileMaker Solution
42(2)
What Is the Scope of the Project?
42(1)
What Information Do You Need to Handle?
42(1)
How Should You Talk About the Data?
43(1)
What Are the Rules Governing the Data?
43(1)
What Reports Do You Need?
43(1)
Do You Need to Import or Export Data?
43(1)
Do You Have Ongoing Import/Export Needs?
43(1)
What Are Your Security Needs?
44(1)
Implementing a FileMaker Solution
44(1)
Project: Setting Up Your First Database
44(9)
Getting Started
44(1)
Creating Tables
45(1)
Creating Fields
45(1)
Creating Relationships
46(3)
Creating a Layout
49(1)
Testing Your Solution
49(1)
Sharing FileMaker Databases on a Network
49(1)
Converting and Normalizing a Spreadsheet
50(3)
Managing Inventory
53(16)
About the Project
53(1)
Prerequisites
53(1)
Planning the Project
54(2)
What Are You Keeping Track Of?
54(1)
What Information Will You Store?
54(1)
How Many Items Are There to Keep Track Of?
55(1)
What Are the Rules and Characteristics of the Data?
55(1)
Project: Inventory Manager
56(13)
Getting Started
56(1)
Setting Up a One-Table Database
56(3)
Setting Auto-Entries for Fields
59(1)
Implementing the Data Rules for Validation
60(1)
Creating Your First Layout
60(1)
Creating the Report
61(8)
Managing One-to-Many Relationships
69(16)
About the Project
69(1)
Prerequisites
69(1)
Planning the Project
70(1)
Project: Collections Database
70(15)
Getting Started
70(1)
Adding the Categories Table
70(4)
Relating the Categories Table to the Inventory Table
74(1)
Creating the Category Report
75(4)
Adding Categories to Data Entry
79(6)
Managing Many-to-Many Relationships
85(14)
About the Project
85(1)
Prerequisites
85(1)
Planning the Project
86(1)
Project: Boutique Manager
86(13)
Getting Started
86(1)
Setting Up a Join Table
86(1)
Creating the Many-to-Many Relationship
87(4)
Showing the Relationships in a Layout
91(1)
Enabling Data Entry for the Many-to-Many Relationship
92(3)
Building the Other End of the Relationship
95(4)
Managing Production, Tasks, and Subtasks
99(18)
About the Project
99(1)
Prerequisites
99(1)
Planning the Project
100(1)
Project: Production Management
101(16)
Getting Started
101(1)
Adding the Fields
102(1)
Cleaning Up the Layout
103(1)
Creating the Self-join Relationships
104(1)
Creating the Tabbed Layout
105(2)
Adding Fields to the Task Info Tab
107(1)
Adding the Portal to the Subtasks Tab
107(1)
Implementing Navigation
108(1)
Creating the Script and Adding the Button to Add New Subtasks
109(2)
Adding the Drop-down Calendar
111(2)
Coloring the Date
113(4)
Creating a Secure Shared Database
117(16)
About the Project
117(1)
Prerequisites
117(1)
Planning the Project
118(1)
Project: Idea Tracker
119(14)
Getting Started
119(1)
Modifying the Database: Changing Fields
119(1)
Modifying the Database: Renaming Tables
120(1)
Modifying the Database: Layouts and Scripts
121
Setting Account Privileges
112(13)
Setting Up Networking
125(2)
Testing Instant Web Publishing
127(6)
Implementing a Scheduling Solution
133(20)
About the Project
133(1)
Prerequisites
133(1)
Planning the Project
134(2)
Planning the Data Rules
134(1)
Planning the Interface
134(1)
Preparing to Create New Records with Scripts and Globals
135(1)
Project: Class Enrollment
136(17)
Getting Started
137(1)
Creating the Fields for the Students Table
138(1)
Creating the Fields for the Classes Table
139(1)
Creating the Fields for the Enrollments Table
140(1)
Creating the Fields for the Payments Table
140(1)
Setting Up the Relationships
140(2)
Building the Home Layout and Navigation Script
142(1)
Building the Classes Layout
143(3)
Building the Students Layout
146(2)
Implementing the Enroll Process
148(2)
Implementing the Payment Process
150(3)
Implementing a Runtime Solution
153(20)
About the Project
153(1)
Prerequisites
153(1)
Planning the Project
154(1)
Project: Membership List
154(19)
Getting Started
155(1)
Adding Basic Fields to the Membership Table
155(1)
Implementing Data Hiding
155(2)
Adding Basic Fields to the Dues Table
157(1)
Creating the Membership/Dues Relationship and Calculating the Balance
158(2)
Creating the Data Entry Layout
160(3)
Adding a New Dues Script and Button
163(1)
Creating the Membership List Layout
164(1)
Creating Custom Menu Sets
165(3)
Setting Accounts and Privileges
168(1)
Finishing Security
168(1)
Creating the Runtime Solution
169(4)
Implementing a Simple Web Publishing Solution
173(14)
About the Project
173(1)
Prerequisites
173(1)
Planning the Project
174(1)
Project: Blog
174(13)
Getting Started
174(2)
Creating the Categories Value List
176(1)
Preparing the Blog Layout
177(1)
Setting Instant Web Publishing Privileges in the Database
178(2)
Turning on Instant Web Publishing and Sharing the Database
180(1)
Using a Browser to Connect to the Blog
181(2)
Implementing a Respond Button
183(1)
Creating the Relationships
183(1)
Cleaning up the Layouts
184(1)
Implementing Navigation
185(2)
Converting a Solution to FileMaker Pro 7 or 8
187(22)
About the Project
187(1)
Prerequisites
187(1)
Planning the Project
188(1)
Project: FileMaker Conversion
189(12)
Getting Started
190(1)
Reviewing Field Definitions
190(1)
Reviewing Value Lists
191(1)
Reviewing Relationships
191(2)
Running Conversion
193(1)
Reviewing Converted Field Definitions and Value Lists
194(1)
Reviewing Converted Relationships
194(1)
Reviewing File References
194(2)
Consolidating Tables (with FileMaker Pro Advanced)
196(1)
Consolidating Tables (with Other Versions)
197(4)
Part III: Appendixes
A. FileMaker Error Codes
201(6)
B. FileMaker Resources
207(2)
This Book's Resources
207(1)
FileMaker Resources
207(1)
Relational Databases
208(1)
Security
208(1)
Graphics and Interface
208(1)
Glossary 209(4)
Index 213


Jesse Feiler is a member of the FileMaker Solutions Alliance. He regularly consults on FileMaker and develops FileMaker solutions for small businesses, non-profits, art, retail point-of-sale, publishing, marketing, and other markets. He has worked as a developer and manager for companies such as the Federal Reserve Bank of New York, Prodigy, and Apple. He has created a number of video training courses, including one on FileMaker 7. Jesse appears regularly on WAMC, Northeast Public Radio, on that station's Roundtable and Vox Pop shows, and is the author of a number of Mac OS X books as well as books on database driven websites and FileMaker.