Sams Teach Yourself FileMaker 7 in 24 Hours

Note: Supplemental materials are not guaranteed with Rental or Used book purchases.

ISBN: 9780672325786 | 0672325780
Cover: Paperback
Copyright: 1/1/2004

Sorry, this item is currently not available.

& bull; The only entry-level turorial that teaches FileMaker from the ground up and offers complete coverage of the latest version of the software. & lt;br/ & gt; & bull; Covers how to customize the out-of-the-box databases as well as create databases and FileMaker solutions from scratch. & lt;br/ & gt; & bull; Discusses how to network databases on LANs and the Internet, develop Web-based interfaces to databases, and manage database security.

Introduction

(4)

Part I: Getting Started with FileMaker-Using the Templates

Introducing FileMaker

(12)

A Brief History of FileMaker

(1)

The FileMaker Market

(2)

How FileMaker Works: Overview

(2)

Database Management Systems

(1)

FileMaker's Role

(1)

Database Programming

(1)

Talking About FileMaker: A Guide to Terminology

(1)

Talking About FileMaker: The Product Line

(1)

FileMaker Pro

(1)

FileMaker Server and FileMaker Server Advanced

(1)

FileMaker Developer

(1)

FileMaker Mobile

(1)

Introducing the FileMaker Templates

(2)

Home

(1)

Education

(1)

Business---Finance

(1)

Business---General

(1)

Business---People & Assets

(1)

Business---Projects

(1)

Summary

(1)

Q&A

(1)

Workshop

(2)

Quiz

(1)

Quiz Answers

(1)

Activities

(2)

Using FileMaker and Its Basic Templates

(22)

Exploring the FileMaker Interface

(3)

Buttons and Toolbars

(1)

Tabs

(1)

Editable and Noneditable Fields

(1)

Using the Status Area and FileMaker Modes

(6)

Browse Mode

(1)

Find Mode

(2)

Layout Mode

(1)

Preview Mode

(1)

Using Basic FileMaker Menus

(1)

Working with FileMaker Windows

(1)

Working with FileMaker Views

(1)

Form View

(1)

List View

(1)

Table View

(1)

FileMaker Preferences

(2)

FileMaker Toolbars

(2)

Standard Toolbar

(2)

Text Formatting Toolbar

(1)

Entering Data

(2)

Entering Text

(1)

Spell Checking

(1)

Working with Containers, Graphics, Movies, and Files

(1)

Summary

(1)

Q&A

(1)

Workshop

(2)

Quiz

(1)

Quiz Answers

(1)

Activities

(1)

Finding and Sorting Data

(12)

Overview of Finding Data

(3)

Reasons for Finding Data

(1)

Mechanisms for Finding Data

(1)

Setting Up Data for Retrieval

(1)

Steps for Finding Data

(1)

Creating Find Requests

(4)

Creating the Simplest Find Requests

(1)

Finding Duplicates

(1)

Finding Text

(1)

Finding Numbers, Dates, and Times

(1)

Ranges of Data

(1)

Omitting Data

(1)

Sorting Data

(1)

Summary

(1)

Q&A

(1)

Workshop

(2)

Quiz

(1)

Quiz Answers

(1)

Activities

(1)

Introducing Layouts

(20)

About Layouts

(1)

Using the Layout Status Area

(4)

Mode Buttons

(1)

Navigation Tools

(1)

Tool Panel

(2)

Using Graphics Controls

(2)

How to Add and Format Fields

(12)

Adding Fields to the Layout

(1)

Text

(3)

Number

(1)

Date

(1)

Time

(1)

Graphic

(1)

Button

(1)

Portal

(1)

Field Format

(3)

Field Behavior

(1)

Field Borders

(1)

Summary

(1)

Q&A

(1)

Workshop

(1)

Quiz

(1)

Quiz Answers

(1)

Activities

(1)

Printing Data

(18)

About Printing

(1)

Print a Layout

(1)

Print Wide and Tall Layouts

(1)

Prepare Layouts for Printing: Margins and Sliding

