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

Abi | Registreeri | Logi sisse

Your Office: Microsoft Access 2016 Comprehensive [Spiraalköide]

Brant Moriarity, Amy Kinser, Eric Kinser, Diane Kosharek

Formaat: Spiral bound, 832 pages, kõrgus x laius x paksus: 272x216x30 mm, kaal: 1542 g
Sari: Your Office for Office 2016 Series
Ilmumisaeg: 20-Sep-2016
Kirjastus: Pearson
ISBN-10: 0134479556
ISBN-13: 9780134479552

Teised raamatud teemal:

Access

Spiraalköide
Hind: 189,65 €
Raamatu kohalejõudmiseks kirjastusest kulub orienteeruvalt 3-4 nädalat
Kogus:
- - 1
  - 2
  - 3
  - 4
  - 5
  - 6
  - 7
  - 8
  - 9
  - 10
Lisa ostukorvi
Tasuta tarne
Tellimisaeg 2-4 nädalat
Lisa soovinimekirja

Formaat: Spiral bound, 832 pages, kõrgus x laius x paksus: 272x216x30 mm, kaal: 1542 g
Sari: Your Office for Office 2016 Series
Ilmumisaeg: 20-Sep-2016
Kirjastus: Pearson
ISBN-10: 0134479556
ISBN-13: 9780134479552

Teised raamatud teemal:

Access

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

Märksõnad:

Database management

This book offers full, comprehensive coverage of Access. Ideal for business courses.

Real world problem solving for business and beyond

The Your Office series prepares students to use both technical and soft skills in the real world. Hands-on technical content is woven into realistic business scenarios and focuses on using Microsoft Office^® as a decision-making tool. The series features a unique running business scenario that connects all of the cases together and exposes students to using Office to solve problems relating to business areas like finance and accounting, production and operations, sales and marketing.

Each chapter introduces a realistic business case for students to complete via hands-on steps that are easily identified in blue shaded boxes. Each blue box teaches a skill and comes complete with video and interactive support. Chapters are grouped into Business Units, which collectively illustrate a specific set of business concepts to achieve AACSB-related outcomes. Each Business Unit ends with a Capstone section, testing students' ability to apply concepts and skills beyond a single chapter.

Note: You are purchasing a standalone product; MyITLab does not come packaged with this content. Students, if interested in purchasing this title with MyITLab, ask your instructor for the correct package ISBN and Course ID. Instructors, contact your Pearson representative for more information.

Welcome to the Team Letter

(2)

COMMON FEATURES

Chapter 1 Understanding the Common Features of Microsoft Office

(50)

Prepare Case: Painted Paradise Resort & Spa Employee Training Preparation

(1)

Working with the Office Interface

(17)

Microsoft Office Suite and Different Versions

(1)

Start, Save, and Navigate Office Applications

(1)

Opening Microsoft Word and the Start Screen

(2)

Using the Ribbon and Ribbon Display Options

(3)

Using Office Backstage, Your Account, and Document Properties

(2)

Saving a New Document to the Local OneDrive That Syncs to the Cloud

(4)

Closing a File, Reopening from the Recent Documents List, and Exiting an Application

(1)

Opening an Existing File in Microsoft Word and Then Saving as Another Name

(2)

Zooming, Scrolling, and Navigating with Keyboard Shortcuts

(2)

Using the Quick Access Toolbar to Save a Currently Open File

(1)

Manipulate, Correct, and Format Content in Word

(11)

Checking Spelling

(1)

Showing Formatting Symbols, Entering, Copying, and Pasting Text

(2)

Using Undo and Redo

(1)

Using the Navigation Pane, Finding Text, and Replacing Text

(1)

Using the Font Group and the Font Dialog Box

(2)

Using the Style Gallery and Bullets with Live Preview

(1)

Inserting a Comment and Footer Using the Tell me what you want to do Box

(3)

Formatting, Finding Help, and Printing in Office

(14)

Format Using Various Office Methods

(1)

Creating a New Excel Workbook

(1)

Using Excel to Enter Content, Apply Italics, and Apply a Fill Color

(1)

Opening an Excel Dialog Box

(1)

Inserting Images and Using Contextual Tools to Resize

(2)

Formatting Using the Mini Toolbar

(1)

Opening Shortcut Menus and Format Painter

(1)

Find Help, Print, and Share in Office

(1)

Using the Help Window and ScreenTips

(1)

Accessing the Share Pane

(1)

Changing Views

(1)

Printing a File

(1)

Exporting a PDF

(1)

Insert Office Add-ins

(1)

Concept Check

(1)

Key Terms

(1)

Visual Summary

(1)

Practice

(1)

Practice Case 1

(1)

Problem Solve

(1)

Problem Solve Case 1

(1)

Perform

(3)

Perform in Your Career

(1)

Perform in Your Life

(2)

ACCESS BUSINESS UNIT 1

