Muutke küpsiste eelistusi

FileMaker Pro 13 Absolute Beginner's Guide [Pehme köide]

3.89/5 (16 hinnangut Goodreads-ist)
  • Formaat: Paperback / softback, 384 pages, kõrgus x laius x paksus: 231x181x21 mm, kaal: 606 g
  • Ilmumisaeg: 18-Dec-2014
  • Kirjastus: Que Corporation,U.S.
  • ISBN-10: 0789748843
  • ISBN-13: 9780789748843
Teised raamatud teemal:
  • Pehme köide
  • Hind: 31,59 €*
  • * 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 Pro 13 Absolute Beginner's GuideSuurem pilt
  • Formaat: Paperback / softback, 384 pages, kõrgus x laius x paksus: 231x181x21 mm, kaal: 606 g
  • Ilmumisaeg: 18-Dec-2014
  • Kirjastus: Que Corporation,U.S.
  • ISBN-10: 0789748843
  • ISBN-13: 9780789748843
Teised raamatud teemal:
Püsilink: https://www.kriso.ee/db/9780789748843.html
Märksõnad:

Make the most of FileMaker Pro 13–without becoming a technical expert! This book is the fastest way to create FileMaker Pro databases that perform well, are easy to manage, solve problems, and achieve your goals! Even if you’ve never used FileMaker Pro before, you’ll learn how to do what you want, one incredibly clear and easy step at a time. FileMaker Pro has never, ever been this simple!

Who knew how simple FileMaker® Pro 13 could be?

This is the easiest, most practical beginner’s guide to using the powerful new FileMaker Pro 13 database program…simple, reliable instructions for doing everything you really want to do!


Here’s a small sample of what you’ll learn:

• Get comfortable with the FileMaker Pro environment, and discover all you can do with it

• Create complete databases instantly with Starter Solutions

• Design custom databases that efficiently meet your specific needs

• Identify the right tables, fields, and relationships; create new databases from scratch

• Expand your database to integrate new data and tables

• Craft layouts that make your database easier and more efficient to use

• Quickly find, sort, organize, import, and export data

• Create intuitive, visual reports and graphs for better decision-making

• Use scripts to automate a wide variety of routine tasks

• Safeguard databases with accounts, privileges, and reliable backups

• Share data with colleagues running iPads, iPhones, Windows computers, or Macs

• Take your data with you through FileMaker Go

• Master expert tips and hidden features you’d never find on your own

• And much more…