(4)

Margins

(1)

Sliding

(2)

Printing Information About the Database

(3)

Printing Envelopes and Labels

(3)

Printing Envelopes

(2)

Printing Labels

(1)

Summary

(1)

Q&A

(1)

Workshop

(4)

Quiz

(1)

Quiz Answers

(1)

Activities

(4)

Part II: Modifying Templates and Databases

Validating and Auto-Entering Data

(16)

About Validation

(1)

Setting Auto-Entry Options

(6)

Creation and Modification Tracking

(1)

Serial Numbers

(1)

``Sticky'' Values

(1)

Data Values

(1)

Calculated Results

(1)

Looked-up Values

(2)

Setting Validation Options

(3)

Strict Data Types

(1)

Not Empty/Unique/Existing

(1)

Member of Value List/Specific Values

(1)

Range

(1)

Calculation Edit

(1)

Maximum Number of Characters

100

(1)

Replacing Field Values

100

(1)

Summary

101

(1)

Q&A

102

(1)

Workshop

102

(3)

Quiz

102

(1)

Quiz Answers

103

(1)

Activities

103

(2)

Working with Calculations, Formulas, Functions, and Repeating Fields

105

(16)

About Calculations, Formulas, and Functions

106

(1)

Calculations in Use: The Expense Report Template

107

(4)

Examining a Calculation

107

(2)

Displaying the Calculation

109

(2)

Formatting Calculations

111

(1)

Setting Calculation Storage

111

(1)

Working with Repeating Fields

112

(3)

How Repeating Fields Work

112

(2)

When to Use Repeating Fields

114

(1)

When Not to Use Repeating Fields

114

(1)

Creating a Calculation

115

(3)

Change the Field to a Calculation

116

(1)

Create an If Test

116

(1)

Set Values in the If Test

117

(1)

Modify the Layout

118

(1)

Summary

118

(1)

Q&A

119

(1)

Workshop

119

(2)

Quiz

119

(1)

Quiz Answers

119

(1)

Activities

120

(1)

More on Working with Scripts

151

(18)

Writing a Find Script

151

(7)

Entering Find Mode and Creating the Find Request

153

(1)

Displaying the Dialog and Getting User Input

153

(3)

Performing the Find and Returning to Browse Mode

156

(1)

Attaching the Script to the Button

156

(2)

Implementing the Cancel Button with an If Script Step

158

(1)

Specifying Find Requests

159

(2)

Debugging Scripts

161

(3)

Stepping Through Scripts

162

(1)

Using ScriptMaker

162

(1)

Using Breakpoints

163

(1)

Sharing Scripts

164

(1)

Summary

165

(1)

Q&A

166

(1)

Workshop

166

(3)

Quiz

166

(1)

Quiz Answers

167

(1)

Activities

167

(2)

Importing and Exporting Data

169

(14)

About Data Sharing

170

(1)

File Formats

171

(2)

Importing Data into FileMaker

173

(3)

Replacing and Updating Data with Match Fields

176

(1)

Converting Excel Spreadsheets to FileMaker Databases

176

(1)

Exporting Data from FileMaker

177

(1)

Importing from a Folder

178

(1)

Summary

179

(1)

Q&A

180

(1)

Workshop

180

(3)

Quiz

180

(1)

Quiz Answers

181

(1)

Activities

181

(2)

Working with ODBC and JDBC

183

(22)

What Is ODBC?

184

(1)

Very Basic SQL

185

(1)

Terminology in SQL and FileMaker

185

(1)

Constructing Queries in SQL

185

(1)

The Basic SQL Rule

186

(1)

The FileMaker ODBC Example

186

(1)

Setting Up a Data Source on Windows

187

(4)

Run ODBC Data Source Administrator

187

(2)

Create a New Data Source

189

(1)

Select the Driver

189

(1)

Set Up the Driver

190

(1)

Define the Data

190

(1)

Setting Up a Data Source on Mac OS X

191

(3)

Run ODBC Configure

192

(1)

Create a New Data Source

192

(1)

