Thursday, August 4, 2016

Access Basic (I)

Content
1.1 Starting Access
1.2 Opening an Existing Database
1.3 Moving Around in Access
1.4 Opening an Object in Datasheet View
1.5 Opening an Object in Design View
1.6 Switching Between Datasheet and Design View
1.7 Navigating in Datasheet View
1.8 Closing an Object

2.1 Creating a Database
2.2 Creating a Table
2.3 Adding Fields to Tables
2.4 Adding Records
2.5 Editing Records
2.6 Moving Fields
2.7 Deleting Records

3.1 Formatting a Table
3.2 Sorting Records in a Table
3.3 Finding Records in a Table
3.4 Applying a Filter to a Table
3.5 Removing a Filter
3.6 Establishing a Relationship
3.7 Enforcing Referential Integrity
3.8 Creating Subdatasheets
3.9 Importing Records from an External Source
3.10 Copying Records into a Table

4.1 Creating a Query Using the Simple Query Wizard
4.2 Specifying Criteria in a Query
4.3 Creating a Query in Design View
4.4 Creating a Calculated Field
4.5 Creating a Multiple-Table Query


5.1 Creating a Form Using AutoForm
5.2 Creating a Form Using the Form Wizard
5.3 Adding Controls to a Form
5.4 Modifying Control Properties
5.5 Resizing Controls on Forms
5.6 Creating a Form in Design View
5.7 Entering Records into a Form

6.1 Creating a Report Using AutoReport
6.2 Creating a Report Using the Report Wizard
6.3 Adding a Control to a Report
6.4 Creating a Report in Design View
6.5 Formatting a Report
6.6 Creating Calculated Controls

No comments:

Post a Comment