Atjaunināt sīkdatņu piekrišanu

Access 2013 Absolute Beginner's Guide [Mīkstie vāki]

1.00/5 (2 ratings by Goodreads)
  • Formāts: Paperback / softback, 416 pages, height x width x depth: 229x179x21 mm, weight: 638 g
  • Izdošanas datums: 25-Apr-2013
  • Izdevniecība: Que Corporation,U.S.
  • ISBN-10: 0789748711
  • ISBN-13: 9780789748713
Citas grāmatas par šo tēmu:
  • Mīkstie vāki
  • Cena: 30,43 €*
  • * Šī grāmata vairs netiek publicēta. Jums tiks paziņota lietotas grāmatas cena
  • Šī grāmata vairs netiek publicēta. Jums tiks paziņota lietotas grāmatas cena.
  • Daudzums:
  • Ielikt grozā
  • Pievienot vēlmju sarakstam
Access 2013 Absolute Beginner's GuidePalielināt
  • Formāts: Paperback / softback, 416 pages, height x width x depth: 229x179x21 mm, weight: 638 g
  • Izdošanas datums: 25-Apr-2013
  • Izdevniecība: Que Corporation,U.S.
  • ISBN-10: 0789748711
  • ISBN-13: 9780789748713
Citas grāmatas par šo tēmu:
Permanent link: https://www.kriso.lv/db/9780789748713.html
Keywords:
Make the most of Access 2013without becoming a technical expert! This book is the fastest way to master Access and use it to build powerful, useful databases of all kindseven web application databases! Even if youve never used Access before, youll learn how to do what you want, one incredibly clear and easy step at a time. Access has never, ever been this simple!

 

Who knew how simple Access® 2013 could be? This is the easiest, most practical beginners guide to using Microsofts incredibly powerful new Access 2013 database program simple, reliable instructions for doing everything you really want to do! Heres a small sample of what youll learn:

 

  Create tables to efficiently store and navigate your data

  Build queries that retrieve exactly the information you want

  Design intuitive forms that help your users work more efficiently

  Build reports that answer key questions intuitively and visually

  Learn easy techniques for designing more reliable databases

  Work faster with AutoForms, AutoReports, and other shortcuts

  Automate repetitive tasks and build more polished databases with macros

  Share Access data with Excel, SQL Server, and other applications

  Solve complex problems with advanced query, form, and reporting techniques

  Build modern web databases that serve users through browsers

  Run your database on the cloud through Microsoft Office 365

  Construct a complete database application from start to finish

  And much more

 

Alison Balter, President of InfoTech Services Group, Inc., has spent 25 years training and consulting on Microsoft Access and related applications with top organizations such as Cisco, Shell, Accenture, Northrop, the U.S. Drug Enforcement Administration, Prudential, Transamerica, Fox Broadcasting, and the U.S. Navy. She travels throughout North America delivering seminars on Access and has authored 14 books and videos for Pearson, including Microsoft Access 2010 LiveLessons and Alison Balters Mastering Access 2007 Development. She is past president of the Independent Computer Consultants Association of Los Angeles.

 

 

Category:    Databases

Covers:    Microsoft® Access® 2013