(114)

Chapter 1 The Four Main Database Objects

(44)

Prepare Case: Red Bluff Golf Course Putts for Paws Charity Tournament

(1)

Understanding the Basics of Databases and Tables

(17)

Understand the Purpose of Access

(1)

Understanding the Four Main Objects in a Database

(2)

Creating a New Database and Templates

(1)

Opening the Starting File

(1)

Maneuver in the Navigation Pane

(1)

Opening and Closing the Shutter Bar

(1)

Customize the Navigation Pane

(1)

Using the Search Box

(1)

Understanding File Extensions in Access

(1)

Understand the Purpose of Tables

(1)

Importing a Table

(2)

Navigating Through a Table

(1)

Navigating Through a Table with the Navigation Bar

(3)

Understanding Differences Between Access and Excel

(1)

Manually Navigate a Database

(1)

Using a Manual Query to Explore a Database

(2)

Understanding Queries, Forms, and Reports

(19)

Understand the Purpose of Queries

(1)

Using the Query Wizard

(3)

Switching to the Design View of a Query

(1)

Specifying Selection Criteria

(2)

Sorting Query Results

(1)

Printing Query Results

(1)

Understand the Purpose of Forms

(1)

Creating a Form

(1)

Entering Data Using a Form

(2)

Understand the Purpose of Reports

(1)

Creating a Report Using a Wizard

(2)

Printing a Report

(1)

Back Up a Database

(1)

Backing Up a Database

(1)

Compact and Repair a Database

(1)

Compacting Your Database

(2)

Concept Check

(1)

Key Terms

(1)

Visual Summary

(2)

Practice

(1)

Practice Case 1

(1)

Problem Solve

(1)

Problem Solve Case 1

(1)

Perform

(2)

Perform in Your Career

(2)

Chapter 2 Tables, Keys, and Relationships

(69)

Prepare Case: Red Bluff Golf Course Putts for Paws Charity Tournament Database

(1)

Inserting Data into a Database

(13)

Understand Database Design

(1)

Opening the Starting File

100

(1)

Viewing the Design View of a Table

101

(1)

Import Data from Other Sources

102

(1)

Copying and Pasting Data from Excel

102

(2)

Importing a Worksheet

104

(2)

Importing from a Named Range

106

(1)

Importing from a Text File

107

(1)

Enter Data Manually

108

(1)

Entering Data Using Datasheet View

108

(2)

Deleting Data from a Table

110

(1)

Deleting a Field from a Table

111

(1)

Understanding Tables and Keys

112

(12)

Create a Table in Design View

112

(1)

Defining Data Types

113

(1)

Determining Field Size

114

(1)

Creating a Table in Design View

114

(2)

Changing a Data Type

116

(1)

Understand Masks and Formatting

116

(1)

Defining Input Masks

116

(2)

Formatting a Field

118

(2)

Understand and Designate Keys

120

(1)

Understanding Primary Keys

120

(1)

Understanding Foreign Keys

121

(1)

Identifying a Composite Key

121

(2)

Defining a Primary Key

123

(1)

Understanding Relational Databases

124

(13)

Understand Basic Principles of Normalization

125

(1)

Representing Entities and Attributes

125

(1)

Minimizing Redundancy

126

(1)

Understand Relationships Between Tables

127

(1)

Viewing the Relationships Window

127

(1)

Determining Relationship Types

128

(1)

Create a One-to-Many Relationship

129

(1)

Forming a Relationship

129

(3)

Create a Many-to-Many Relationship

132

(1)

Forming a New Many-to-Many Relationship

133

(1)

Creating a Junction Table

134

(1)

Forming Two Relationships to a Junction Table

135

(1)

Populating the Junction Table

136

(1)

Defining One-to-One Relationships

137

(1)

Understand Referential Integrity

137

(5)

Selecting Cascade Update

137

(1)

Selecting Cascade Delete

138

(1)

Testing Referential Integrity

138

(2)

Creating a Report Using Two Related Tables

140

(2)

Concept Check

142

(1)

Key Terms

142

(1)

Visual Summary

143

(2)

Practice

145

(3)

Practice Case 1

145

(3)

Problem Solve

148

(2)

Problem Solve Case 1

148

(2)

Perform

150

(1)

Perform in Your Career

150

(1)

Access Business Unit 1 Capstone

151

(1)

More Practice

151

(2)

More Practice Case 1

151

(2)

Problem Solve

153

(6)

Problem Solve Case 1

153

(3)

Problem Solve Case 2

156

(3)

Perform

159

(8)

Perform in Your Life

159

(1)

Perform in Your Career

160

(1)

Perform in Your Team

161

(2)

How Others Perform

163

(4)

ACCESS BUSINESS UNIT 2

167

(110)

Chapter 3 Queries and Data Access

168

(50)

Prepare Case: Turquoise Oasis Spa Data Management