Introduction 1(1)
About This Book 2(3)
Part 1: Getting to Know FileMaker Pro
1 Welcome to FileMaker Pro
5(12)
What Is a Database?
6(1)
Differences Between Databases and Spreadsheets
7(4)
The Power of Databases
11(1)
Why FileMaker?
12(1)
Understanding the FileMaker Platform
13(1)
What Can FileMaker Do for You?
14(3)
2 Creating Your First Database
17(8)
Getting Started Tour
18(1)
FileMaker Quick Start
19(1)
Creating a Database Using a Starter Solution
20(2)
Saving and Closing a Database
22(1)
Quitting FileMaker
22(3)
3 Exploring FileMaker Pro
25(18)
Opening a FileMaker Pro Database
26(1)
Opening a Recently Used Database
26(1)
Opening Other Databases
26(1)
Menu Commands
27(12)
The File Menu
28(1)
The Edit Menu
29(1)
The View Menu
29(4)
The Insert Menu
33(1)
The Format Menu
33(1)
The Records Menu
34(1)
The Scripts Menu
35(1)
The Window Menu
36(1)
The Help Menu
37(2)
The Status Toolbar
39(4)
Moving Between Records
39(1)
Information About the Found Set
40(1)
The Status Toolbar Buttons
40(1)
QuickFind
41(1)
Additional Tools
41(1)
The Content Area
42(1)
4 Working with Records
43(8)
Changing an Existing Record
44(1)
Adding a New Record
44(1)
Duplicating a Record
44(1)
Canceling Changes to a Record
45(1)
Moving Between Fields
45(1)
Moving Between Records
46(1)
Deleting a Record
46(1)
Deleting Multiple Records
47(1)
Moving Between Layouts
48(1)
Changing Layout Views
49(2)
5 Importing Records
51(10)
Preparing for the Import
52(1)
Selecting the Source File
52(1)
File Types Supported
52(1)
FieldMapping
53(2)
Selecting an Import Action
55(2)
Importing the Sample Data
57(1)
Import Options Dialog Window
57(2)
Import Summary Window
59(2)
6 Finding Records
61(14)
Using Quick Find
62(1)
Entering Find Mode
63(2)
Performing Basic Finds
65(2)
Performing "and" Finds
67(1)
Performing "or" Finds
67(1)
Performing Finds That Omit Records
68(1)
Finds That Return No Records
68(1)
Modifying the Last Find
69(1)
Using Saved Finds
69(2)
Using Fast Match
71(1)
Showing Omitted Records
72(1)
Finding All Records
72(1)
Updating Multiple Records at One Time
72(3)
7 Sorting Records
75(4)
The Sort Records Command
76(1)
The Sort Records Window
76(1)
Impact of the Sort Order
77(2)
8 Exporting Records
79(6)
Preparing to Export
80(1)
Performing the Export
80(1)
Supported File Types
81(1)
Excel Options Window
81(2)
Specify the Field Order for the Export Window
82(1)
Additional Export Options
83(1)
The Export Progress Window
83(2)
Part 2: Beyond the Basics
9 Working with Fields
85(24)
Understanding Field Types
86(2)
Adding Fields
88(1)
Changing the Field Order
89(1)
Field Options
90(10)
Auto-Enter Options
90(5)
Validation Options
95(5)
Naming Fields and Tables
100(1)
Changing Fields
101(1)
Deleting Fields
102(1)
Field Storage Options
103(6)
Global Fields
103(1)
Repeating Fields
104(1)
Indexing Options
105(2)
Indexing Calculated Fields
107(2)
10 Working with Calculations
109(22)
What Are Calculations?
110(1)
Why Calculations Are Important
110(1)
The Specify Calculation Dialog
111(2)
Adding a Calculation Field
113(6)
Types of Calculation Functions
119(10)
Aggregate Functions
121(1)
Container Functions
121(1)
Date Functions
122(1)
Design Functions
123(1)
Financial Functions
123(1)
Get Functions
123(1)
Logical Functions
124(1)
Mobile Functions
125(1)
Number Functions
125(1)
Text Functions
126(1)
Text Formatting Functions
127(1)
Time Functions
128(1)
TimeStamp Function
129(1)
Trigonometric Functions
129(1)
Custom Functions
129(1)
FileMaker Plug-Ins
130(1)
11 Working with Layouts
131(46)
What Are Layouts?
132(1)
Exploring Layout Mode
132(1)
Adding Layouts
133(3)
Understanding Layout Parts
136(2)
Resizing Layout Parts
138(1)
Setting Layout Widths
138(1)
Adding Objects to Layouts
139(4)
Adding Fields
139(4)
Specifying the Tab Order
143(1)
Selecting and Modifying Objects
144(1)
Using the Layout Inspector
145(18)
The Position Tab
147(3)
The Styles Tab
150(2)
The Appearance Tab
152(2)
The Data Tab
154(6)
Understanding Value Lists
160(3)
Adding Basic Objects
163(1)
Adding Graphics
164(1)
Adding Advanced Objects
165(8)
Buttons
165(1)
Tab Controls
166(2)
Slide Controls
168(1)
Popovers
169(2)
Web Viewers
171(2)
Changing Layout Options
173(2)
Managing Layouts
175(1)
Layout Tips and Tricks
175(2)
Undoing Layout Changes
175(1)
Icons on Layout Objects
175(1)
Duplicating Layouts
176(1)
12 Creating Reports and Charts
177(30)
Planning Your Report
178(1)
Understanding Sub-Summary Reports
178(1)
Creating Report Layouts
178(10)
Improving Report Layouts
188(5)
Changing Found Sets
193(1)
Adding Multiple Sub-summary Parts
194(2)
Importance of the Sort Order
196(1)
Removing Body Parts
196(1)
Previewing and Printing Reports
197(3)
Printing Labels and Envelopes
200(2)
Creating Charts
202(5)
13 Automating Tasks with Scripts
207(60)
What Is a Script?
208(1)
The Manage Scripts Window
208(5)
Creating Scripts
213(9)
Script Steps
222(19)
Control Script Steps
223(5)
Navigation Script Steps
228(1)
Editing Script Steps
229(1)
Field Script Steps
230(2)
Record Script Steps
232(1)
Found Set Script Steps
233(1)
Window Script Steps
233(1)
File Script Steps
234(2)
Account Script Steps
236(1)
Spelling Script Steps
236(1)
Open Menu Item Script Steps
236(1)
Miscellaneous Script Steps
237(4)
Interacting with Users
241(8)
Managing Scripts
249(2)
Grouping Scripts into Folders
250(1)
Creating a Default Script
250(1)
Adding a Field Separator
250(1)
Duplicating Scripts
250(1)
Importing Scripts
251(1)
Deleting Scripts
251(1)
Printing Scripts
251(1)
Performing Scripts
251(8)
Subscripts
252(1)
Buttons
252(1)
Script Triggers
253(5)
Install OnTimer Script
258(1)
Script Parameters and Results
259(3)
Handling Script Errors
262(3)
Running Scripts with Full Access
265(2)
Part 3: Caring For and Sharing a Database
14 Protecting a Database
267(24)
The Importance of Security
268(1)
The FileMaker Security Model
268(1)
FileMaker's Default Security Settings
269(1)
The Manage Security Window
270(3)
Creating Privilege Sets
273(7)
Privilege Sets and Scripts
280(1)
Creating Accounts
281(5)
Resetting an Account's Password
286(1)
Securing New Databases
286(1)
Additional Security Features
287(4)
Custom Extended Privileges
287(1)
File Access Control
287(1)
Encryption at Rest
288(1)
FileMaker Server Security Options
288(3)
15 Backing Up a Database
291(10)
The Importance of Backing Up
292(1)
Challenges of Backing Up Databases
292(1)
Performing Backups
293(2)
Backing Up with FileMaker Server
295(1)
Creating Backup Strategies
295(1)
Restoring from Backups
296(1)
Recovering Damaged Databases
297(2)
Performing Consistency Checks
299(2)
16 Sharing a Database
301(12)
Hosting with FileMaker Pro
302(3)
Connecting with FileMaker Pro
305(1)
Closing Hosted Databases
306(2)
Sharing Via ODBC
308(1)
Hosting with FileMaker Server
308(5)
Increased Support for Concurrent Users
308(1)
Support for FileMaker WebDirect
308(2)
Custom Web Publishing
310(1)
ODBC/JDBC Connections
310(3)
17 Taking Data with You
313(12)
The Role of FileMaker Go
314(1)
Designing for FileMaker Go
314(2)
Deployment Options
316(6)
Accessing Hosted Databases
317(5)
Using Local Databases
322(1)
Security Considerations
322(1)
Other Considerations
323(2)
Part 4: Building Your Own Database
18 Planning Your Database
325(6)
Defining Your Goals
326(1)
Identifying Tables
326(1)
Identifying Fields
327(2)
Identifying Relationships
329(2)
19 Creating Your Database
331(8)
Creating Databases from Scratch
332(2)
Adding Fields Using the Field Picker
334(1)
Changing a Table's Name
335(1)
Naming Tables and Fields
336(3)
20 Expanding the Database
339(20)
Adding Additional Tables
340(1)
Understanding the Relationship Graph
341(4)
Setting Up Relationships
345(6)
The Importance of Context
351(2)
Working with Related Records Via Portals
353(3)
Understanding External Data Sources
356(3)
Index 359
Tim Dietrich is an independent database professional who specializes in FileMaker Pro. He designs custom database solutions that help organizations solve problems and achieve goals. He also offers FileMaker training and coaching to groups and individuals, with courses designed for users at all skill levels. His clients range from small businesses to government agencies to Fortune 50 organizations.

 

Tim has been developing with FileMaker Pro since 1992, and he is a FileMaker 9, 10, 11, 12, and 13 Certified Developer. He holds a Bachelor of Science degree from Towson University, where he studied Computer Science with a concentration in Information Systems.

 

Tim lives in Richmond, Virginia, with his wife, Kelly, and their son, Alex. To learn more about the author, visit his website at: http://timdietrich.me.