User Level:    Beginning

 

 
Introduction 1(6)
Who Should Read This Book
1(1)
How This Book Is Organized
1(4)
Requirements, Editions, and Features
2(3)
Using This Book
5(2)
1 Why Use Microsoft Access?
7(18)
What Is a Relational Database?
8(1)
What Types of Things Can I Do with Microsoft Access?
8(3)
Access as a Development Platform for Small-Business Applications
9(1)
Access as a Development Platform for Departmental Applications
9(1)
Access as a Development Platform for Corporation-Wide Applications
10(1)
Access as a Front End for Enterprisewide Client/Server Applications
11(1)
Access as a Tool to Develop Web Applications
11(1)
A Preview of the Database Components
11(14)
Tables: A Repository for Data
11(3)
Relationships: Tying the Tables Together
14(2)
Queries: Stored Questions or Actions You Apply to Data
16(1)
Forms: A Means to Display, Modify, and Add Data
17(1)
Reports: Turning Data into Information
18(2)
Macros: A Means of Automating a System
20(1)
Modules: The Foundation of the Application Development Process
21(4)
2 Getting Started with Microsoft Access
25(10)
Creating a Database from a Template
26(1)
Viewing Database Objects
27(4)
Viewing Database Tables
27(3)
Viewing Queries
30(1)
Viewing Forms
30(1)
Viewing Reports
31(1)
Creating a Database from Scratch
31(1)
Opening an Existing Database
32(1)
Closing a Database
33(1)
Exiting Access
33(2)
3 Tables: The Repository for Your Data
35(16)
Working with Table Data
36(3)
Opening an Access Table
36(1)
Navigating Around a Table
36(2)
Closing a Table
38(1)
Editing Table Data
39(1)
Edit Existing Records
39(1)
Undoing Changes
39(1)
Adding Records to a Table
40(1)
Add Records to a Table
40(1)
Deleting Records
41(6)
Selecting One or More Records
41(1)
Deleting Records
42(2)
Finding and Replacing Records
44(3)
Filtering Table Data
47(4)
Filtering by Selection
47(1)
Removing Filters
48(3)
4 Using Queries to Retrieve the Data You Need
51(18)
What Is a Query and When Should You Use One?
51(1)
Creating a Simple Query
52(4)
Designing the Query
52(1)
Adding Tables to Queries
53(1)
Adding Fields to Queries
53(3)
Ordering the Query Result
56(1)
Sorting on a Single Field
56(1)
Sorting on More Than One Field
57(1)
Working with Simple Criteria
57(9)
Using an Exact Match Query
57(1)
Creating Criteria Based on Multiple Conditions
58(8)
Saving a Query
66(1)
Closing a Query
66(3)
5 Using Forms to Display and Modify Information
69(16)
Moving from Record to Record in a Form
70(1)
Undoing Changes Made Within a Form
71(2)
Using a Form to Delete Records from a Table
73(3)
Copying Records Within a Form
76(1)
Finding a Record That Meets Specific Criteria
77(2)
Sorting Records
79(1)
Sort Records on a Single Field
80(1)
Filtering the Data Underlying a Form
80(3)
Use the Filter by Form Feature
80(1)
Removing a Filter
81(1)
Use Multiple Filter Criteria
81(2)
Closing a Form
83(2)
6 Creating Your Own Forms
85(14)
The AutoForm Feature
86(1)
Create a Form by Using the AutoForm Feature
86(1)
Saving a Form
87(1)
Using the Form Wizard to Build a Form
87(1)
Creating Split Forms
88(2)
Creating Multiple Item Forms
90(1)
Creating Navigation Forms
91(8)
Customizing a Navigation Form
93(2)
Creating a Navigation Form with Horizontal and Vertical Tabs
95(4)
7 Using Reports to Print Information
99(10)
Opening and Viewing a Report
100(3)
Preview a Report
100(1)
Moving from Page to Page
100(1)
Zooming In and Out
101(1)
Viewing Multiple Pages
102(1)
Working in Layout View
103(1)
Working in Report View
103(1)
Printing a Report
104(1)
Use Page Setup
104(1)
Sending Reports to the Printer
105(1)
Closing a Report
105(4)
8 Building Your Own Reports
109(16)
Using the AutoReport Feature
110(3)
Viewing the Design of a Report
113(1)
Types of Reports Available
114(11)
Detail Reports
114(1)
Summary Reports
115(1)
Reports with Graphics
116(1)
Reports with Forms
116(1)
Reports with Labels
117(1)
Creating Mailing Labels
117(8)
9 Creating Your Own Tables
125(26)
Building a New Table
126(3)
Building a Table from a Datasheet
126(2)
Designing a Table from Scratch
128(1)
Selecting the Appropriate Field Type for Data
129(6)
Short Text Fields: The Most Common Field Type
132(1)
Long Text Fields: For Long Notes and Comments
132(1)
Number Fields: For When You Need to Calculate
132(1)
Date/Time Fields: For Tracking When Things Happened
133(1)
Currency Fields: For Storing Money
133(1)
AutoNumber Fields: For Unique Record Identifiers
133(1)
Yes/No Fields: For When One of Two Answers Is Correct
134(1)
OLE Object Fields: For Storing Just About Anything
134(1)
Hyperlink Fields: For Linking to the Internet
134(1)
Attachment Fields: For Storing File Attachments Associated with a Record
134(1)
Calculated Fields: For Storing Your Database Calculations
135(1)
Using Indexes to Improve Performance
135(2)
Create an Index Based on a Single Field
136(1)
Create an Index Based on Multiple Fields
137(1)
The All-Important Primary Key
137(1)
Working with Field Properties
138(6)
The Field Size Property: Limiting What the User Enters into a Field
139(1)
The Format Property: Determining How Access Displays Data
139(2)
The Caption Property: Providing Alternatives to the Field Name
141(1)
The Default Value Property: Saving Data-Entry Time
142(1)
The Validation Rule and Validation Text Properties: Controlling What the User Enters in a Field
142(2)
The Required Property: Making the User Enter a Value
144(1)
The Allow Zero Length Property: Accommodating for Situations with Nonexistent Data
144(1)
The Input Mask Property: Determining What Data Goes into a Field
145(2)
The Lookup Wizard
147(4)
10 Relating the Information in Your Database
151(20)
Introduction to Relational Database Design
152(1)
The History of Relational Database Design
152(7)
Goals of Relational Database Design
152(1)
Rules of Relational Database Design
152(2)
Normalization and Normal Forms
154(4)
Denormalization: Purposely Violating the Rules
158(1)
Integrity Rules
158(1)
The Types of Relationships
159(2)
One-to-Many Relationships
159(1)
One-to-One Relationships
160(1)
Many-to-Many Relationships
161(1)
Establishing Relationships in Access
161(3)
Following Guidelines for Establishing Relationships
162(2)
Modifying an Existing Relationship
164(1)
Establishing Referential Integrity
164(7)
The Cascade Update Related Fields Option
166(1)
The Cascade Delete Related Records Option
167(4)
11 Enhancing the Queries That You Build
171(18)
Everything You Ever Needed to Know About Query Basics
172(1)
Removing a Field from the Query Design Grid
172(1)
Inserting a Field After a Query Is Built
172(1)
Moving a Field to a Different Location on the Query Grid
173(1)
Move More Than One Column
173(1)
Updating Query Results
173(1)
Update Results of a Query
174(1)
Building Queries Based on Multiple Tables
174(10)
Pitfalls of Multitable Queries
176(1)
AutoLookup in Multitable Queries
177(1)
Modifying the Datasheet View of a Query
178(3)
Printing Query Results
181(3)
Refining a Query by Using Criteria
184(5)
Working with Dates in Criteria
185(4)
12 Advanced Query Techniques
189(20)
Creating Calculated Fields
190(1)
Getting Help from the Expression Builder
191(1)
Creating and Running Parameter Queries
192(2)
Creating and Running Action Queries
194(8)
Creating and Running Update Queries
195(2)
Creating and Running Delete Queries
197(1)
Creating and Running Append Queries
198(3)
Creating and Running Make Table Queries
201(1)
Using Aggregate Functions to Summarize Numeric Data
202(1)
Creating Totals Queries
203(3)
Working with Outer Joins
206(3)
Establish an Outer Join
206(3)
13 Building Powerful Forms
209(28)
Power Control Techniques
210(9)
Add Fields to a Form
210(1)
Selecting, Moving, Aligning, and Sizing Form Objects
211(8)
Modifying Object Tab Order
219(1)
Conditional Formatting
219(2)
Conditionally Format Data
220(1)
Form Properties and Why Should You Use Them
221(6)
Working with the Properties Window
221(1)
Working with the Important Form Properties
222(5)
Control Properties and Why to Use Them
227(10)
The Format Properties of a Control
227(3)
The Data Properties of a Control
230(3)
The Other Properties of a Control
233(4)
14 Advanced Form Techniques
237(14)
Working with Combo Boxes
238(3)
List Boxes
241(1)
The Command Button Wizard: Programming Without Typing
241(3)
Building Forms Based on More Than One Table
244(7)
Creating One-to-Many Forms
244(3)
Working with Subforms
247(4)
15 Building Powerful Reports
251(18)
The Anatomy of a Report
252(1)
Control Properties and Why to Use Them
253(7)
The Format Properties of a Control
253(5)
The Data Properties of a Control
258(1)
The Other Properties of a Control
258(2)
Building Reports Based on More Than One Table
260(9)
Creating One-to-Many Reports
260(6)
Working with Subreports
266(3)
16 Advanced Report Techniques
269(12)
Working with Sorting and Grouping
270(4)
Add Sorting and Grouping to a Report
270(1)
Sorting and Grouping Settings
271(2)
Group Header and Footer Properties and Why to Use Them
273(1)
Report Properties and Why to Use Them
274(4)
Working with the Properties Window
275(1)
The Format Properties of a Report
275(1)
The Report's Data Properties
276(1)
Other Properties of a Report
277(1)
Basing Reports on Stored Queries or Embedded SQL Statements
278(3)
17 Automating Your Database with Macros
281(18)
Learning the Basics of Creating and Running a Macro
282(7)
Working with Macro Actions
282(2)
Working with Action Arguments
284(2)
Submacros
286(1)
Program Flow
287(2)
Running an Access Macro
289(3)
Running a Macro from the Macro Design Window
290(1)
Running a Macro from the Macros Group of the Navigation Pane
290(1)
Triggering a Macro from a Form or Report Event
291(1)
Modifying an Existing Macro
292(2)
Inserting New Macro Actions
292(1)
Deleting Macro Actions
292(1)
Moving Macro Actions
293(1)
Copying Macro Actions
293(1)
Creating an Embedded Macro
294(5)
18 Advanced Macro Techniques
299(12)
Creating Data Macros
300(1)
Respond to Events
300(1)
Creating a Drillthrough Macro
301(3)
Other New Features Available in Macros
304(1)
Testing a Macro
305(1)
Determining When You Should Use Macros and When You Shouldn't
306(1)
Converting a Macro to VBA Code
307(1)
Creating an AutoExec Macro
308(3)
19 Sharing Data with Other Applications
311(32)
What Is External Data?
312(1)
Importing, Linking, and Opening Files: When and Why
312(2)
Determining Whether to Import or Link
313(1)
Looking at Supported File Formats
314(1)
Exporting to Another Access Database
314(2)
Exporting to an Excel Spreadsheet
316(2)
Exporting to an Excel Spreadsheet Using the Context-Sensitive Menu
316(1)
Exporting to an Excel Spreadsheet Using Drag and Drop
317(1)
Exporting to an Excel Spreadsheet by Using the External Data Tab on the Ribbon
318(1)
Exporting to ASCII
318(3)
Export Tables and Queries to the ASCII File Format
318(3)
Importing from Another Access Database
321(2)
Import an Access Table
322(1)
Importing Spreadsheet Data
323(3)
Importing ASCII Data
326(3)
Import ASCII Data into Access
326(3)
Linking to Tables in Another Access Database
329(2)
Linking to Another Type of Database
331(7)
Link to Excel Spreadsheets
331(2)
Linking to SQL Server Databases
333(5)
The Linked Table Manager
338(5)
Move and Update Table Links
338(5)
20 Working with Web Databases
343(20)
Working with Web Databases
344(1)
Creating a Blank Web Database
344(2)
Creating a Query
346(3)
Creating and Working with Forms
349(8)
Creating a New Form
350(4)
Customizing an Existing Form
354(3)
Using a Template to Create a Website
357(1)
Viewing Your Website in a Browser
358(5)
21 Putting It All Together
363(20)
Designing the Tables to Store Your Data
364(5)
Building the Forms to Edit Your Data
369(6)
Designing the Clients Form
369(3)
Designing the Projects Form
372(2)
Adding a Command Button That Links the Clients and Projects Forms
374(1)
Building the Queries to Extract the Data You Need
375(2)
Designing the Reports to Display Your Data
377(6)
Designing the tptClientListing Report
377(3)
Building the Macros Necessary to Automate Your Application
380(3)
Index 383
Alison Balter is the president of InfoTech Services Group, Inc., a computer