168

(1)

Working with Datasheets

169

(6)

Find and Replace Records in the Datasheet

169

(1)

Opening the Starting File

169

(1)

Finding Records in a Table

169

(1)

Finding and Replacing Records in a Datasheet

170

(1)

Using a Wildcard Character

171

(1)

Applying a Filter to a Datasheet

172

(1)

Using a Text Filter

173

(1)

Modify Datasheet Appearance

174

(1)

Changing the Look of a Datasheet

174

(1)

Querying the Database

175

(36)

Run Query Wizards

175

(1)

Creating a Find Duplicates Query

176

(1)

Creating a Find Unmatched Query

177

(1)

Create Queries in Design View

178

(1)

Creating a Single-Table Query

179

(2)

Viewing Table Relationships

181

(1)

Creating a Query from Multiple Tables

182

(2)

Removing a Table from a Query to Fix an Undesirable Multiplier Effect

184

(1)

Sort Tables and Query Results

185

(1)

Sorting by One Field

185

(1)

Sorting by More Than One Field

186

(1)

Define Selection Criteria for Queries

187

(1)

Using a Comparison Operator

187

(1)

Hiding Fields That Are Used in a Query

188

(1)

Sorting on a Field That You Do Not Show

189

(1)

Using Is Null Criteria

190

(1)

Using Criteria Row with Multiple Criteria

191

(1)

Using the Or Criteria Row

192

(1)

Using Both the Criteria Row and the Or Criteria Rows in a Query

193

(2)

Using AND and OR Logical Operators

195

(2)

Combining Operators and Multiple Criteria

197

(2)

Using Special Operators and Date Criteria

199

(2)

Combining Special Operators and Logical Operators

201

(1)

Create Aggregate Functions

202

(1)

Adding a Total Row

202

(2)

Using Aggregate Functions in a Query

204

(1)

Changing Field Names

205

(1)

Creating Calculations for Groups of Records

206

(1)

Troubleshooting an Aggregate Query

207

(1)

Formatting a Calculated Field

208

(1)

Create Calculated Fields

209

(1)

Building a Calculated Field Using Expression Builder

209

(2)

Concept Check

211

(1)

Key Terms

211

(1)

Visual Summary

211

(2)

Practice

213

(2)

Practice Case 1

213

(2)

Problem Solve

215

(1)

Problem Solve Case 1

215

(1)

Perform

216

(2)

Perform in Your Career

216

(2)

Chapter 4 Using Forms and Reports in Access

218

(59)

Prepare Case: Turquoise Oasis Spa's New Database

218

(1)

Creating Customized Forms

219

(21)

Navigate and Edit Records in Datasheets

219

(1)

Opening the Starting File

219

(2)

Editing a Table in Datasheet View 220 Navigate Forms and Subforms

221

(1)

Navigating a Main Form

222

(1)

Navigating a Form with a Subform

223

(1)

Navigating a Split Form

224

(1)

Using the Find Command in a Form

225

(1)

Update Table Records Using Forms

226

(1)

Adding Records

227

(1)

Editing Records

228

(1)

Deleting Records

228

(1)

Create a Form Using the Form Wizard

229

(1)

Creating a Form

230

(2)

Creating Subforms (Multiple-Table Forms)

232

(2)

Creating a Split Form

234

(1)

Modify a Form's Design

235

(1)

Changing the Form Theme

235

(1)

Resizing and Changing Controls

236

(2)

Adding a Picture to the Form

238

(1)

Printing a Record from a Form

239

(1)

Creating Customized Reports

240

(16)

Create a Report Using the Report Wizard

240

(1)

Creating a Single-Table Report

241

(1)

Creating a Multiple-Table Report

242

(2)

Exploring Report Views

244

(2)

Creating Totals Using the Report Wizard

246

(2)

Customize a Report

248

(1)

Moving, Resizing, and Formatting Report Controls

248

(2)

Enhancing a Report with Conditional Formatting

250

(2)

Applying Grouping and Sorting

252

(1)

Adding Subtotals

253

(2)

Save a Report as a PDF File

255

(1)

Creating a PDF File

255

(1)

Concept Check

256

(1)

Key Terms

256

(1)

Visual Summary

256

(2)

Practice

258

(2)

Practice Case 1

258

(2)

Problem Solve

260

(2)

Problem Solve Case 1

260

(2)

Perform

262

(2)

Perform in Your Career

262

(2)

Access Business Unit 2 Capstone

264

(1)

More Practice

264

(3)

More Practice Case 1

264

(3)

Problem Solve

267

(4)

Problem Solve Case 1

267

(2)

Problem Solve Case 2

269

(2)

Perform

271

(6)

Perform in Your Life

271

(1)

Perform in Your Career

272

(2)

Perform in Your Team

274

(2)

How Others Perform

276

(1)

ACCESS BUSINESS UNIT 3