Select the Driver

192

(1)

Set Up the Driver

192

(1)

Define the Data

193

(1)

Importing Data from a Data Source with FileMaker

194

(5)

Summary

199

(1)

Q&A

200

(1)

Workshop

200

(5)

Quiz

200

(1)

Quiz Answers

200

(1)

Activities

201

(4)

Part III: Creating FileMaker Solutions

Creating a FileMaker Database

205

(24)

Database Programming

206

(1)

Creating a Database

207

(6)

Creating the Database

208

(1)

Defining Fields

209

(1)

Setting Field Options

209

(4)

Working with Field Types and Repeating Fields

213

(5)

Text Fields

214

(1)

Repeating Fields

214

(1)

Date Fields

215

(1)

Time Fields

215

(1)

Number Fields

215

(1)

Calculation Fields

215

(2)

Container Fields

217

(1)

Timestamp Fields

217

(1)

Summary Fields

218

(1)

Exploring the Define Database Dialog

218

(2)

Tables Tab

218

(1)

Relationships Tab

218

(2)

Value Lists

220

(3)

File Options

223

(2)

Set Open/Close Options

223

(1)

Set Spelling Options

224

(1)

Set Text Options

224

(1)

Summary

225

(1)

Q&A

226

(1)

Workshop

226

(3)

Quiz

226

(1)

Quiz Answers

227

(1)

Activities

227

(2)

Working with Relationships

229

(22)

Introducing the Relational Model

230

(3)

Creating a Relationship

230

(1)

Characteristics of Relationships

231

(1)

Adding People to Parties

232

(1)

Normalizing a Database

233

(3)

First Normal Form

233

(1)

Second Normal Form

234

(1)

Third Normal Form

235

(1)

Normalization Guidelines

235

(1)

Add Tables to a Database

236

(3)

Modify the Parties Table

236

(1)

Create the Guests Table

237

(1)

Create the Telephone Numbers Table

238

(1)

Create Relationships

239

(2)

Create the PartiesAndGuests Join Table

240

(1)

Relationships to Aliased Tables

241

(1)

Using File References

242

(3)

Creating a File Reference

243

(1)

Adding Files to a File Reference

244

(1)

Using Self-Joins

245

(1)

Working with Contexts

245

(1)

Using Lookup and LookupNext Functions

246

(1)

Summary

247

(1)

Q&A

248

(1)

Workshop

248

(3)

Quiz

248

(1)

Quiz Answers

249

(1)

Activities

249

(2)

More About Layouts

251

(20)

Using Default FileMaker Layouts

252

(3)

General Layout Settings

253

(1)

Adjust View Settings

254

(1)

Modify Print Settings

255

(1)

Using FileMaker to Create Customized Layouts

255

(3)

Other Layout Settings

258

(2)

Using Related Fields in Layouts

260

(1)

Using Portals for Relationships

261

(6)

Create a Portal

262

(1)

Set Up the Portal with a Related Table

262

(2)

Add Fields to the Portal

264

(1)

Allow Editing of the Portal

265

(2)

Summary

267

(1)

Q&A

268

(1)

Workshop

268

(3)

Quiz

268

(1)

Quiz Answers

269

(1)

Activities

269

(2)

Advanced FileMaker Scripting: Design Issues, Script Parameters, and Working with Related Records

271

(22)

Designing Scripts for FileMaker Solutions and Vice Versa

272

(1)

Using Scripts to Manage Related Records

273

(8)

Creating a Button to Delete a Related Row in the Portal

274

(2)

Creating a Button to Display the Related Record in Another Layout

276

(5)

Using Script Parameters to Add Related Records

281

(7)

Implementing Invitations

281

(6)

Implementing Disinvitations

287

(1)

Importing Scripts

288

(1)

Summary

289

(1)

Q&A

290

(1)

Workshop

291

(2)

Quiz

291

(1)

Quiz Answers

291

(1)

Activities

291

(2)

Working with Summaries and Layout Parts

293

(20)

Preparing the Parties Database for Reporting

294