consulting firm based in Newbury Park, California. Alison is a highly experienced

independent trainer and consultant specializing in Windows applications training

and development. During her 28 years in the computer industry, she has trained

and consulted with many corporations and government agencies. Since Alison

founded InfoTech Services Group, Inc. (formerly Marina Consulting Group) in

1990, its client base has expanded to include major corporations and government

agencies such as Cisco, Shell Oil, Accenture, Northrop, the U.S. Drug Enforcement

Administration, Prudential Insurance, Transamerica Insurance, Fox Broadcasting,

the U.S. Navy, the University of Southern California , Massachusetts Institute of

Technology, and others.

 

Alison is the author of more than 300 internationally marketed computer training

videos and CD-ROMs, including 18 Access 2000 videos, 35 Access 2002 videos, 15

Access 2003 videos, 14 Access 2007 User Videos, and 18 Access 2007 Developer

Videos. Alison travels throughout North America giving training seminars on

Microsoft Access, Microsoft SQL Server, and Visual Basic for Applications.

Alison is also the author of 13 books published by Sams Publishing: Alison





Balters Mastering Access 95 Development, Alison Balters Mastering Access 97

Development, Alison Balters Mastering Access 2000 Development, Alison Balters

Mastering Access 2002 Desktop Development, Alison Balters Mastering Access

2002 Enterprise Development, Alison Balters Mastering Microsoft Access Office

2003, Teach Yourself Microsoft Office Access 2003 in 24 Hours, Access Office 2003





in a Snap, Alison Balters Mastering Access 2007 Development, three e-books on Microsoft Access 2007, and Teach Yourself SQL Express 2005 in









24 Hours. Alison is a co-author of three Access books published by Sams

Publishing: Essential Access 95, Access 95 Unleashed, Access 97 Unleashed, and

Using Microsoft Access 2010.

 

An active participant in many user groups and other organizations, Alison is a past

president of the Independent Computer Consultants Association of Los Angeles

and of the Los Angeles Clipper Users Group. She served as president of the

Ventura County Professional Womens Network for 2 years.

Alisons firm, InfoTech Services Group, Inc., is available for consulting work and

onsite training in Microsoft Access, Visual Studio .NET, and SQL Server, as well as

for Windows Server 2008, Windows Vista, Windows XP, Windows 7, Windows 8,

PC networking, and Microsoft Exchange Server. You can contact Alison by email

at Alison@TechIsMyThing.com, or visit the InfoTech Services Group website

at http://www.TechIsMyThing.com.