Tasuta saatmine! | Klienditugi: 7440010 (E-R 10-18)

Abi | Registreeri | Logi sisse

Learn FileMaker Pro 8.5: . [Pehme köide]

3.00/5 (4 hinnangut Goodreads-ist)

Jonathan Stars

Formaat: Paperback / softback, 526 pages, kaal: 737 g, b/w illlus
Ilmumisaeg: 10-Aug-2006
Kirjastus: Wordware Publishing Inc.
ISBN-10: 159822025X
ISBN-13: 9781598220254

Teised raamatud teemal:

FileMaker

Pehme köide
Hind: 62,64 €*
* 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:
- - 1
  - 2
  - 3
  - 4
  - 5
  - 6
  - 7
  - 8
  - 9
  - 10
Lisa ostukorvi
Tasuta tarne
Lisa soovinimekirja

Formaat: Paperback / softback, 526 pages, kaal: 737 g, b/w illlus
Ilmumisaeg: 10-Aug-2006
Kirjastus: Wordware Publishing Inc.
ISBN-10: 159822025X
ISBN-13: 9781598220254

Teised raamatud teemal:

FileMaker

Püsilink: https://www.kriso.ee/db/9781598220254.html

Märksõnad:

Database management

Preface

xvii

About the Author

Acknowledgments

xxi

Introduction

xxiii

Part 1 Learning the Basics

Getting Acquainted with FileMaker Pro

(11)

Introduction

(1)

What Is a Database?

(1)

Using FileMaker Pro

(1)

Opening FileMaker Pro

(1)

Opening a FileMaker Pro File

(1)

Database Concepts

(5)

Files

(2)

Tables

(1)

Records

(1)

Fields

(1)

Layouts

(1)

Saving a Copy of a FileMaker Pro File

(1)

Closing a FileMaker Pro File

(1)

Quitting FileMaker Pro

(1)

Summary

(2)

Menus and Modes

(15)

Introduction

(1)

Define Database

(7)

Tables Tab

(1)

Fields Tab

(2)

Relationships Tab

(3)

Lookups

(1)

Related Data

(1)

Modes

(4)

Browse Mode

(1)

Layout Mode

(2)

Layout Types

(1)

Find Mode

(1)

Preview Mode

(1)

Menu Commands

(3)

Sort Command

(1)

ScriptMaker

(1)

Accounts and Privileges

(2)

Summary

(1)

Creating Your First Database

(24)

Introduction

(1)

Planning the Database

(3)

Planning This Database

(2)

Creating the File

(2)

Adding Some Fields

(1)

Adding Field Options

(1)

Cleaning Up the Layout

(8)

Format Painter

(1)

Duplicate

(1)

Tool Panel

(1)

Layout Toolbars

(1)

Drawing Tools

(1)

Object Grids

(1)

T-Squares

(1)

Arrow Keys

(1)

Object Info Palette

(1)

Alignment8

(1)

Locking Objects

(1)

Adding Some Data

(1)

Adding a Script

(4)

Simple New Record Script

(1)

Simple Delete Record Script

(1)

Simple Find Script

(2)

Assigning Scripts to Buttons

(1)

Special Situations

(2)

Summary

(4)

Part 2 Using FileMaker Pro

Creating a New Database

(14)

Introduction

(1)

Considerations

(1)

Predefined Databases

(1)

Creating Your Own Database

(1)

What Are Fields?

(9)

Creating a Field

(1)

About Field Names

(1)

The Eight Field Types

(1)

Text Field

(1)

Number Field

(1)

Date Field

(1)

Time Field

(1)

Timestamp Field7

(1)

Container Field

(1)

Calculation Field

(2)

Summary Field

(1)

Global Storage Option

(1)

Repeating Field

(1)

Formatting Your Fields in Japanese7

(1)

Field Formats on Layouts

(2)

Date Format

(1)

Number Format

(1)

Text Format

(1)

Time Format

(1)

Summary

(1)

Entering and Modifying Your Data

(22)

Introduction

(1)

Creating a New Record

(3)

Selecting the Record

