Microsoft Access 2013 - Step by Step

Introduction

Part 1: Simple database techniques
1. Explore Microsoft Access 2013
-Identifying new features of Access 2013
-Working in the Access 2013 user interface
-Understanding database concepts
-Exploring tables
-Exploring forms
-Exploring queries
-Exploring reports
-Previewing and printing database objects
-Key points

2. Create databases and simple tables
-Creating databases from templates
-Creating databases and tables manually
-Manipulating table columns and rows
-Refining table structure
-Defining relationships between tables
-Key points

3. Create simple forms
-Creating forms by using the Form tool
-Formatting forms
-Arranging the layout of forms
-Key points

4. Display data
-Sorting information in tables
-Filtering information in tables
-Filtering information by using forms
-Locating information that matches multiple criteria
-Key points

5. Create simple reports
-Creating reports by using a wizard
-Modifying report design
-Previewing and printing reports
-Key points

Part 2: Relational database techniques
6. Maintain data integrity
-Specifying the type of data
-Setting the field size
-Restricting the format of data
-Validating the data
-Allowing only values in lists
-Allowing only values in other tables
-Key points

7. Create queries
-Creating queries by using a wizard
-Creating queries manually
-Summarizing data by using queries
-Calculating by using queries
-Updating records by using queries
-Deleting records by using queries
-Key points

8. Create custom forms
-Modifying forms created by using a wizard
-Adding controls
-Displaying subforms
-Key points

9. Create custom reports
-Creating reports manually
-Modifying report content
-Adding subreports
-Key points

Part 3: Database management and security
10. Import and export data
-Importing information
-Exporting information
-Copying to and from other Office programs
-Key points

11. Make databases user friendly
-Designing navigation forms
-Creating custom categories
-Controlling which features are available
-Key points

12. Protect databases
-Assigning passwords to databases
-Splitting databases
-Securing databases for distribution
-Preventing database problems
-Key points

13. Work in Access more efficiently
-Changing default program options
-Customizing the ribbon
-Manipulating the Quick Access Toolbar
-Key points

Glossary
Keyboard shortcuts
Index
About the authors
How to download your ebook
Survey page