277

(108)

Chapter 5 Advanced Tables

278

(57)

Prepare Case: The Red Bluff Golf Club & Pro Shop: Modifying Database Tables

278

(1)

Controlling the Way Data Is Entered: Advanced Field Options

279

(25)

Understand the Purpose and Benefits of Input Masks

279

(1)

Opening the Starting File

279

(1)

Using the Input Mask Wizard

280

(2)

Creating a Custom Input Mask

282

(5)

Apply Custom Formatting

287

(1)

Creating Custom Formatting

287

(6)

Define Data Validation Rules

293

(1)

Creating Validation Rules and Validation Text

294

(2)

Define Caption Names

296

(1)

Creating Captions for Existing Fields

296

(2)

Create Indexes to Increase Performance

298

(1)

Defining a Single-Field Index

299

(1)

Defining Multiple-Field Indexes

300

(1)

Require Data in Fields

301

(1)

Making Fields Required

302

(1)

Define Default Values

302

(1)

Setting a Default Value

303

(1)

Advanced Data Types

304

(17)

Create Lookup Fields

304

(2)

Creating Lookup Fields and Modifying Lookup Properties

306

(6)

Configure Fields Using the Calculated, Yes/No, AutoNumber, Attachments, Hyperlinks, and OLE Objects Data Types

312

(1)

Configuring Fields Using the Calculated Data Type

312

(2)

Configuring Fields Using the Yes/No Data Type

314

(2)

Configuring Fields Using the AutoNumber Data Type

316

(2)

Configuring Fields Using the Attachments, Hyperlinks, and OLE Objects Data Types

318

(3)

Filtering Data

321

(3)

Create Filters to View Specific Records

321

(1)

Creating Filters

321

(3)

Reducing Redundancy

324

(3)

Use the Table Analyzer Wizard

325

(1)

Using the Table Analyzer Wizard

325

(2)

Concept Check

327

(1)

Key Terms

327

(1)

Visual Summary

328

(1)

Practice

329

(2)

Practice Case 1

329

(2)

Problem Solve

331

(2)

Problem Solve Case 1

331

(2)

Perform

333

(2)

How Others Perform

333

(2)

Chapter 6 Pattern Matching and Functions in Queries

335

(50)

Prepare Case: The Red Bluff Golf Club Database

335

(1)

Working with Advanced Criteria and Calculations

336

(15)

Use Wildcard Characters in String Comparisons

336

(1)

Opening the Starting File

336

(1)

Working with Wildcard Characters and the Like Operator

337

(4)

Find Records with the "Most" or "Least" Values

341

(1)

Retrieving Top Values

341

(2)

Create Parameter Queries

343

(1)

Use Parameters in a Query

343

(3)

Concatenate Strings Using the & Operator

346

(2)

Use Advanced Query Operators

348

(3)

Using Advanced Functions in Queries

351

(15)

Create Ilf Function

351

(1)

Creating Basic Ilf Function for Individual Conditions

351

(2)

Creating Nested Ilf Functions for Various Conditions

353

(1)

Use the IsNull Function

354

(1)

Working with Fields That Contain No Valid Data

354

(2)

Use Date Functions

356

(1)

Using the DateDiff Function to Determine a Time Interval

357

(1)

Using DateAdd Function to Subtract a Time Interval

358

(3)

Using the DateSerial Function to Return a Date (Year, Month, and Day)

361

(1)

Using DatePart to Evaluate a Date

362

(2)

Use the Round Function

364

(1)

Rounding to a Specific Number of Decimal Places

364

(2)

Concept Check

366

(1)

Key Terms

366

(1)

Visual Summary

367

(1)

Practice

368

(2)

Practice Case 1

368

(2)

Problem Solve

370

(1)

Problem Solve Case 1

370

(1)

Perform

371

(2)

Perform in Your Life

371

(2)

Access Business Unit 3 Capstone

373

(1)

More Practice

373

(3)

More Practice Case 1

373

(3)

Problem Solve

376

(4)

Problem Solve Case 1

376

(2)

Problem Solve Case 2

378

(2)

Perform

380

(5)

Perform in Your Life

380

(1)

Perform in Your Career

381

(1)

Perform in Your Team

381

(2)

How Others Perform

383

(2)

ACCESS BUSINESS UNIT 4

385

(108)

Chapter 7 Aggregated Calculations, Subquerying, and SQL

386

(61)

Prepare Case: The Turquoise Oasis Spa Database: Querying with Advanced Calculations

386

(1)

Understanding the Group By Clause in Aggregated Calculations

387

(5)

Opening the Spa Decisions Database

387

(1)

Use the GROUP BY Clause in Aggregated Calculations

387

(1)

Calculating Revenue and Sales Volume

388

(2)

Calculating the Number of Transactions by Category

390

(1)

Summarizing Duplicate Data Using the GROUP BY Clause

391

