book

Microsoft® Access® 2010 Plain & Simple

Name: Microsoft® Access® 2010 Plain & Simple
Author: Curtis D. Frye
ISBN: 9780735647350

by Curtis D. Frye

June 2010

Beginner

288 pages

7h 25m

English

Microsoft Press

Read now

Unlock full access

1. Introduction: About This Book
No Computerese!Useful Tasks......And the Easiest Way to Do ThemA Quick OverviewA Few AssumptionsA Final Word (or Two)
2. What’s New in Access 2010?
Managing Access Settings and Files in Backstage ViewCustomizing the Access 2010 User InterfaceCreating Databases Using Improved TemplatesBuilding Databases by Re-Using Application PartsCreating Navigation FormsFormatting Database Objects Using Office ThemesGaining Insights into Data Using Conditional FormattingDefining Calculated Fields Using the Improved Expression Builder
3. Introducing Access 2010
Introducing DatabasesStoring Data on Index CardsStoring Data on the ComputerStoring Data in a DatabaseStarting Access 2010Start Access 2010Create a Shortcut for Access 2010Surveying the Access 2010 WindowOpening a DatabaseOpen a Database on StartupOpen a Recently Used DatabaseViewing Multiple Database ObjectsClose a Database ObjectScroll Within a Database ObjectClosing a Database and Exiting Access 2010Close a DatabaseExit Access 2010Displaying and Managing Database ObjectsOpen a Database ObjectControl Object Display in the Navigation PaneUsing the Access 2010 Help SystemGet Suggested Commands from Shortcut MenusGet Microsoft Access 2010 HelpGet Help on the Web
4. Creating a Database
Designing a DatabaseOne Table per ObjectGive Every Table a Primary KeyInclude Foreign KeysViewing a Sample DatabaseOpen a Sample DatabaseCreating a New DatabaseBegin a New DatabaseCreate a New Database Based on Another DatabaseCreating Databases Using Database TemplatesCreate a Database from a TemplateFind Database Templates OnlineCreating a New Table in Design ViewCreate a Table in Design ViewCreating a New Table by TypingCreate a New Table by TypingCreating a New Table Using a TemplateAdd Fields from the Add & Delete Ribbon GroupAdd More Types of FieldsAdd Multiple Related Fields at One TimeCreating a New Table Using Application PartsCreate a Table, Forms, and Reports Using Application PartsSetting a Primary KeyAssign a Primary KeyGetting Data from Other Access 2010 TablesCopy a Table from Another DatabaseRelationships ExplainedOne-to-Many RelationshipsMany-to-Many RelationshipsCreating Relationships Between TablesDefine a RelationshipEnforcing Referential IntegrityEnforce Referential Integrity
5. Customizing Fields
Working with TablesDelete a FieldAdd a FieldArrange FieldsAssigning a Data TypePick a Data TypeAvailable Data TypesViewing or Changing Field PropertiesView Field PropertiesIntroducing the Expression BuilderFormatting Field ContentsChange Field FormatCreating Input MasksDefine an Input MaskEdit an Input MaskAssigning Required Fields and Requiring Data EntryRequire Data EntryDisallow Zero-Length StringsSetting Default ValuesAssign a Default ValueIndexing Field ValuesCreate an IndexValidating Data EntryPerform Data ValidationSet Validation TextCreating a Lookup FieldDefine a Field as a Lookup FieldAllow Multiple Selections from a Lookup FieldDraw Lookup Values from a Data ListCreating an Append-Only Memo FieldCreate an Append-Only FieldCreating an Attachment FieldCreate an Attachment Field
6. Customizing Tables
Finding and Replacing TextFind TextReplace TextEntering Data Using AutoCorrectAdd Text with AutoCorrectTurn AutoCorrect On or OffAdd AutoCorrect ValuesAdding and Editing TextSelect TextDelete TextUndoing OperationsCopy and Paste TextCopy and Paste Items with the Office ClipboardManipulating ColumnsRelocate a ColumnInsert a ColumnRename a ColumnCopy a ColumnModifying Columns and RowsChange Row HeightChange Column WidthViewing a SubworksheetOpen and Close a SubworksheetCreate a SubworksheetFiltering Table RecordsFilter Table RecordsFilter by FormRemove a FilterFilter Records by the Contents of More than One Column
7. Creating Forms
Creating a Simple FormCreate a Simple FormCreating a Form Using the Form WizardStep Through the Form WizardCreating a Form in Design ViewCreate a Form in Design ViewCreating a Multiple Items FormCreate a Multiple Items FormModifying an Existing FormOpen a Form for Editing in Design ViewDisplay the Field ListHide the Field ListAdd a Field to a FormAdding and Deleting Form ControlsAdd a Control Using a WizardDelete a ControlModify Control PropertiesAvailable Control TypesAdding a Date Picker ControlAdd a Date PickerCreating a SubformAdd a SubformChange Subform ViewsDisplaying a Form and Its Datasheet SimultaneouslyCreate a Split Form
8. Creating Queries
Introducing Query TypesCreating a Query Using the Query WizardCreate a Detail QueryCreate a Summary QueryEditing a Query in Design ViewOpen a Query for EditingAdd a Table to a QueryAdd a Field to a QueryCreate a Query in Design ViewUsing Criteria to Focus Query ResultsSet Query CriteriaIntroducing OperatorsArithmetic OperatorsComparison OperatorsLogical OperatorsUsing Queries to Calculate ValuesCalculate a Value in a QueryCreating a Parameter QueryBuild a Parameter QueryFinding Duplicate RecordsCreate a Find Duplicates QueryFinding Unmatched RecordsCreate a Find Unmatched Records QueryWriting Query Results to a New TableCreate a Make-Table QueryCreating an Update QueryUpdate Table Values with a QueryCreating a Crosstab QueryBuild a Crosstab QueryFinding the Largest and Smallest Values in a Field by Using a QueryFind the Largest Values in a FieldFind the Smallest Values in a Field
9. Creating Reports
Creating a Report Using the Report WizardStep through the Report WizardCreating a Summary ReportBuild a Summary ReportCreating a Report in Design ViewBuild a New ReportModifying an Existing ReportOpen a Report for EditingDisplay or Hide the Field List Task PaneAdd a Field to a ReportAdding and Deleting Report ControlsAdd a Control Using a WizardDelete a ControlModify Control PropertiesCalculating Values in a ReportCreate a Calculated FieldIntroducing Report SectionsGrouping Report RecordsCreate a Grouping LevelReorder Grouping LevelsDelete a Grouping LevelCreating a Subform or SubreportAdd a Subform or SubreportCreating Mailing LabelsGenerate Mailing Labels
10. Beautifying Forms and Reports
Formatting TextChange Text FormattingIntroducing Office ThemesApplying Office ThemesSelect an Office ThemeApply Office Theme ElementsCombine Existing Elements into a New Office ThemeCreate a Custom Office ThemeSetting Control AppearanceChange Control ColorsFormat Controls with Special EffectsDistribute Controls HorizontallyDistribute Controls VerticallyAlign ControlsAdding Lines, Shapes, and BordersDraw a LineAdd a BorderChange an Object’s Fill ColorShowing Gridlines in a ReportTurn Gridlines On or OffChange Gridline AppearanceColoring Alternate Rows in a Form or ReportColor Alternate Data RowsAdding a Totals Row to a WorksheetAdd a Totals RowAdding a PictureEmbed a PictureChange an Embedded Picture to a Linked PictureApplying Conditional FormattingDefine a Conditional FormatDefine a Data Bar Conditional FormatChanging the Source of an ImageDefine a New Image SourceSetting Image Alignment and Backing ColorSet a Backing ColorChange a Picture’s AlignmentTiling a PictureRepeat a Picture on a Form or ReportSetting Image Height and WidthSet a Precise Image Height and WidthSet an Image’s Resizing Property

