Авторизация
Поиск по указателям
Chase K.J., Palmer S. — Access for Starters: The Missing Manual
Обсудите книгу на научном форуме
Нашли опечатку? Выделите ее мышкой и нажмите Ctrl+Enter
Название: Access for Starters: The Missing Manual
Авторы: Chase K.J., Palmer S.
Аннотация: Maybe you got Access as part of Microsoft Office and wonder what it can do for you and your household; maybe you're a small business manager and don't have a techie on staff to train the office in Microsoft Access. Regardless, you want to quickly get your feet wet — but not get in over your head — and Access 2003 for Starters: The Missing Manual is the book to make it happen.
Far more than a skimpy introduction but much less daunting than a weighty tech book, Access 2003 for Starters: The Missing Manual demystifies databases and explains how to design and create them with ease. It delivers everything you need — and nothing you don't — to use Access right away. It's your expert guide to the Access features that are most vital and most useful, and it's your trusted advisor on the more in-depth features that are best saved for developers and programmers.
Access is sophisticated and powerful enough for professional developers but easy and practical enough for everyday users like you. This Missing Manual explains all the major features of Access 2003, including designing and creating databases, organizing and filtering information, and generating effective forms and reports.
Bestselling authors, database designers, and programmers Scott Palmer, Ph.D., and Kate Chase are your guides for putting the world's most popular desktop data management program to work. Their clear explanations, step-by-step instructions, plenty of illustrations, and timesaving advice help you get up to speed quickly and painlessly.
Whether you're just starting out or you know you've been avoiding aspects of the program and missing out on much of what it can do, this friendly, witty book will gentlyimmerse you in Microsoft Access. Keep it handy, as you'll undoubtedly refer to it again and again.
Язык:
Рубрика: Технология /
Статус предметного указателя: Готов указатель с номерами страниц
ed2k: ed2k stats
Год издания: 2005
Количество страниц: 396
Добавлена в каталог: 19.08.2007
Операции: Положить на полку |
Скопировать ссылку для форума | Скопировать ID
Предметный указатель
OR operator
Order Entry template
orphaned records
OurClub database (example)
outer join
overview of example database
overview of example database, relational databases
overview of example database, relational databases, subdatasheets and subforms
page header and footer (reports)
page section length
Parameter queries
parts of
parts of reports
parts of reports, Detail section
parts of reports, group header and footer
parts of reports, headers and footers
PCS
Picture 2nd 3rd
PivotChart forms
PivotTable forms
Properties
properties, form
properties, query
property sheets
proprietary format
QBE (Query by Example) grid 2nd
Queries 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th 19th 20th 21st
queries, Action
queries, Autolookup
queries, creating in Query Design window 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th 19th 20th 21st 22nd 23rd 24th 25th 26th 27th 28th 29th 30th 31st 32nd 33rd 34th 35th 36th
queries, creating in Query Design window, calculating averages
queries, creating in Query Design window, criteria 2nd 3rd
queries, creating in Query Design window, custom query 2nd 3rd 4th
queries, creating in Query Design window, tweaking custom query
queries, creating with a query wizard 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th 19th
queries, creating with a query wizard, Find Duplicates
queries, creating with a query wizard, Find Unmatched
queries, creating with a query wizard, Simple Query Wizard
queries, Crosstab
queries, filters vs.
Queries, parameter
queries, saving
queries, SELECT
queries, setting properties
queries, SQL
queries, testing database design
queries, when to use
Query 2nd 3rd 4th 5th
Query by Example (QBE) grid
Query Design window 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th 19th 20th 21st 22nd 23rd 24th 25th 26th 27th 28th 29th 30th 31st 32nd 33rd
Query Design window, calculations 2nd 3rd
Query Design window, calculations, sales total for specific date 2nd 3rd
Query Design window, calculations, subtotal, total, or grand total 2nd 3rd 4th
Query Design window, calculations, using number in two columns to create a third 2nd
Query Design window, criteria 2nd 3rd
Query Design window, Expression Builder
Query Design window, QBE grid
RAM
range wildcard (-)
Records
Records menu 2nd 3rd
records, adding with a form
records, in two tables
records, orphaned
records, sorting 2nd 3rd 4th 5th
records, sorting, Advanced Filter/Sort
records, sorting, descending sorts
records, sorting, on multiple fields
records, validation
Recordsets
Referential integrity
referential integrity, not enforcing
relational
Relational data model
Relational databases 2nd 3rd 4th 5th 6th
relational databases, creating subforms
relational databases, linking tables in Relationships window 2nd 3rd 4th 5th 6th
relational databases, overview of example database 2nd 3rd 4th 5th 6th
relational databases, overview of example database, common field
relational databases, situations for use 2nd 3rd
relational databases, viewing related items with subdatasheets
relationships
Relationships window 2nd 3rd 4th 5th 6th 7th 8th 9th
Relationships window, adding relationships between tables
Relationships window, adding tables
Relationships window, modifying or deleting relationships
Relationships window, printing relationships
relationships, integrity in
relationships, types of
Report
report snapshots
report templates
Report Wizard 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th
Report Wizard, adding report title
Report Wizard, choosing data source
Report Wizard, choosing fields
Report Wizard, choosing report layout
Report Wizard, choosing report style
Report Wizard, choosing report type
Report Wizard, sorting report data
Report Wizard, starting
report, footers
report, footers, Group Header/Footer
report, footers, page footer
report, headers
report, headers, page header
reports 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th
reports, creating
reports, creating with other programs
reports, displaying and printing 2nd 3rd 4th
reports, forms vs.
reports, great reports
reports, parts of 2nd 3rd 4th
reports, printing
reports, Report Wizard 2nd
reports, types of
Resource Scheduling template
screen tips
Searching
Select queries
selection criteria (queries) 2nd 3rd
Service Call Management template
Simple Query Wizard 2nd 3rd 4th 5th 6th
single-character wildcard (?)
Snapshot Viewer
Sorting
sorting, records 2nd 3rd 4th 5th 6th
sorting, records, ascending sorts
sorting, records, descending sorts
sorting, records, saving your choice
sorting, Sort menu
SpiesAndStuff_End.mdb database (example)
SQL (Structured Query Language)
SQL queries
Standard style
Styles
styles, report
subdatasheets 2nd 3rd 4th
subforms 2nd
subforms, creating
subtotal
Summary reports
Sums
switchboards 2nd
switchboards, buttons
switchboards, using to get database objects into database
Tables
tables, design by Database Wizard 2nd 3rd 4th 5th
tables, linking in Relationships window 2nd
tabular forms
Tabular reports
Task Pane 2nd
Templates
templates, locating and downloading 2nd 3rd
templates, overview of different types
templates, reports
templates, using with Database Wizard
text box controls (forms)
Time and Billing template
Toolbars
Toolbox
Toolbox, Label tool
Toolbox, modifying form design
Tools menu 2nd 3rd 4th 5th 6th 7th 8th
totals
troubleshooting databases
tutorials 2nd 3rd
unavailable menus
unbound controls
Undo tool
Validation 2nd 3rd
value lists
vertical reports
View menu 2nd 3rd 4th 5th 6th
Virtual memory
Web data format (XML)
Wildcards
wildcards, using * in a filter
wildcards, using in filters
Window menu
XML (Extensible Markup Language)
[ ] (brackets) 2nd
Реклама