(4)

Add Client Information

295

(1)

Add a Budget Summary Field

296

(1)

Update the Data Entry Layout

297

(1)

Creating a Report with the FileMaker Assistant

298

(7)

Looking at the Report Parts

305

(1)

Examining the Script

306

(2)

Modifying the Layout

308

(1)

Summary

309

(2)

Q&A

311

(1)

Workshop

311

(2)

Quiz

311

(1)

Quiz Answers

311

(1)

Activities

311

(2)

Securing Your Solutions and Databases

313

(16)

About Security

314

(1)

Overview of FileMaker Security

315

(1)

Accounts

315

(1)

Privileges

316

(1)

Implementing Security

316

(1)

Defining Accounts

316

(2)

Defining Privileges

318

(5)

Access to Records

320

(1)

Access to Layouts

321

(1)

Access to Value Lists

322

(1)

Access to Scripts

323

(1)

Defining Extended Privileges

323

(1)

Turning Security On

324

(2)

Verifying User ID

324

(1)

Activating Database Security

325

(1)

Summary

326

(1)

Q&A

327

(1)

Workshop

327

(2)

Quiz

327

(1)

Quiz Answers

327

(1)

Activities

328

(1)

Finishing Up: Help, Testing, and Keeping Things Running

329

(18)

Providing Help and Assistance

330

(4)

General Help Authoring Issues

330

(1)

Providing Help in a Global Field

331

(1)

Providing Help with a Script and a Layout

332

(1)

Providing Help with a Custom Dialog

333

(1)

Use a Script Parameter to Provide Help

333

(1)

Preventing the Need for Help

334

(1)

Testing FileMaker Solutions

334

(4)

Types of Testing

335

(1)

Prepare a Test Suite

336

(1)

Usability Testing

337

(1)

Tracking Problems

338

(1)

Keeping Things Running

338

(5)

Recovering Databases

338

(1)

Replace Field Contents

339

(1)

Relookup Field Contents

340

(1)

Insert from Index

341

(1)

Insert from Last Visited Record

342

(1)

Summary

343

(1)

Q&A

344

(1)

Workshop

344

(3)

Quiz

344

(1)

Quiz Answers

345

(1)

Activities

345

(2)

Creating Solutions with FileMaker Developer

347

(12)

Database Design Report

348

(2)

Using Developer Utilities to Create Standalone Solutions

350

(3)

Specify the Solution Name and the Files Needed

351

(1)

Set Solution Options

352

(1)

File Maintenance

353

(1)

Custom Functions

353

(2)

Summary

355

(1)

Q&A

356

(1)

Workshop

356

(3)

Quiz

356

(1)

Quiz Answers

356

(1)

Activities

356

(3)

Part IV: Sharing FileMaker Solutions

Sharing Databases with FileMaker Pro

359

(18)

About FileMaker Networking

360

(3)

Database Sharing and Networking Terminology

360

(2)

TCP/IP: The Network Protocol

362

(1)

Adjust Your Firewall

363

(5)

Adjusting the Firewall on Windows

364

(2)

Adjusting the Firewall on Mac OS X

366

(2)

Set Up Sharing with FileMaker Pro

368

(1)

Connecting to a Shared FileMaker Database

369

(1)

Locking Databases (Shared Database Etiquette)

370

(3)

Shared Databases Are Updated When You Commit Changes

371

(1)

Only One User Can Make Changes at a Time

371

(1)

Shared Databases to Which People Are Attached Cannot Be Closed

372

(1)

Summary

373

(2)

Q&A

375

(1)

Workshop

375

(2)

Quiz

375

(1)

Quiz Answers

376

(1)

Activities

376

(1)

Using FileMaker on the Web or an Intranet: Instant Web Publishing

377

(16)

About Instant Web Publishing

378

(1)

Using the Instant Web Publishing Interface

379

(4)

The FileMaker Database Homepage

379

(1)

Browse Mode in Instant Web Publishing

380

(2)

Navigating Through a Database

382

(1)

Using Find Mode on the Web

383