(1)

Understanding the Where Clause in Aggregated Calculations

392

(5)

Use the WHERE Clause in Aggregated Calculations

393

(1)

Calculating Revenue from Specific Spa Services

393

(1)

Calculating Net Revenue from Specific Spa Services

394

(3)

Business Calculations Using Subquerying

397

(14)

Create Subqueries Using Business Calculations

398

(1)

Creating a Query on a Query

398

(2)

Calculating the Percentage of Sales Revenue

400

(4)

Calculating the Percentage of Sales Volume

404

(3)

Calculating Physical Volume

407

(2)

Calculating the Percentage of Physical Volume

409

(2)

Understanding Structured Query Language

411

(29)

Create Basic Structured Query Language (SQL) Queries

412

(1)

Viewing SQL Statements in Access

412

(1)

Understanding SELECT Statement Basics

413

(1)

Creating a Basic Query with SQL

413

(1)

Using the WHERE Clause

414

(4)

Using the ORDER BY Clause

418

(2)

Using the HAVING Clause with AS and GROUP BY

420

(2)

Incorporate Joins into Structured Query Language (SQL) Queries

422

(1)

Creating Queries Using the INNER JOIN Clause

422

(3)

Creating Queries Using OUTER JOINS

425

(6)

Creating a Union Query

431

(2)

Creating a SQL Subquery

433

(1)

Create a Two-Dimensional Query Using the Crosstab Query Wizard

434

(1)

Using the Crosstab Query Wizard

434

(3)

Editing a Crosstab Query

437

(3)

Concept Check

440

(1)

Key Terms

440

(1)

Visual Summary

441

(1)

Practice

442

(2)

Practice Case 1

442

(2)

Problem Solve

444

(1)

Problem Solve Case 1

444

(1)

Perform

445

(2)

Perform in Your Life

445

(2)

Chapter 8 Action Queries and Advanced Relationships

447

(46)

Prepare Case: The Turquoise Oasis Spa: Understanding Action Queries

447

(1)

Understanding Action Queries

448

(16)

Create a New Table Using a Make Table Query

448

(1)

Opening the Starting Files

449

(1)

Creating a Make Table Query

449

(1)

Running a Make Table Query

450

(2)

Append Data to a Table

452

(1)

Creating an Append Query

452

(1)

Running an Append Query

453

(1)

Edit and Delete Data

454

(1)

Working with Update Queries

455

(2)

Creating Complex Update Queries

457

(3)

Create, Test, and Run Delete Queries

460

(1)

Creating Simple Delete Queries

460

(2)

Building Complex Delete Queries

462

(2)

Advanced Relationships Using Multiple Tables

464

(10)

Inner Joins

465

(1)

Creating an Inner Join Query

465

(1)

Outer Joins

466

(1)

Creating an Outer Join Query

466

(3)

Use the Find Unmatched Query Wizard

469

(1)

Creating a Find Unmatched Data Query

469

(5)

Concept Check

474

(1)

Key Terms

474

(1)

Visual Summary

474

(2)

Practice

476

(2)

Practice Case 1

476

(2)

Problem Solve

478

(2)

Problem Solve Case 1

478

(2)

Perform

480

(1)

Perform in Your Life

480

(1)

Access Business Unit 4 Capstone

481

(1)

More Practice

481

(3)

More Practice Case 1

481

(3)

Problem Solve

484

(4)

Problem Solve Case 1

484

(2)

Problem Solve Case 2

486

(2)

Perform

488

(5)

Perform in Your Life

488

(1)

Perform in Your Career

489

(1)

Perform in Your Team

489

(2)

How Others Perform

491

(2)

ACCESS BUSINESS UNIT 5

493

(255)

Chapter 9 Advanced Form Settings and Form Types

494

(44)

Prepare Case: Enhancing Data Entry at the Red Bluff Golf Course & Pro Shop

494

(1)

Working with Form Properties

495

(9)

Define Bound and Unbound Forms

495

(1)

Opening the Starting File

495

(1)

Creating a Bound Form

496

(1)

Making Changes in Layout View

496

(1)

Modify the Form Property Sheet

497

(2)

Changing Default Values for a Field

499

(1)

Using Dates and Calculations as the Default Value

500

(2)

Changing the Background Color of the Form and Properties for Unbound Controls

502

(1)

Displaying the Date Picker

503

(1)

Preventing Fields from Being Updated

504

(1)

Using Advanced Form Modification

504

(25)

Modify the Form Header

504

(1)

Editing the Form Header

505

(1)

Adding the Date and Time and Changing the Background Color

506

(1)

Modify the Form in Design View

506

(1)

Inserting a Form Footer

506

(2)

Adding and Stacking Fields

508

(1)

Changing Tab Order

509

(1)

Adding a COUNT Calculated Field

510

(1)

Adding a SUM Calculated Field

511

(1)