(2)

Adding Data

(18)

Selecting the Field

(1)

Using Tab Order

(3)

Data Entry Shortcuts

(1)

Insert

(2)

Copy and Paste

(1)

Drag-and-Drop

(1)

Using Value Lists

(2)

Auto-Complete8

(1)

Calendar Drop-down8

(1)

Using Container Fields

(1)

Insert QuickTime

(1)

Insert Picture

(1)

Insert Sound

(1)

Changing Data

(1)

Highlighting

(1)

Spellchecking

(1)

Visual Spell Checker8

(1)

Replace Command

(1)

Find/Replace

(1)

Revert Command

(1)

Deleting Data

(1)

Summary

(1)

Working with Related Tables --- Part 1

(28)

Introduction

(1)

One or Many Tables?

(2)

One Table --- Flat File Design

(1)

Many Tables --- Relational Design

(2)

Define Your Tables

(21)

Normalize Your Information

(1)

Determine Your Match, or Key, Fields

(1)

Introducing ``Anchor-Buoy'' Relationship Design

(1)

Making the Relationship

(1)

Relationship Tools7

(2)

Tool Icons

(2)

Allow Creation of Related Records

(1)

Parent and Child

100

(1)

Allow Deletion of Related Records

101

(1)

Sort Related Records

102

(1)

Making a Portal

103

(1)

Drawing the Portal

103

(1)

Placing the Fields in a Portal

104

(1)

Adding Data to a Portal Field

105

(1)

Portal Tool Behavior

106

(1)

Sorting a Portal

107

(1)

Investigating the Related Table

108

(2)

Relating a Table Back to the Parent Table

110

(1)

Performing a Find in a Portal

111

(3)

Performance Considerations

111

(1)

Deleting a Record from a Portal

112

(1)

Dealing with ``Portal Pop''

113

(1)

Before We Go

113

(1)

Summary

114

(2)

Working with Related Tables --- Part 2

116

(24)

Introduction

116

(1)

Planning Your Database

116

(1)

Tricky Terms and Catchy Phrases

117

(7)

ER Diagram

117

(1)

One-to-Many Relationship

117

(1)

One-to-One Relationship

118

(1)

Many-to-Many Relationship

118

(1)

The Join, or Link, Table

119

(1)

Self-join Relationship

120

(1)

Multiple-Criteria Relationships7

121

(1)

Unequal Relationships7

122

(1)

The Relationships Graph

123

(1)

Other Notes

123

(1)

Invoice System ER Diagram

124

(1)

Create the Tables

125

(3)

Invoice Table

125

(1)

InvoiceLineItems Table

126

(1)

Import Table8

126

(1)

Product Table

127

(1)

Other Possibilities

127

(1)

Example Data

128

(1)

Create the Relationships

128

(5)

Invoice and InvLI

128

(3)

Invoice and Contact

131

(1)

InvLI and Product

131

(1)

Add the Lookups

132

(1)

The Invoice Layout

133

(5)

Adding Drop-downs to the Invoices

134

(1)

Products Drop-down

134

(2)

Getting the Invoice Total

136

(1)

Customers Drop-down

136

(1)

Placing the Customer Field on the Layout

137

(1)

Other Considerations

138

(1)

Summary

138

(2)

Finding and Sorting Your Data

140

(19)

Introduction

140

(1)

Finding Records

140

(6)

Methods

141

(1)

The Find Symbols

142

(1)

Less Than (<)

142

(1)

Less Than or Equal To (≤ or < = on Macintosh, < = on Windows)

143

(1)

Greater Than (>)

143

(1)

Greater Than or Equal To (≥ or > = on Macintosh, > = on Windows)

143

(1)

Exact Match (=)

143

(1)

Range (...)

143

(1)

Duplicates (!)

143

(1)

Today's Date (//)

144

(1)

Invalid Date or Time (?)

144

(1)

One Character (@)

144

(1)

Zero or More Characters (*)

145

(1)

Literal Text (`` '')

145

(1)

Relaxed Search (~)

145

(1)

Field Content Match (= =)

145

(1)

