-
1. Introducing Access
·
Looking At Access
·
Examining The Projects
·
Understanding Database
Design
·
Using Database Wizards
·
Exploring A Database
·
Using The Office Assistant
·
Closing Access
·
Follow-up
-
2. Working With Tables
·
Understanding Tables
·
Using Design View
·
Saving And Closing Tables
·
Opening A Table
·
Modifying Columns And Rows
·
Using The Table Wizard
·
Working With field
Properties
·
Follow-up
-
3. Working With Data
·
Entering Data
·
Importing Data
·
Importing Data To A New
Table
·
Sorting Data
·
Deleting Data
·
Follow-up
-
4. Creating Relationships
·
Understanding Relationships
·
Enforcing Referential
Integrity
·
Printing And Saving
Relationships
·
Using Subdatasheets
·
Follow-Up
-
5. Using Forms
·
Understanding Forms
·
Using The Form Wizard
·
Entering Data In A Form
·
Working In Design View
·
Formatting Form Controls
·
Follow-Up
-
6. Filtering Data
·
Finding Records
·
Filtering By Selection
·
Filtering By Form
·
Sorting Filtered Records
·
Follow-Up
-
7. Exploring Queries
·
Understanding Queries
·
Creating Single-table
Queries
·
Using The Query Wizard
·
Creating Multi-table
Queries
·
Follow-Up
-
8. Creating Reports
·
Understanding Reports
·
Creating AutoReports
·
Using The Report Wizard
·
Previewing Multiple Pages
·
Printing Reports
·
Follow-Up
-
9. Application Project
·
Create An Employee Database
-
10. Using Help Appendix
·
Using The Help Window
·
Using The Contents Card
·
Using The Answer Wizard
·
Working With The Index
·
Using Context-sensitive
Help
·
Follow-up
-
11. Common Tools And Shortcuts Appendix
·
Database Tools
·
Table Datasheet Tools
·
Table Design Tools
·
Query Design Tools
·
Report Design Tools
·
Formatting (Form/Report
Design) Tools
·
Toolbox Tools
·
Web Tools
·
Print Preview Tools
·
navigation Shortcuts
-
Index
|
-
1. Expanding Tables
· Looking At This Course
· Examining The Projects
· Examining Tables In Design View
· Modifying Tables In Design View
· Adjusting Data Types
· Changing Field Properties
· Using Default Values
· Exploring Indexes
· Follow-up
-
2. Working With Data
· Looking At The Office Clipboard
· Copying And Pasting Data
· Understanding The Lookup Wizard
· Using The Input Mask Wizard
· Follow-up
-
3. Modifying Forms
· Exploring Form Sections
· Using Form Sections
· Binding Controls And Data
· Using Calculated Controls
· Adding Other Controls
· Follow-up
-
4. Creating Queries
· Using The Query Wizard
· Adding Tables And Fields
· Specifying Criteria
· Working With Query Fields
· Creating Action Queries
· Creating Calculated Fields
· Follow-Up
-
5. Customizing Reports
· Using Report Sections
· Modifying Report Controls
· Changing Format Properties
· Adding Controls
· Using Calculated Controls
· Follow-Up
-
6. Working With HTML And Hyperlinks
· Understanding Access On The Web
· Creating Web Documents
· Understanding Hyperlinks
· Follow-Up
-
7. Looking At Database Maintenance
· Backing Up Databases
· Compacting And Repairing Databases
· Using Name AutoCorrect
· Printing Database Objects
· Follow-Up
-
8. Application Project
· Sales Project
-
9. Common Tools And Shortcuts Appendix
· Database Tools
· Table Datasheet Tools
· Table Design Tools
· Query Design Tools
· Report Design Tools
· Formatting (Form/Report Design) Tools
· Toolbox Tools
· Web Tools
· Print Preview Tools
· Navigation Shortcuts
-
Index
|
