Microsoft Office Tutorials and References
In Depth Information
Book VII: Access 2013
Contents at a Glance
Chapter 1: Introducing Access.................................507
What Is a Database, Anyway? ..................................................................... 507
Tables, Queries, Forms, and Other Objects ............................................. 509
Creating a Database File ............................................................................. 513
Finding Your Way Around the Navigation Pane ...................................... 514
Designing a Database .................................................................................. 516
Chapter 2: Building Your Database Tables ......................521
Creating a Database Table .......................................................................... 521
Opening and Viewing Tables ...................................................................... 525
Entering and Altering Table Fields ............................................................ 526
Field Properties for Making Sure That Data Entries Are Accurate ........ 532
Indexing for Faster Sorts, Searches, and Queries .................................... 540
Establishing Relationships Between Database Tables ........................... 542
Chapter 3: Entering the Data...................................549
The Two Ways to Enter Data ..................................................................... 549
Entering the Data in Datasheet View ......................................................... 550
Entering the Data in a Form ....................................................................... 554
Finding a Missing Record ........................................................................... 556
Finding and Replacing Data ........................................................................ 557
Chapter 4: Sorting, Querying, and Filtering for Data ..............559
Sorting Records in a Database Table ........................................................ 559
Filtering to Find Information ...................................................................... 560
Querying: The Basics .................................................................................. 566
Six Kinds of Queries .................................................................................... 574
Chapter 5: Presenting Data in a Report .........................579
Creating a Report ......................................................................................... 579
Opening and Viewing Reports ................................................................... 581
Tweaking a Report ....................................................................................... 581
 
Search JabSto ::




Custom Search