AND Finds

145

(1)

OR Finds

145

(1)

Constrain and Extend Found Set

146

(6)

Constrain Found Set

146

(1)

Extend Found Set

147

(1)

Quick Find8

148

(1)

Auto-Complete8

148

(1)

Other Find Tricks

148

(1)

Within Scripts

149

(2)

Find Strategies

151

(1)

Limitations

152

(1)

Omitting Records

152

(2)

Methods

152

(1)

Omit Multiple

153

(1)

Omit as Part of a Find

153

(1)

Show Omitted

153

(1)

Within Scripts

153

(1)

Strategies

154

(1)

Limitations

154

(1)

Sorting Records

154

(3)

Methods

154

(1)

Within Scripts

155

(1)

Strategies

155

(1)

Sort By a Summary Field

155

(2)

Limitations

157

(1)

Summary

157

(2)

Creating New Layouts with the Layout Assistant

159

(13)

Introduction

159

(1)

Create a New Layout

159

(11)

Standard Form

160

(1)

Specify Fields

160

(1)

Select a Theme

161

(1)

Columnar List/Report

162

(1)

Choose Report Layout

163

(1)

Organize Records by Category

163

(1)

Sort Records

163

(1)

Specify Subtotals

164

(1)

Specify Grand Totals

164

(1)

Header and Footer Information

165

(1)

Create a Script for This Report

165

(1)

Cleaning Up

165

(1)

Sub-summary Part Definition

166

(1)

Table View

167

(1)

Labels

168

(1)

Envelope

169

(1)

Blank Layout

169

(1)

Summary

170

(2)

Part 3 Turning Your Data into Information

Keeping Your Data Clean and Neat

172

(12)

Introduction

172

(1)

Field Data Entry Options

172

(1)

Auto-Enter Tab (Automatically Entering Values)

173

(3)

Creation

173

(1)

Modification

173

(1)

Serial Number

173

(1)

Value from Last Visited Record

174

(1)

Data

174

(1)

Calculated Value

174

(1)

Looked-up Value

175

(1)

Prohibit Modification

176

(1)

Validation Tab (Checking Data for Accuracy)

176

(3)

Validate Data in This Field7

176

(1)

Strict Data Type

177

(1)

Not Empty

177

(1)

Unique Value

178

(1)

Existing Value

178

(1)

Member of Value List

178

(1)

In Range

178

(1)

Validated By Calculation

178

(1)

Maximum Number of Characters

179

(1)

Display Custom Message if Validation Fails

179

(1)

Storage Tab (Global Storage, Repeating, and Indexing)

179

(3)

Global Storage

179

(1)

Repeating Field Options

180

(1)

FileMaker's Indexing System

181

(1)

Storage Options

181

(1)

Field Indexing Pros and Cons

181

(1)

Limitations

182

(1)

Furigana Tab7

182

(1)

Summary

183

(1)

Putting Your Data to Work for You

184

(13)

Introduction

184

(1)

Defining a Calculation Field

184

(11)

Operators

185

(1)

Mathematical Operators

185

(3)

Comparison Operators

188

(3)

Logical Operators

191

(2)

Text Operators

193

(2)

Other Options

195

(1)

Storage Option

195

(1)

Repeating Field

195

(1)

Do Not Evaluate

195

(1)

Limitations

196

(1)

Summary

196

(1)

Real-World Calculations --- Part 1

197

(16)

Introduction

197

(1)

FileMaker's Help Files

197

(1)

What Are Functions?

198

(4)

Text Functions

198

(1)

Left

199

(1)

A Calculation within a Calculation

200

(1)

LeftWords

200

(1)

Length

200

(1)

Position

201

(1)

Building Complex Calculations

202

(4)

The Steps

202

(1)

Using the Process

202

(3)

Make It Permanent

205

(1)

Number Functions

206

(3)

The Process

206

(3)

A Calculation for FMP7 and Later

209

(1)

Date and Time Functions

209

(2)

Time Clock

210

(1)

Commenting Calculations7

211

(1)

Summary

212

(1)

