book

Microsoft Access 2013 Plain & Simple

Name: Microsoft Access 2013 Plain & Simple
Author: Andrew Couch
ISBN: 9780735672635

by Andrew Couch

March 2013

Beginner

272 pages

7h 11m

English

Microsoft Press

Read now

Unlock full access

Dedication
1. About this book
What’s new in Access 2013?A quick overviewA few assumptionsAbout the sample databaseAdapting task procedures for touchscreensA final word
2. Creating a custom Web App
Starting AccessStart AccessCreating a custom Web AppCreate a custom Web AppAdding a table templateAdd a table templateShowing the navigation paneShow the navigation paneAdding a blank tableAdd a blank tableLaunching a Web AppLaunch a Web AppWorking with the List viewWork with the List viewWorking with the Datasheet viewWork with the Datasheet viewWorking with a summary viewWork with a summary viewFinding your site and navigating to the team siteFind a siteCreating a Web App using a templateCreate a Web App using a template
3. Modifying a Web App
Importing from an Access desktop databaseImport an Access databaseChanging the design of a tableChange the design of a tableCreating a lookup/relationshipCreate a lookupDesigning with a List Details viewCreate a List Details viewRemove fieldsAdd fieldsDesigning with a Datasheet viewCreate a Datasheet viewFormat a fieldDesigning with a summary viewCreate a summary viewDesigning with a blank viewCreate a blank viewOpen, rename, duplicate, or delete a viewChange a table design when editing a viewCreating a queryCreate a queryModifying the Table SelectorModify the Table Selector to hide or show a tableChange a table iconWorking with reportsCreate a report database
4. Creating a desktop database
Creating a blank desktop databaseCreate a blank desktop databaseCreating a table in design viewCreate a tableCreating a table in layout viewCreate a tableChange field captions and descriptionsWorking with data parts in layout viewAdd a data partCreate a new data partCreating a table by using application partsAdd an application partAdding a primary keyDefine a primary key in design viewImproving performance by indexing dataCreate an indexValidate that data in a field is of the correct typeMake a field required and add an input maskAdd a field validation rule and defaultCreate a lookup based on valuesComparing field values by using table validationCreate a validation ruleFormatting a fieldFormat a fieldRecording changes to text and rich text formattingAppend Only and Rich Text for Long Text dataCreating relationships by using the Lookup WizardCreate a lookupViewing relationshipsView relationshipsDeleting relationshipsDelete a relationshipAdding relationshipsAdd a relationship
5. Working with data in datasheets
Changing Access database optionsChange the default database optionsAltering the presentation by ordering, hiding, and freezing fieldsOrder columnsHide and unhide columnsFreeze and unfreeze columnsMoving between records and using Find And ReplaceMove between recordsSearch through recordsSorting datasheet rowsApply a sort on a columnRemove a sortFiltering datasheet rowsApply a filter on a columnRemove a filter on a columnFilter by column title barFiltering combinations of choices with Filter By FormApply Filter By FormSave a filter as a queryFiltering combinations of choices with Advanced Filter/SortApply Advanced Filter/SortInserting and updating recordsEdit and then save and undo changes to a saved recordInsert a recordDeleting recordsDelete a recordCreating summary data for recordsDisplay totals for a datasheetDisplaying related information with a subdatasheetAdd a query as a subdatasheet to a tableAdjusting column/row height and formattingAdjust row heightAdjust column widthAdjust row fontFormat rows and alternating rowsSelecting data to copy and pasteSelect all displayed dataSelect a subset of all columnsSelect an area of dataDisplaying more information with the Zoom boxDisplay information with a Zoom boxChanging the datasheet presentationChange the datasheet options
6. Selecting data using queries
Selecting all columns from a tableSelect all columns from a tableSelecting individual columns from one or more tablesSelect individual columnsSort by selected columnsJoin multiple tablesJoining tables to see unmatched or missing recordsFind unmatched child recordsDisplay all parent records with and without child recordsFiltering by single and multiple combinations of choicesFilter to match similar textAdd a second set of criteriaAdding calculations with the expression builderCreate an expression with the expression builderReturning the top matched recordsReturn the top matched recordsEliminating duplicate valuesEliminate duplicate rowsCreating a summary calculationAdd a summaryPrompting to filter data with parametersPrompt with query parametersCreating a crosstab query with the Query WizardCreate a crosstab querySimplifying a problem with a query by using other queriesCreate a query to combine data from a table and queryAdding two sets of query results togetherAdd two result sets togetherResolving ambiguous outer joinsCreating an additional query to resolve a problem with mixed joinsResolve join ambiguity
7. Modifying data using queries
Creating a table by using a Make Table queryCreate a table by using a Make Table queryChanging data in a table with an Update queryChange data based on explicit valuesChange data based on data in another tableAdding data to an existing table with an Append queryAdd data to an existing tableDeleting data in tables with a Delete queryDelete data in a tableUpdating a column based on an expressionUpdate a column based on an expressionAdding only new data that is not already in a tableAdd only new dataResetting an AutoNumber with an Append queryReset an AutoNumber
8. Improving presentations with forms
Creating a continuous form with the multiple items templateCreate a multiple items formCreating a datasheet form with conditional formattingCreate a datasheet formCreating a single record form with the Form WizardCreate a single record formCreating a split formCreate a single split formWorking with form viewsChange the default viewWorking with control layoutsRemove a control layoutCreating a parent/child form with the Form WizardCreate a parent/child form with a subformAltering link master and link child fieldsAlter master and child link fieldsControlling editing and data entry in a formChange a form to data entryChanging the data source for a formChange the record source from a table to SQLOrganizing your database with navigation formsCreate a navigation formAdding fields to a form in design viewAdd a field to a single record formAdd a field to a continuous formAdding fields to a form in layout viewAdd a field to a single record formAdd a field to a continuous formAdding a subform to an existing formAdd a subform in design view
9. Using controls effectively
Creating labels and text boxesCreate a label and an unbound text boxCreating lines and rectanglesCreate a line and a rectangleCreating check boxes, option buttons, and toggle buttonsCreate an option button and toggle buttonCreating option groupsCreate an option groupCreating list boxesCreate a list box based on valuesCreating combo boxesCreate a combo box based on a tableCreating hyperlinksCreate a hyperlinkCreating logos and titlesCreate a logo and titleCreating bound and unbound object framesCreate a bound object frameCreate an unbound object frameCreating image controlsCreate an image with the image controlCreate an image with the Image GalleryCreating attachmentsCreate an attachmentCreating web browser controlsCreate a web browser controlWorking with tab controlsWork with a tab controlCreating command buttonsCreate a command buttonSetting control defaultsSet control defaultsApplying Office themesApply an Office theme