Adding Fields from a Subform to the Main Form

512

(2)

Adding a Combo Box to Find a Record

514

(1)

Anchoring Controls

515

(1)

Adding Shapes to a Form

515

(1)

Adding Navigation Buttons

516

(2)

Adding Form Operations Buttons

518

(1)

Aligning Controls

519

(1)

Turning Off the Navigation Bar

520

(1)

Creating Advanced Forms

521

(1)

Create Specialized Forms

521

(1)

Creating a Multiple-Item Form

522

(1)

Create a Multipage Form Using Tab Controls

522

(1)

Modifying an Existing Form to Add a Tab Control

523

(1)

Inserting a Tab Page and Changing Tab Captions

524

(1)

Inserting Existing Fields in a Tab Page

525

(2)

Rearranging, Moving, and Resizing the Tab Control

527

(2)

Concept Check

529

(1)

Key Terms

529

(1)

Visual Summary

529

(2)

Practice

531

(3)

Practice Case 1

531

(3)

Problem Solve

534

(2)

Problem Solve Case 1

534

(2)

Perform

536

(2)

Perform in Your Career

536

(2)

Chapter 10 Advanced Reports and Mailing Labels

538

(52)

Prepare Case: Enhancing Database Reports at the Red Bluff Golf Club

538

(1)

Creating Customized Reports

539

(16)

Use the Summary Options in Report Wizard

540

(1)

Opening the Starting File

540

(1)

Adding Subtotals and Totals

540

(2)

Modify the Report in Design View

542

(1)

Selecting and Modifying Controls in Design View

543

(2)

Moving, Resizing, and Aligning Fields in Design View

545

(1)

Change Report Properties

546

(1)

Modifying the Hide Duplicates Property

546

(1)

Add and Remove Fields from a Report

547

(1)

Removing Fields from a Report

547

(1)

Adding Fields to a Report

547

(2)

Use the Group, Sort, and Total Pane

549

(1)

Opening the Group, Sort, and Total Pane

549

(2)

Hiding Details on a Summary Report

551

(1)

Add Labels and Shapes to a Report

552

(1)

Adding Labels to a Report

552

(1)

Adding a Horizontal Line to a Report

553

(1)

Modify Calculated Fields in a Report

554

(1)

Modifying Existing Calculated Fields

554

(1)

Creating Parameter Reports

555

(8)

Create a Parameter Report

555

(1)

Creating a Report from a Parameter Query

555

(1)

Creating a Form for Entering Parameters

556

(2)

Modifying a Query to Use New Form Fields

558

(1)

Modifying a Report to Use New Form Fields

559

(1)

Adding Report Buttons to a Form

560

(2)

Use Conditional Formatting in a Report

562

(1)

Adding Conditional Formatting to a Report

562

(1)

Creating Mailing Labels

563

(5)

Create Mailing Labels

563

(1)

Creating Address Mailing Labels

563

(3)

Adding Mailing Label Buttons to a Form

566

(2)

Concept Check

568

(1)

Key Terms

568

(1)

Visual Summary

569

(1)

Practice

570

(4)

Practice Case 1

570

(4)

Problem Solve

574

(1)

Problem Solve Case 1

574

(1)

Perform

575

(2)

Perform in Your Career

575

(2)

Access Business Unit 5 Capstone

577

(1)

More Practice

577

(3)

More Practice Case 1

577

(3)

Problem Solve

580

(3)

Problem Solve Case 1

580

(2)

Problem Solve Case 2

582

(1)

Perform

583

(6)

Perform in Your Life

583

(1)

Perform in Your Career

584

(1)

Perform in Your Team

585

(2)

How Others Perform

587

(2)

Access Business Unit 6

589

(1)

Chapter 11 Develop Navigation Forms and the User Interface

590

(29)

Prepare Case: The Turquoise Oasis Spa Database: Creating a User Interface

590

(1)

Creating Navigation Forms

591

(7)

View a Navigation Form

591

(1)

Opening the Starting File

591

(1)

Opening and Using Navigation Forms

592

(1)

Create a Navigation Form

593

(1)

Using a Predefined Layout to Create a Navigation Form

594

(1)

Modify a Navigation Form

595

(1)

Adding Objects to a Navigation Form

595

(1)

Deleting an Object from a Navigation Form

595

(1)

Moving an Object on a Navigation Form

596

(1)

Modifying the Appearance of Buttons on a Navigation Form

597

(1)

Refining the User Interface

598

(14)

Create a Main Menu

600

(1)

Creating a Main Menu Navigation Form

601

(1)

Adding an Image to the Main Menu

602

(1)

Add Command Buttons to the Navigation Form

603

(1)

Creating Command Buttons on a Form for Navigation

604

(3)

Removing Navigation Arrows and Record Selectors on a Form

607

(1)

Set Start-Up Display Options and Test the Application

608

(1)