Real-World Calculations --- Part 2

213

(23)

Introduction

213

(1)

Aggregate Functions

213

(1)

Aggregate Examples

213

(1)

Summary Functions

214

(2)

GetSummary Example

215

(1)

Repeating Functions

216

(3)

GetRepetition Example

216

(3)

Financial Functions

219

(1)

PMT Example

219

(1)

Trigonometric Functions

220

(1)

Pi Example

220

(1)

Logical Functions

221

(6)

If and Case

221

(1)

Is Empty

222

(1)

Evaluate7

222

(2)

Let7

224

(2)

GetLayoutObjectAttribute8.5

226

(1)

Get Functions7

227

(1)

Get (RecordNumber) Example

227

(1)

Design Functions

228

(2)

FieldNames and FieldStyle Examples

228

(2)

External Functions

230

(1)

Text Formatting Functions7

231

(1)

Timestamp Functions

231

(1)

Custom Functions7

232

(1)

Summary

232

(4)

Part 4 Creating a Real Solution

Automating Your Database with Scripts

236

(39)

Introduction

236

(1)

What Are Scripts?

236

(2)

One Step at a Time

237

(1)

Script Options

238

(1)

Planning Your Script

238

(2)

Where Am I Now?

239

(1)

What Do I Want to Do?

240

(1)

Where Do I Want to Be When I Finish?

240

(1)

What Can Go Wrong?

240

(1)

Script Steps Overview

240

(2)

Script Steps

241

(1)

Control Category

241

(1)

Main Menu Script Example

242

(11)

Going to Contact

243

(1)

Fail-safe

244

(2)

Getting Back

246

(1)

Testing

246

(1)

Access the Main Menu Layout from Other Files

247

(3)

Using Layouts from Other Files7

250

(1)

Portable Portals7

251

(2)

Print Invoices Example

253

(8)

Else If7

253

(1)

The Print Script

254

(1)

The Invoices Scripts

255

(2)

Figuring Interest

257

(1)

Printing One Invoice

258

(1)

Monthly Billing Script

258

(1)

Testing Monthly Billing

258

(1)

Thoughtful Additions

259

(1)

Printing to PDF8

259

(1)

Script Variable8

260

(1)

Match Found Set (Related Records)8

261

(1)

Debugging Scripts

261

(3)

Important Hints

262

(2)

Import Scripts

264

(4)

Button Options (Pause, Halt, Exit, Resume)

264

(1)

Startup/Shutdown Scripts

265

(1)

Show Custom Dialog Script Step

265

(3)

Other Features

268

(5)

New Window7

268

(2)

Script Parameters7

270

(2)

Accounts Script Category7

272

(1)

File References7

273

(1)

And Finally

273

(1)

Summary

273

(2)

Making Sense of Your Information with Layouts

275

(13)

Introduction

275

(1)

What Is a Layout?

275

(7)

Layout Types

276

(1)

On-screen Layouts (Data Entry)

276

(4)

Printed Layouts

280

(2)

Layout Parts

282

(3)

Title Header

283

(1)

Header

283

(1)

Body

284

(1)

Leading and Trailing Sub-summaries

284

(1)

Leading and Trailing Grand Summaries

285

(1)

Footer

285

(1)

Title Footer

285

(1)

Working with Layout Parts

285

(1)

Adding and Deleting Parts

286

(1)

Modifying Parts

286

(1)

Summary

286

(2)

Designing Your Screen Layouts

288

(19)

Introduction

288

(1)

Basic Design

288

(9)

Know What You Like

289

(2)

Keep It Consistent

291

(1)

Group Formatting

291

(1)

Selecting Groups of Layout Objects

292

(1)

How to Make It Pretty

293

(1)

Arrange and View Menus

293

(1)

Rotate Layout Objects

294

(1)

Icons

294

(1)

Locking Objects on a Layout

295

(1)

Adding Graphics and Movies to a Layout

296

(1)

Formatting Graphics on a Layout

296

(1)

Customizing the Appearance of Objects on a Layout

297

(2)

Adding Borders, Baselines, and Fills to Fields

