Coverart for item
The Resource Access 2007 : the missing manual, by Matthew MacDonald

Access 2007 : the missing manual, by Matthew MacDonald

Label
Access 2007 : the missing manual
Title
Access 2007
Title remainder
the missing manual
Statement of responsibility
by Matthew MacDonald
Creator
Subject
Language
eng
Summary
Compared to industrial-strength database products such as Microsoft's SQL Server, Access is a breeze to use. It runs on PCs rather than servers and is ideal for small- to mid-sized businesses and households. But Access is still intimidating to learn. It doesn't help that each new version crammed in yet another set of features; so many, in fact, that even the pros don't know where to find them all. Access 2007 breaks this pattern with some of the most dramatic changes users have seen since Office 95. Most obvious is the thoroughly redesigned user interface, with its tabbed toolbar (or "Ribbon") that makes features easy to locate and use. The features list also includes several long-awaited changes. One thing that hasn't improved is Microsoft's documentation. To learn the ins and outs of all the features in Access 2007, Microsoft merely offers online help. Access 2007: The Missing Manual was written from the ground up for this redesigned application. You will learn how to design complete databases, maintain them, search for valuable nuggets of information, and build attractive forms for quick-and-easy data entry. You'll even delve into the black art of Access programming (including macros and Visual Basic), and pick up valuable tricks and techniques to automate common tasks -- even if you've never touched a line of code before. You will also learn all about the new prebuilt databases you can customize to fit your needs, and how the new complex data feature will simplify your life. With plenty of downloadable examples, this objective and witty book will turn an Access neophyte into a true master
Member of
Cataloging source
UMI
http://library.link/vocab/creatorName
MacDonald, Matthew
Dewey number
005.7565
Index
index present
LC call number
QA76.9.D3
LC item number
M33 2006
Literary form
non fiction
Nature of contents
dictionaries
http://library.link/vocab/subjectName
  • Database management
  • Database Management Systems
  • Databases
  • Database management
  • Microsoft Excel (Computer file)
  • Database management
Label
Access 2007 : the missing manual, by Matthew MacDonald
Instantiates
Publication
Carrier category
online resource
Carrier category code
  • cr
Carrier MARC source
rdacarrier
Content category
text
Content type code
  • txt
Content type MARC source
rdacontent
Contents
  • Ch. 5.
  • Linking tables with relationships
  • Ch. 6.
  • Queries that select records
  • Ch. 7.
  • Essential query tricks
  • Ch. 8.
  • Queries that update records
  • Ch. 9.
  • Analyzing data with crosstab queries and pivot tables
  • Ch. 1.
  • Ch. 10.
  • Creating reports
  • Ch. 11.
  • Designing advanced reports
  • Ch. 12.
  • Creating simple forms
  • Ch. 13.
  • Designing advanced forms
  • Ch. 14.
  • Building a navigation system
  • Creating your first database
  • Ch. 15.
  • Automating tasks with macros
  • Ch. 16.
  • Automating tasks with Visual Basic
  • Ch. 17.
  • Writing smarter code
  • Ch. 18.
  • Sharing a database with multiple users
  • Ch. 19.
  • Importing and exporting data
  • Ch. 2.
  • Ch. 20.
  • Connecting access to SQL Server
  • Ch. 21.
  • Connecting access to SharePoint
  • App.
  • Customizing the quick access toolbar
  • Building smarter tables
  • Ch. 3.
  • Mastering the datasheet : sorting, searching, filtering, and more
  • Ch. 4.
  • Blocking bad data
Control code
85872581
Dimensions
unknown
Extent
1 online resource
Form of item
online
Isbn
9780596527600
Media category
computer
Media MARC source
rdamedia
Media type code
  • c
Other control number
0596527608
http://library.link/vocab/ext/overdrive/overdriveId
cl0500000008
Sound
unknown sound
Specific material designation
remote
System control number
(OCoLC)85872581
Label
Access 2007 : the missing manual, by Matthew MacDonald
Publication
Carrier category
online resource
Carrier category code
  • cr
Carrier MARC source
rdacarrier
Content category
text
Content type code
  • txt
Content type MARC source
rdacontent
Contents
  • Ch. 5.
  • Linking tables with relationships
  • Ch. 6.
  • Queries that select records
  • Ch. 7.
  • Essential query tricks
  • Ch. 8.
  • Queries that update records
  • Ch. 9.
  • Analyzing data with crosstab queries and pivot tables
  • Ch. 1.
  • Ch. 10.
  • Creating reports
  • Ch. 11.
  • Designing advanced reports
  • Ch. 12.
  • Creating simple forms
  • Ch. 13.
  • Designing advanced forms
  • Ch. 14.
  • Building a navigation system
  • Creating your first database
  • Ch. 15.
  • Automating tasks with macros
  • Ch. 16.
  • Automating tasks with Visual Basic
  • Ch. 17.
  • Writing smarter code
  • Ch. 18.
  • Sharing a database with multiple users
  • Ch. 19.
  • Importing and exporting data
  • Ch. 2.
  • Ch. 20.
  • Connecting access to SQL Server
  • Ch. 21.
  • Connecting access to SharePoint
  • App.
  • Customizing the quick access toolbar
  • Building smarter tables
  • Ch. 3.
  • Mastering the datasheet : sorting, searching, filtering, and more
  • Ch. 4.
  • Blocking bad data
Control code
85872581
Dimensions
unknown
Extent
1 online resource
Form of item
online
Isbn
9780596527600
Media category
computer
Media MARC source
rdamedia
Media type code
  • c
Other control number
0596527608
http://library.link/vocab/ext/overdrive/overdriveId
cl0500000008
Sound
unknown sound
Specific material designation
remote
System control number
(OCoLC)85872581

Library Locations

    • Ellis LibraryBorrow it
      1020 Lowry Street, Columbia, MO, 65201, US
      38.944491 -92.326012
    • Engineering Library & Technology CommonsBorrow it
      W2001 Lafferre Hall, Columbia, MO, 65211, US
      38.946102 -92.330125
Processing Feedback ...