Making Changes to the Start-Up Options

608

(3)

Viewing the User Interface as a User

611

(1)

Concept Check

612

(1)

Key Terms

612

(1)

Visual Summary

612

(1)

Practice

613

(3)

Practice Case 1

613

(3)

Problem Solve

616

(1)

Problem Solve Case 1

616

(1)

Perform

617

(2)

Perform in Your Life

617

(2)

Chapter 12 Create a Refined User Experience with Macros

619

(51)

Prepare Case: The Turquoise Oasis Spa Database: Automating Tasks and Increasing Functionality

619

(1)

Understanding the Purpose of Macros

620

(10)

Modify Database Settings for Protection from Macro Viruses

620

(1)

Open the Starting File

620

(1)

Creating a Trusted Location

621

(2)

Understand the Macro Designer

623

(1)

Open and View the Macro Designer

623

(2)

Editing a Macro

625

(1)

Printing a Macro

626

(1)

Understand How to Test and Troubleshoot Macros

627

(1)

Single Stepping Through a Macro

627

(3)

Increase Efficiency and Usability of a Database by Automating Tasks

630

(12)

Improve Database Design and Function by Automating Manual Processes

630

(1)

Exporting Database Objects Using Macros

631

(2)

Reduce Processing Time by Combining Routine Tasks

633

(1)

Automating an Import and Update Process

633

(4)

Create Macro Groups

637

(1)

Creating a Macro Group

637

(2)

Creating a Key-Assignment Macro

639

(1)

Create Macros That Run When the Database Opens

640

(1)

Creating an AutoExec Macro

641

(1)

The Benefits of Embedded Macros

642

(10)

Improve the Functionality of Forms and Reports

644

(1)

Embedding a Macro to Improve User Experience

644

(2)

Embedding a Macro to Increase Functionality

646

(3)

Implement Complex Business Rules with Data Macros

649

(1)

Creating a Data Macro

650

(2)

Concept Check

652

(1)

Key Terms

652

(1)

Visual Summary

653

(1)

Practice

654

(1)

Practice Case 1

654

(1)

Problem Solve

655

(2)

Problem Solve Case 1

655

(2)

Perform

657

(1)

Perform in Your Career

657

(1)

Access Business Unit 6 Capstone

658

(1)

More Practice

658

(3)

More Practice Case 1

658

(3)

Problem Solve

661

(2)

Problem Solve Case 1

661

(1)

Problem Solve Case 2

662

(1)

Perform

663

(6)

Perform in Your Life

663

(1)

Perform in Your Career

664

(1)

Perform in Your Team

665

(1)

How Others Perform

666

(3)

Access Business Unit 7

669

(1)

Chapter 13 Use VBA in Access

670

(40)

Prepare Case: The Red Bluff Golf Course & Pro Shop Putts for Paws Charity Database

670

(1)

Introducing VBA Basics

671

(18)

Understand the Functionality of VBA in Access

671

(1)

Convert an Existing Macro to VBA

671

(1)

Opening the Starting File

672

(1)

Converting an Existing Macro to VBA

672

(1)

Opening the Converted Macro in the Visual Basic Editor

673

(2)

Edit and Structure VBA Procedures

675

(1)

Examining the DoCmd Object and Breaking a Statement

676

(1)

Using the TransferSpreadsheet Method

676

(2)

Understanding the FileDialog Object

678

(2)

Adding the FileDialog Object to the Procedure

680

(1)

Using the With Statement

681

(1)

Using If Statements in VBA

682

(2)

Create and Use Loops in VBA

684

(1)

Creating For Loops

685

(2)

Using a Call Statement to Run a Procedure

687

(1)

Testing a Procedure

688

(1)

Adding VBA to an Access Database

689

(8)

Create VBA Procedures

689

(1)

Adding a Command Button to a Form

689

(2)

Using the Me Keyword in a Procedure

691

(1)

Use Comments to Document VBA Procedures

692

(1)

Using the Edit Toolbar

692

(1)

Adding Comments to a Procedure

693

(1)

Debug the VBA in a Database and Add Error Handling

694

(1)

Adding Error Handling to a Procedure

695

(2)

Compiling and Securing Your VBA

697

(6)

Compile VBA Modules

697

(1)

Compiling VBA Modules to Identify VBA Errors

697

(2)

Secure VBA in a Database

699

(1)

Creating a .accde File

699

(1)

Testing the .accde Database

700

(1)

Protecting VBA in a Database with a Password

701

(2)

Concept Check

703

(1)

Key Terms

703

(1)

Visual Summary

704

(1)

Practice

705

(2)

Practice Case 1

705

(2)

Problem Solve

707

(1)

Problem Solve Case 1

707

(1)

Perform

708

(2)

Perform in Your Career

708

(2)

Chapter 14 Implement Your Database

710

(38)

Prepare Case: The Red Bluff Golf Course & Pro Shop Putts for Paws Charity Database