297

(1)

Adding Object Effects

298

(1)

Embossed

298

(1)

Engraved

298

(1)

Drop Shadow

298

(1)

Changing Colors

298

(1)

Tab Control8

299

(4)

Object Names8.5

303

(1)

Tooltips8

304

(1)

Summary

305

(2)

Designing Your Printed Report Layouts

307

(21)

Introduction

307

(1)

What Is a Report?

307

(2)

Creating a Useful and Attractive Report

307

(1)

Report Types

308

(1)

Creating a Report

309

(1)

What Results Do You Want?

309

(1)

What Data Do You Have (and Not Have)?

309

(1)

Example Reports

309

(15)

Customer Sales Report

309

(1)

Setup --- Making the Data Available

310

(1)

Building the Report

310

(1)

Touchup Work

311

(1)

How to Set Up a Find Layout

312

(6)

Percent of Sales by Product Report

318

(1)

Building the Report

318

(1)

Touchup Work

319

(1)

How to Set Up This Find Layout

319

(2)

Other Common Reports

321

(1)

Avoiding the Today Function in Calculations

321

(2)

Organizational Details

323

(1)

Summary

324

(4)

Part 5 Sharing Your Database

Personal Data Sharing

328

(12)

Introduction

328

(1)

What Is Personal Data Sharing?

328

(2)

Capabilities

329

(1)

Network Requirements

329

(1)

Using Personal File Sharing

330

(9)

Using Files as a Guest

331

(1)

Sharing Remotely by Way of Modem

332

(1)

File Sharing Caution

333

(1)

Limitations

334

(1)

File and Guest Limits

334

(1)

Global Fields and Shared Files

334

(1)

Optimizing Performance

335

(1)

Hardware Considerations

336

(1)

FileMaker Server

336

(1)

Some Final Words

336

(1)

Closing Hosted Files

337

(1)

Slow Network Traffic

337

(1)

Save/Send Records as Excel8

337

(1)

Export Field Contents/Fast Send8

338

(1)

Summary

339

(1)

Sharing Your Data on the Web

340

(20)

Introduction

340

(1)

Why Publish on the Web?

340

(1)

FileMaker and Instant Web Publishing (IWP)

341

(17)

Setting Up Your Computer

341

(1)

If You Have an Internet Account

341

(3)

If You Don't Have an Internet Account

344

(1)

Setting up FileMaker Pro for IWP

344

(1)

Instant Web Publishing Settings

345

(1)

Advanced Options

346

(1)

Setting Up Your Database

347

(1)

Browsers

348

(1)

Layouts

349

(2)

IWP Browser Interface

351

(3)

Web Security

354

(1)

Try It Out

355

(1)

Other Notes and Options

356

(2)

Cool Web Sites Powered by FileMaker

358

(1)

Summary

359

(1)

Sharing Your Data with Other Applications

360

(20)

Introduction

360

(1)

Using FileMaker's Import and Export Commands

360

(1)

ODBC Sharing

361

(11)

Making FileMaker Data Available to Other Applications

362

(2)

Getting Data from Another Application

364

(1)

Setting Up the Data Source (Macintosh OS X)

364

(2)

Importing the Data (Macintosh)

366

(1)

Setting Up the Data Source (Windows)

367

(1)

Importing the Data (Windows)

368

(3)

Saving the Import as a Script

371

(1)

Execute SQL Script Step

372

(1)

Converting and Importing Data from Microsoft Excel

373

(1)

Importing a Folder of Files in a Single Operation

374

(2)

Summary

376

(4)

Part 6 Protecting Your Information

Keeping Your Data Secure

380

(30)

Introduction

380

(1)

Why Protect Your Data?

380

(1)

FileMaker Security

380

(1)

Accounts Tab7

381

(4)

Edit Account7

381

(1)

Guest Account7

381

(2)

Admin Account7

383

(1)

New Account7

383

(1)

A Word about Passwords

384

(1)

Privilege Set7

384

(1)

Privilege Sets Tab7

385

(13)

Edit Privilege Set7

386

(1)

Data Access and Design

