Index

D

DAO (Data Access Objects), 129

data

deleting using SQL statements, 165–166

exporting from Access to other formats, 248

exporting to a spreadsheet, 205, 206

exporting using OutputTo, 211

importing from a text file, 206–208

importing from the Northwind database, 202–203

retrieving using SQL Select statements, 160–164

updating using SQL statements, 165

using from SharePoint lists, 222–232

using from web services, 214–220

data access

improving, 324–325

introduction to, 129–130

data access layer, 17, 104, 105

Data Access Objects (DAO), 129

data elements, determining, 11

data entry controls, emptying, 146–147, 154

data error, correcting up front, 196

data objects, manipulating, 177–178

data sources

linking to and importing from, 200

retrieving a set of records from, 132

specifying for a connection, 132

data tables, 318

data types

Access compared to SharePoint, 221

available in VBA, 49–50

changing from Access to equivalent SQL Server, 278, 282

user-defined, 52–53

data validation, adding, 196–197

database(s)

building for the Customer Service application, 465–475

building for the Project Tracker application, 340–343

compacting and repairing, 331

connecting to, 132

creating, 29–31

default format for, 29

encrypting, 329

making backup copies of, 331

updating from a disconnected recordset, 147, 155

database access code, isolating, 18

database calls, layer for, 16–17

database connections.

See also connections, opening

closing and releasing from memory, 143, 151

maintaining open, 139–140

minimizing open, 324

database element, 12

database layer

in n-tier architecture, 17

in three-tier architecture, 15, 16

database location, making configurable, 340

database objects

attaching to an e-mail, 210

for the Customer Service application, 465–475

Database parameter for the TransferSQLDatabase method, 204

database password, 327–328

database server, 14

Database Splitter, 319

Database Splitter Wizard, 319–322

database tables

retrieving data from, 163

separating from the user interface, 319–322

Database Tools ribbon, 18, 19

database transfers, 201

database updates, 517

database window, replaced by the navigation pane, 2

DatabaseName parameter, 201

DatabaseType parameter, 201

DataSource parameter, 209

DataSource property, 236

DataTarget parameter, 209

Date data type, 50

Date of Birth text box, 87, 89

Date or Time data type, 221

dates, checking, 277

dbl (Double) prefix, 55

Deactivate event, 247

Debug object, 82

debugging

code, 66–71

errors, 64–71

Debug.Print method, 82

Debug.Print statement, 68

decision making in code, 56–61

Decision Points in Activity Diagrams, 8

Declarations/Procedure navigation box, 27, 28

default error messages, 72

Default File Format option, 29

default record locking, 317

Delete command, 167, 173

Delete Comment button, 337

Delete method

adding to the clsCar class, 112–113

of the Recordset object, 142

delete operation, prompting the user to proceed, 388, 403

Delete procedure, 365–366, 370–371, 378, 382–383

Delete Selected Contact button, 338

Delete statements, 165–166

DeleteRecord procedure, 144, 152, 166–167, 172

delimited files, 208

demo CDs, creating, 256

descending order, 162

Description property of the Err object, 74

design guidelines, 322–323

design phase of SDLC, 4–18

Design ribbon

adding controls to a form, 187, 188

selecting and drawing controls, 115, 117

SQL View, 468, 469

ToolBox displayed on, 86

design specifications

for the Customer Service application, 461–465

for the Project Tracker application, 334–340

Design tab, enabling icons, 272

design time settings, 81

Design View

accessing in hidden mode, 236

retrieving data from multiple tables, 271, 272

switching to from Layout View, 29

designer window for a stored procedure, 267, 268

Desktop Edition. See SQL Server 2005 Express Edition

Destination parameter, 201

detail section of a report, 245

developer extensions, 330

development methodology, 3

development phase of SDLC, 18–23

diagramming techniques, 5

Dim statement

declaring a class, 115

declaring variables, 51

disconnected recordsets

building unbound forms, 142–156

described, 132

navigation procedures for, 145, 153

as recommended, 156

saving control values in, 147, 154–155

updating databases from, 147, 155

working with, 142

DisplayMessage procedure, 291

DisplaySystemInfo procedure, 292, 293, 294

DISTINCT predicate, 160

distribution options for applications, 329

divide by 0 error, 74

Dividing Lines property, 142, 149

DLLs (Dynamic Link Libraries)

referencing external, 291–294

standard, 287–291

using, 287–294

Do...Loop statement, 62–63

Do...Until loop, 62, 63

Do...While loop, 62

Do...While statement, 63

docmd command, 21, 23

DoCmd object

performing macro commands or menu options, 97–98

programatically linking a list, 227–229

TransferDatabase method, 200–203

documenting code, 63–64

Double data type, 50

DSN, 230

dt (Date) prefix, 55

dynamic arrays, 51, 52

Dynamic Link Libraries. See DLLs