710

(1)

Implementing a Database

711

(14)

Understand Shared and Exclusive Modes to Access a Database

711

(1)

Opening the Starting File

711

(1)

Opening a Database with Exclusive Access

712

(1)

Prepare a Database for a Single User

712

(1)

Using the Performance Analyzer

712

(2)

Making Changes to a Database to Improve Performance

714

(1)

Making Changes to a Database with the Performance Analyzer

715

(2)

Understand Compatibility Between Different Versions of Access

717

(1)

Saving an Access Database as a Previous Version

717

(1)

Prepare a Database for Multiple Users

718

(1)

Linking Tables

718

(2)

Adding and Viewing Data in a Linked Table

720

(1)

Using the Database Splitter

721

(2)

Using the Linked Table Manager

723

(1)

Encrypt a Database with Passwords

724

(1)

Encrypting and Setting a Database Password

724

(1)

Setting the User's Experience

725

(7)

Modify the Start-up Options in a Database

726

(1)

Using Special Keys

726

(1)

Setting Start-up Preferences

726

(3)

Testing the Start-up Settings

729

(1)

Describe Different Strategies for Implementation

730

(2)

Concept Check

732

(1)

Key Terms

732

(1)

Visual Summary

733

(1)

Practice

734

(2)

Practice Case 1

734

(2)

Problem Solve

736

(1)

Problem Solve Case 1

736

(1)

Perform

737

(1)

Perform in Your Life

737

(1)

Access Business Unit 7 Capstone

738

(1)

More Practice

738

(3)

More Practice Case 1

738

(3)

Problem Solve

741

(2)

Problem Solve Case 1

741

(1)

Problem Solve Case 2

742

(1)

Perform

743

(5)

Perform in Your Career

743

(1)

Perform in Your Life

744

(1)

Perform in Your Team

745

(1)

How Others Perform

746

(2)

APPENDIX

748

(28)

GLOSSARY

776

(9)

INDEX

785

Amy S. Kinser, Esq., Series Editor

Amy holds a B.A. degree in Chemistry with a Business minor from Indiana University, and a J.D. from the Maurer School of Law, also at Indiana University. After working as an environmental chemist, starting her own technology consulting company, and practicing intellectual property law, she has spent the past 15 years teaching technology at the Kelley School of Business in Bloomington, Indiana. Currently, she serves as the Director of Computer Skills and Senior Lecturer at the Kelley School of Business at Indiana University. She also loves spending time with her two sons, Aidan and J. Matthew, and her husband J. Eric.

Kristyn A. Jacobson

Kristyn holds an M.S. in Education from the University of Wisconsin-La Crosse and a B.S. in Business Education from the University of Wisconsin-Eau Claire. She has been a faculty member and department chair of the Business Technology department at Madison College in Madison, Wisconsin for over 14 years. She also serves as the curriculum coordinator for Microsoft Excel beginning, intermediate, and advanced level courses for the college. As well as teaching, Kristyn provides training to businesses on the Microsoft Office Suite including MS Project, project management, customer service, personal productivity, and time management. Prior to teaching at Madison College, she taught at a business college in Des Moines, Iowa where she helped implement their online learning program while also teaching traditional business courses.

J. Eric Kinser

Eric Kinser received his B.S. degree in Biology from Indiana University and his M.S. in Counseling and Education from the Indiana School of Education. He has worked in the medical field and in higher education as a technology and decision support specialist. He is currently a senior lecturer in the Operations and Decision Technology Department at the Kelley School of Business at Indiana University. When not teaching he enjoys experimenting with new technologies, traveling, and hiking with his family.

Diane L. Kosharek

Diane is a full-time Business Technology faculty member at Madison College in Madison, WI. In addition to her faculty role, she works closely with business and industry specialists, developing and delivering tailored training solutions to employees in areas such as customer service, software applications and business writing skills. Prior to joining Madison College, she worked as a Technology Training Consultant, providing consultation and production assistance to teaching faculty and staff to incorporate appropriate technology in their courses to enhance learning. Diane holds a Bachelors Degree in Education from the University of Wisconsin-Madison and a Masters Degree in Educational Computing from Cardinal Stritch University.

Brant Moriarity

Brant P. Moriarity earned a B.A. in Religious Studies/Philosophy and a M.S. in Information Systems at Indiana University. He is a Senior Lecturer at the Indiana Universitys Kelley School of Business where he teaches topics such as data management and analysis, as well as the strategic use of Information Systems in business. He is also the founder of Beats Per Minute Technologies, LLC, bringing the benefits of business analytics to small businesses and non-profit organizations.

Your Office: Microsoft Access 2016 Comprehensive [Spiraalköide]

Konto & seaded

Otsing

Otsingu andmebaas

Filtreeri tulemusi

Teemad Ingliskeelsed raamatud

Vali ostukorv