10. Preparing data to print using reports
Creating a tabular report with multiple tablesCreate a tabular reportAltering the presentation of controls on a pageAlter the size and position of a controlWorking with controls and sectionsMove controls between sectionsUsing the Can Grow and Can Shrink PropertiesAllow a section and controls to grow and shrinkAdding a running sumAdd a running sumManaging data and page breaksForce a new pageKeep results together on the same pageAdding sorting and grouping on reportsAdd a sort and groupAvoiding blank pagesRemove a blank pageAdding conditional formattingAdd conditional formattingCreating a single record report with the Report WizardCreate a single record reportCreating a parent/child reportCreate a parent/child reportUsing labels and managing columns and rowsAdd a columns presentationWorking with layout view, report view, and Print PreviewAlter a report in layout viewSwitch between report view and Print Preview
11. Exchanging data
Importing data and objects from AccessImport data and objects from an Access databaseLinking to data in AccessLink to data in an Access databaseImporting data from ExcelImport data from ExcelLinking to data in ExcelLink to data in ExcelRefreshing linked tables when files are changedRefresh linked tablesImporting data from text files using specificationsImport data from a text fileExporting data to ExcelExport data to ExcelWorking with saved imports and exportsRun an import/export operationExporting data as PDF documentsSave data as a PDF document
12. Introducing the power of macros
Enabling macro commands and disabling Trusted DocumentsDisable Trusted DocumentsLinking together formsCreate an embedded macro to open a formLinking a form to a queryLink a form to a table or queryValidating data entered in controlsValidate data entered in a controlMaking controls change other controlsChange other controlsProcessing data with action queriesEmpty and populate a table of dataExecuting a saved import/exportExecute a saved import/export
13. Administrating a database
Compacting and repairing your databaseCompact and repair a databaseAnalyzing your databaseDocument a databaseAnalyze performance of a databaseAnalyze a tableProtecting your dataProtect a databaseViewing object dependenciesView an object’s dependencies
A. About the Author
Index
About the Author
Copyright

Overview

Learn the simplest ways to get things done with Microsoft Access 2013

Get the full-color, visual guide that makes learning Microsoft Access 2013 plain and simple! Follow the book’s easy steps and screenshots and clear, concise language to learn the simplest ways to build a database and sort information.

Here’s WHAT you’ll learn:

Build and manage your own database

Apply professional designs across your databases

Create presentations and publish reports online

Secure your database with passwords and encryption

Exchange data with other databases and documents

Interact with your data easier using macros

Here’s HOW you’ll learn it:

Jump in wherever you need answers

Follow easy STEPS and SCREENSHOTS to see exactly what to do

Get handy TIPS for new techniques and shortcuts

Use TRY THIS! Exercises to apply what you learn right away

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: 9780735672635Purchase book

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills