Part 1 Simple Database Techniques
Learn Microsoft Access 2010 Step by Step, Level 1
Explore an Access 2010 Database
Working in Access 2010
Sidebar: Enabling Macros and Other Database Content
Understanding Database Concepts
Exploring Tables
Sidebar: Tabbed Pages vs. Overlapping Windows
Exploring Forms
Exploring Queries
Exploring Reports
Previewing and Printing Access Objects
Key Points
Create Databases and Simple Tables
Creating Databases from Templates
Sidebar: Web Databases
Creating Databases and Tables Manually
Sidebar: Database Design
Manipulating Table Columns and Rows
Refining Table Structure
Creating Relationships Between Tables
Key Points
Create Simple Forms
Creating Forms by Using the Form Tool
Changing the Look of Forms
Changing the Arrangement of Forms
Key Points
Display Data
Sorting Information in Tables
Sidebar: How Access Sorts
Filtering Information in Tables
Filtering Information by Using Forms
Sidebar: Wildcards
Locating Information That Matches Multiple Criteria
Sidebar: Saving Filters as Queries
Key Points
Create Simple Reports
Creating Reports by Using a Wizard
Modifying Report Design
Previewing and Printing Reports
Key Points
Programme scope, delivery arrangements and suitability are confirmed during enquiry.