386

(11)

Other Privileges7

397

(1)

Extended Privileges7

398

(1)

Extended Privileges Tab7

398

(3)

Expand and/or Reduce Privileges

401

(3)

Editing and Deleting Accounts7

402

(1)

Editing

402

(1)

Cautions

402

(2)

Limiting Access through Scripting

404

(1)

Startup Script

404

(1)

Controlling Layout Access

405

(1)

Limiting Access through Field Calculations

405

(3)

The Script

406

(1)

The Calculation

406

(2)

Internet Considerations

408

(1)

Conversion Issues

408

(1)

Summary

408

(2)

Backup and Recovery

410

(20)

Introduction

410

(1)

Why Back Up?

410

(3)

FileMaker Server Backup Features

411

(1)

Using Commercial Backup Applications

411

(1)

Problems with Tape

412

(1)

Database Corruption

413

(2)

What Is a Clone?

414

(1)

Saving a Clone

414

(1)

Backup Routine

415

(7)

While You Work

416

(1)

Other Related Measures

416

(1)

FileMaker Techniques

417

(3)

More about Exporting

420

(1)

One-Record Table

421

(1)

Using Your Backups

422

(5)

Restoring

422

(2)

Importing Data

424

(1)

More about Importing

425

(1)

Typing Up the Loose Ends

425

(2)

Summary

427

(3)

Part 7 Beyond FileMaker

FileMaker Mobile 8

430

(14)

Introduction

430

(1)

Installation Overview

431

(8)

Setting Up Your Connections

432

(1)

Syncing

433

(1)

FileMaker Mobile Setup

433

(1)

Starting Over

434

(1)

Mobile Settings

435

(1)

Properties

436

(1)

Synchronization Options

437

(1)

Sync Me, Baby

437

(2)

Other Stuff

439

(1)

Going Mobile

439

(3)

FileMaker Appointments

439

(2)

PDA Calendar

441

(1)

Contacts

441

(1)

Grocery List

441

(1)

FileMaker Mobile vs. FileMaker Pro

442

(1)

Summary

443

(1)

FileMaker and XML

444

(9)

Introduction

444

(1)

What Is XML?

444

(1)

Add in XSL

445

(1)

What Can I Use It For?

445

(2)

Examples: Exporting XML as HTML

447

(3)

Using a Local XSL Style Sheet

447

(1)

Creating the Export XML Script

448

(1)

Using a Remote XSL Style Sheet

449

(1)

And Beyond . . .

450

(1)

Profile of a FileMaker XML Web Request

450

(1)

Import XML

451

(1)

Open XML

451

(1)

Summary

451

(2)

FileMaker and the Internet

453

(16)

Introduction

453

(1)

Web Viewer8.5

453

(1)

Creating a Web Viewer

454

(3)

Web Viewer Economy

457

(3)

Layout Work

458

(1)

Importing Some Data

458

(1)

Working with the Radio Buttons

459

(1)

Working with the Web Viewer

460

(5)

Getting the URL

460

(1)

Mini Web Viewer

461

(1)

Automatically Filling Out Forms --- Not

461

(1)

Which Way Did He Go?

462

(1)

Back and Ahead Buttons

463

(1)

Screen Scraping

464

(1)

Saving the URL

465

(1)

The Example File

465

(1)

The Web Viewer and Other Applications

465

(1)

Cleaning Up

466

(1)

Rules

466

(1)

Suggested Uses

467

(1)

Summary

468

(1)

File Conversion Issues and Answers

469

(10)

Introduction

469

(1)

Documentation

469

(1)

Step By Step

470

(6)

Conversion Log

472

(1)

Comparing Fields

472

(1)

Comparing Layouts

473

(1)

Accounts & Privileges

473

(1)

Comparing Scripts

474

(1)

Comparing Relationships

474

(1)

File References

475

(1)

Learn FileMaker Pro 8.5: . [Pehme köide]

Konto & seaded

Otsing

Otsingu andmebaas

Filtreeri tulemusi

Teemad Ingliskeelsed raamatud

Vali ostukorv