(1)

Publishing a Database Using Instant Web Publishing

383

(3)

Designing for Instant Web Publishing

386

(3)

Scripts for Instant Web Publishing

386

(1)

Colors, Fonts, and Graphics for Instant Web Publishing

387

(1)

General Design Concerns for Instant Web Publishing

388

(1)

Summary

389

(1)

Q&A

390

(1)

Workshop

390

(3)

Quiz

390

(1)

Quiz Answers

391

(1)

Activities

391

(2)

Using FileMaker and XML with Other Applications

393

(12)

The XML Difference

394

(1)

Setting Up the Example

394

(2)

Exporting XML

396

(2)

Inside an XML Document

398

(2)

XML Can Be Self-Descriptive

398

(1)

XML Is Designed to Be Parsed and Generated Primarily by Software

398

(1)

Plain Text

398

(1)

Elements Are Closed

399

(1)

Elements Can be Nested

399

(1)

There Is Always a Root

399

(1)

Attribute Values Are Quoted

399

(1)

Using Quotes

399

(1)

White Space Matters

399

(1)

XML Validation

400

(1)

Escaped Characters

400

(1)

The XML Export File from the Example

400

(2)

What Next?

402

(1)

Summary

402

(1)

Q&A

403

(1)

Workshop

403

(2)

Quiz

403

(1)

Quiz Answers

403

(1)

Activities

404

(1)

Using FileMaker, XML, and XSLT

405

(16)

Transforming XML Exports into HTML

406

(2)

Exporting Simple Tables to HTML

406

(2)

Exporting Subsummary Tables to HTML

408

(1)

A Look at XSLT

408

(4)

XSLT Basics

409

(1)

The Top of the Style Sheet: Basic Declarations

409

(1)

Displaying the Data in an HTML Table

410

(2)

The Bottom of the Style Sheet: Ending Up

412

(1)

Modifying the Simple Table Transformation

412

(2)

Using XPath Expressions to Select and Manipulate Text

414

(1)

Summary

415

(1)

Q&A

416

(1)

Workshop

417

(4)

Quiz

417

(1)

Quiz Answers

417

(1)

Activities

417

(4)

Part V: Appendices

APPENDIX A: Converting from Previous Versions of FileMaker

421

(8)

Getting Started with Conversion

421

(2)

Remove Calculations for Relationships

423

(1)

Replace Finds with Nonequal Relationships and Self-Joins

423

(3)

Use Row Numbers in Portals

426

(1)

Sort Portals

427

(1)

Use Timestamp Fields

427

(1)

Use XML

428

(1)

Explore the Instant Web Publishing Script Steps

428

(1)

Use Field Comments

428

(1)

APPENDIX B: FileMaker Functions

429

(16)

Aggregate Functions

429

(1)

Date Functions

430

(1)

Design Functions

431

(2)

Financial Functions

433

(1)

Get Functions

433

(3)

Logical Functions

436

(1)

Number Functions

437

(1)

Repeating Functions

438

(1)

Summary Functions

438

(1)

Text Functions

439

(2)

Text Formatting Functions

441

(1)

Time Functions

442

(1)

Timestamp Functions

443

(1)

Trigonometric Functions

443

(2)

APPENDIX C: FileMaker Script Steps

445

(6)

Control Script Steps

446

(1)

Navigation Script Steps

446

(1)

Editing Script Steps

446

(1)

Fields Script Steps

447

(1)

Records

447

(1)

Found Sets

448

(1)

Windows

448

(1)

Files

449

(1)

Accounts

449

(1)

Spelling

449

(1)

Open Menu Items

450

(1)

Miscellaneous

450

(1)

APPENDIX D: Using FileMaker Server

451

(2)

FileMaker Server

451

(1)

FileMaker Server Advanced

452

(1)

Index

453

Please wait while the item is added to your bag...

FREE SHIPPING

Amazon no longer offers textbook rentals. We do!

Sams Teach Yourself FileMaker 7 in 24 Hours

Summary

Table of Contents

Supplemental Materials