11. Creating Charts in Access 2010
Creating a ChartBuild a New ChartFormatting Chart ElementsChange an Element’s Fill ColorChange an Element’s Font, Size, and StyleChange an Element’s Number FormatCustomizing Chart AxesAdd a Title to an AxisShow or Hide Axis GridlinesAdd Information to a ChartShow or Hide a Chart LegendChange the Legend’s LocationAdd a Text BoxChanging a Chart’s TypeSelect a Different Chart Type
12. Interacting with Other Programs
Introducing Linking and EmbeddingInserting a New ObjectEmbed an Existing ObjectLink to an Existing ObjectManipulating ObjectsCopy an ObjectPaste an ObjectMove an ObjectResize an ObjectInserting Excel 2010 Charts and WorksheetsAdd an Excel 2010 ChartAdd an Excel 2010 WorksheetImporting Data from Another Access 2010 DatabaseImport One or More TablesLinking to a Table in Another Access 2010 DatabaseCreate a Link to a TableWorking with HyperlinksCreate a Hyperlink to an Existing FileCreate a Hyperlink to a Web PageCreate a Hyperlink to an Existing Database ObjectImporting Data from an Excel 2010 FileImport Excel 2010 DataImporting Data from a Text FileImport Text DataImporting Data from an XML FileImport XML DataExporting Data to a Text FileExport Text DataExporting Data to Another Access 2010 FileExport to Another Access 2010 DatabaseExporting Data to an XML FileExport XML DataSaving Database Objects As Web FilesSave an Object As a Web FileAnalyzing Data with Excel 2010Analyze Data in Excel 2010Publishing Data to Word 2010Export Data to Word 2010Collecting Data from E-mail MessagesSend a Data Collection E-Mail MessageProcess Data Collection E-Mail Messages
13. Administering a Database
Introducing Database SecurityPasswordsEncrypting DatabasesEncrypting a DatabaseEncrypt a DatabaseDecrypt a DatabaseLocking Database RecordsPrevent More than One User from Editing a Form RecordLock Records in a FormCreating a Navigation FormCreate a Navigation FormAdd an Object to a Navigation FormChange the Appearance of a Navigation Form TabMove a Navigation Form TabDocumenting a DatabaseDocument a DatabaseSetting Startup OptionsChange an Application TitleHide All MenusSet Startup FormSet Startup Display Options
14. Customizing Access 2010
Adding Commands to the Quick Access ToolbarAdd a Command to the Quick Access ToolbarRemove a Command from the Quick Access ToolbarMove the Quick Access ToolbarModifying the Ribbon User InterfaceAdd a Command to a Ribbon TabReorder Commands on a Ribbon TabRemove a Ribbon ElementCreate a Custom Ribbon TabAdd a New Group to a Ribbon TabRename a Ribbon ElementHide a Ribbon ElementRedisplay a Hidden Ribbon ElementChanging AutoCorrect OptionsChange AutoCorrect OptionsAdd AutoCorrect RulesDelete an AutoCorrect Entry
15. Presenting Table and Query Data Dynamically
Introducing PivotTables and PivotChartsPivotingFilteringPivotChartsCreating a PivotTableCreate a PivotTable FormAdding and Removing PivotTable FieldsAdd a Field to a PivotTableRemove a Field from a PivotTablePivoting a PivotTableReorganize PivotTable DataFiltering PivotTable DataSelect Which Field Values to DisplayFilter by a Field Not Displayed in the Body of a PivotTableToggle a Filter On and OffFormatting a PivotTableChange a PivotTable’s AppearanceCreating a PivotChartStep through the PivotChart WizardChange a PivotChart Chart Type
A. About the Author
Index
About the Author
Copyright

Content preview from Microsoft® Access® 2010 Plain & Simple

Chapter 15. Presenting Table and Query Data Dynamically

In this section:

Microsoft Access 2010 places wide-ranging and powerful capabilities at your disposal. You can build tables to store data effectively, ask questions of the data using queries, and display the data in forms and reports. Even better, you can use many of those techniques in a single database object: the PivotTable Report.

When you create a PivotTable, you build a versatile object you can use as part of live business presentations to illustrate your own points and answer your colleagues’ questions quickly. If you’d rather summarize your ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.

Julian F.

Head of Cybersecurity

I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.

Addison B.

Field Engineer

I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.

Amir M.

Data Platform Tech Lead

I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.

Mark W.

Embedded Software Engineer

Publisher Resources

ISBN: 9780735647350Purchase book

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills

Microsoft® Access® 2010 Plain & Simple

by Curtis D. Frye

Chapter 15. Presenting Table and Query Data Dynamically

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.