Microsoft Access 2013 Plain & Simple

;
Chapter 1: About this book;
1.1 What’s new in Access 2013?;
1.2 A quick overview;
1.3 A few assumptions;
1.4 About the sample database;
1.5 Adapting task procedures for touchscreens;
1.6 A final word;
Chapter 2: Creating a custom Web App;
2.1 Starting Access;
2.2 Creating a custom Web App;
2.3 Adding a table template;
2.4 Showing the navigation pane;
2.5 Adding a blank table;
2.6 Launching a Web App;
2.7 Working with the List view;
2.8 Working with the Datasheet view;
2.9 Working with a summary view;
2.10 Finding your site and navigating to the team site;
2.11 Creating a Web App using a template;
Chapter 3: Modifying a Web App;
3.1 Importing from an Access desktop database;
3.2 Changing the design of a table;
3.3 Creating a lookup/relationship;
3.4 Designing with a List Details view;
3.5 Designing with a Datasheet view;
3.6 Designing with a summary view;
3.7 Designing with a blank view;
3.8 Open, rename, duplicate, or delete a view;
3.9 Creating a query;
3.10 Modifying the Table Selector;
3.11 Working with reports;
Chapter 4: Creating a desktop database;
4.1 Creating a blank desktop database;
4.2 Creating a table in design view;
4.3 Creating a table in layout view;
4.4 Working with data parts in layout view;
4.5 Creating a table by using application parts;
4.6 Adding a primary key;
4.7 Improving performance by indexing data;
4.8 Validate that data in a field is of the correct type;
4.9 Comparing field values by using table validation;
4.10 Formatting a field;
4.11 Recording changes to text and rich text formatting;
4.12 Creating relationships by using the Lookup Wizard;
4.13 Viewing relationships;
4.14 Deleting relationships;
4.15 Adding relationships;
Chapter 5: Working with data in datasheets;
5.1 Changing Access database options;
5.2 Altering the presentation by ordering, hiding, and freezing fields;
5.3 Moving between records and using Find And Replace;
5.4 Sorting datasheet rows;
5.5 Filtering datasheet rows;
5.6 Filtering combinations of choices with Filter By Form;
5.7 Filtering combinations of choices with Advanced Filter/Sort;
5.8 Inserting and updating records;
5.9 Deleting records;
5.10 Creating summary data for records;
5.11 Displaying related information with a subdatasheet;
5.12 Adjusting column/row height and formatting;
5.13 Selecting data to copy and paste;
5.14 Displaying more information with the Zoom box;
5.15 Changing the datasheet presentation;
Chapter 6: Selecting data using queries;
6.1 Selecting all columns from a table;
6.2 Selecting individual columns from one or more tables;
6.3 Joining tables to see unmatched or missing records;
6.4 Filtering by single and multiple combinations of choices;
6.5 Adding calculations with the expression builder;
6.6 Returning the top matched records;
6.7 Eliminating duplicate values;
6.8 Creating a summary calculation;
6.9 Prompting to filter data with parameters;
6.10 Creating a crosstab query with the Query Wizard;
6.11 Simplifying a problem with a query by using other queries;
6.12 Adding two sets of query results together;
6.13 Resolving ambiguous outer joins;
6.14 Creating an additional query to resolve a problem with mixed joins;
Chapter 7: Modifying data using queries;
7.1 Creating a table by using a Make Table query;
7.2 Changing data in a table with an Update query;
7.3 Adding data to an existing table with an Append query;
7.4 Deleting data in tables with a Delete query;
7.5 Updating a column based on an expression;
7.6 Adding only new data that is not already in a table;
7.7 Resetting an AutoNumber with an Append query;
Chapter 8: Improving presentations with forms;
8.1 Creating a continuous form with the multiple items template;
8.2 Creating a datasheet form with conditional formatting;
8.3 Creating a single record form with the Form Wizard;
8.4 Creating a split form;
8.5 Working with form views;
8.6 Working with control layouts;
8.7 Creating a parent/child form with the Form Wizard;
8.8 Altering link master and link child fields;
8.9 Controlling editing and data entry in a form;
8.10 Changing the data source for a form;
8.11 Organizing your database with navigation forms;
8.12 Adding fields to a form in design view;
8.13 Adding fields to a form in layout view;
8.14 Adding a subform to an existing form;
Chapter 9: Using controls effectively;
9.1 Creating labels and text boxes;
9.2 Creating lines and rectangles;
9.3 Creating check boxes, option buttons, and toggle buttons;
9.4 Creating option groups;
9.5 Creating list boxes;
9.6 Creating combo boxes;
9.7 Creating hyperlinks;
9.8 Creating logos and titles;
9.9 Creating bound and unbound object frames;
9.10 Creating image controls;
9.11 Creating attachments;
9.12 Creating web browser controls;
9.13 Working with tab controls;
9.14 Creating command buttons;
9.15 Setting control defaults;
9.16 Applying Office themes;
Chapter 10: Preparing data to print using reports;
10.1 Creating a tabular report with multiple tables;
10.2 Altering the presentation of controls on a page;
10.3 Working with controls and sections;
10.4 Using the Can Grow and Can Shrink Properties;
10.5 Adding a running sum;
10.6 Managing data and page breaks;
10.7 Adding sorting and grouping on reports;
10.8 Avoiding blank pages;
10.9 Adding conditional formatting;
10.10 Creating a single record report with the Report Wizard;
10.11 Creating a parent/child report;
10.12 Using labels and managing columns and rows;
10.13 Working with layout view, report view, and Print Preview;
Chapter 11: Exchanging data;
11.1 Importing data and objects from Access;
11.2 Linking to data in Access;
11.3 Importing data from Excel;
11.4 Linking to data in Excel;
11.5 Refreshing linked tables when files are changed;
11.6 Importing data from text files using specifications;
11.7 Exporting data to Excel;
11.8 Working with saved imports and exports;
11.9 Exporting data as PDF documents;
Chapter 12: Introducing the power of macros;
12.1 Enabling macro commands and disabling Trusted Documents;
12.2 Linking together forms;
12.3 Linking a form to a query;
12.4 Validating data entered in controls;
12.5 Making controls change other controls;
12.6 Processing data with action queries;
12.7 Executing a saved import/export;
Chapter 13: Administrating a database;
13.1 Compacting and repairing your database;
13.2 Analyzing your database;
13.3 Protecting your data;
13.4 Viewing object dependencies;
About the Author;