Lesson 1: Getting Started with Office Access 2007
1.1 Opening up Access 2007
1.2 Getting started with access options and tools
1.3 Getting started with templates
1.4 Getting started with blank databases and recent databases
1.5 The Function Area
1.6 The Navigation pane
1.7 Tabbed documents
1.8 The status bar
Lesson 2: Design and Creation of a database: student
2.1 Design a database
2.2 Create a sample database: student
2.3 Create datasheet relationships
2.4 Create indexes
2.5 Edit field types
2.6 Edit table structure
2.7 Format datasheets
Lesson 3: Various Types of Queries
3.1 Create a select query
3.2 Create a parameter query
3.3 Create a cross tab query
3.4 Create a criteria query
3.5 Perform calculation using a query
3.6 Create an operation query
3.7 Create an SQL query
Lesson 4: Forms
4.1 Command button used to create form
4.2 Create a form using the Form Wizard
4.3 Create forms using the Form Tool
4.4 Create a split form
4.5 Use form design view to create and edit a form
4.6 Applying controls in the form design view
4.7 Create a switchboard form
Lesson 5: Reports
5.1 Use the Report Tool to create a report
5.2 Use the Report Wizard to create a report
5.3 Use the Label Wizard to create labels
5.4 Create a report using design view
5.5 Editing a report
5.6 Sorting and grouping in a report
5.7 Calculations in a report
5.8 Printing reports
Lesson 6: Importing and Exporting Data
6.1 Importing Access files
6.2 Importing Excel files
6.3 Importing SharePoint lists
6.4 Importing text files
6.5 Importing XML files
6.6 Linking to Access files
6.7 Linking to Excel files
6.8 Exporting a table as an Excel worksheet
6.9 Exporting to a SharePoint site
6.10 Exporting as .PDF or other type of file
Lesson 7: Use of Macros to automate tasks
7.1 Create a macro using 1st method
7.2 Create a macro using 2nd method
7.3 Editing a macro
7.4 Create a macro group
7.5 Create a conditional macro
Lesson 8: Use of VBA and Modules
8.1 Introduction to VBA and Modules
8.2 Create a class module
8.3 Create a standard module
8.4 Creating and debugging procedure
8.5 Editing a module
Lesson 9: Database Management and Security
9.1 Backup a database
9.2 Compacting and repairing a database
9.3 Data Analysis
9.4 Setup Passwords
9.5 The Trust Center
9.6 Saving as an .accde file (Execute-only Database)
Homepage
