Learn Microsoft Access 2010 and 2007
Microsoft OfficeAccess 2010 and 2007 TrainingCourse
Put Microsoft Office Access 2010 and 2007 to work for you in a 8 hours!
Level: Beginner to Intermediate
Microsoft Office Access 2010 Training Outline:
Overview of Microsoft Access Database Concept
Lesson 1: Getting Started with Office Access 2010
- Introduction to Microsoft Access 2010
- Getting familiar with Access 2010 New Interface
- Viewing a Sample Database
- Creating Databases using Database Templates
- Creating a Table using Application parts
- Creating a Simple Database using Datasheet View
- Creating a Simple Database in Design View
- Creating Relationship Between Tables
Lesson 2:Design and Creation of a database: student
- Designing a database
- Creating a sample database: student
- Creating datasheet relationships
- Creating indexes
- Editing field types
- Editing Table Structure
Lesson 3: Various Types of Queries
- Creating a select query
- Creating a parameter query
- Creating a cross tab query
- Creating a criteria query
- Performing calculation using a query
- Creating an operation query
- Creating an SQL query
Lesson 4: Forms
- Command button used to create form
- Creating a form using the Form Wizard
- Creating forms using the Form Tool
- Creating a split form
- Using form design view to create and edit a form
- Applying controls in the form design view
- Creating Command buttons in the Form Design View
- Creating a switchboard form
Lesson 5: Reports
- Using the Report Tool to create a report
- Using the Report Wizard to create a report
- Using the Label Wizard to create labels
- Creating a report using design view
- Editing a report
- Sorting and grouping in a report
- Printing reports
Microsoft Office Access 2007 Training Outline:
Lesson 1: Getting Started with Office Access 2007
- Opening up Access 2007
- Getting started with access options and tools
- Getting started with templates
- Getting started with blank databases and recent databases
- The Function Area
- The Navigation pane
- Tabbed documents
- The status bar
Lesson 2:Design and Creation of a database: student
- Design a database
- Create a sample database: student
- Create datasheet relationships
- Create indexes
- Edit field types
- Edit table structure
- Format datasheets
Lesson 3: Various Types of Queries
- Create a select query
- Create a parameter query
- Create a cross tab query
- Create a criteria query
- Perform calculation using a query
- Create an operation query
- Create an SQL query
Lesson 4: Forms
- Command button used to create form
- Create a form using the Form Wizard
- Create forms using the Form Tool
- Create a split form
- Use form design view to create and edit a form
- Applying controls in the form design view
- Create a switchboard form
Lesson 5: Reports
- Use the Report Tool to create a report
- Use the Report Wizard to create a report
- Use the Label Wizard to create labels
- Create a report using design view
- Editing a report
- Sorting and grouping in a report
- Calculations in a report
- Printing reports
Lesson 6: Importing and Exporting Data
- Importing Access files
- Importing Excel files
- Importing SharePoint lists
- Importing text files
- Importing XML files
- Linking to Access files
- Linking to Excel files
- Exporting a table as an Excel worksheet
- Exporting to a SharePoint site
- Exporting as .PDF or other type of file
Lesson 7:Use of Macros to automate tasks
- Create a macro using 1stmethod
- Create a macro using 2ndmethod
- Editing a macro
- Create a macro group
- Create a conditional macro
Lesson 8: Use of VBA and Modules
- Introduction to VBA and Modules
- Create a class module
- Create a standard module
- Creating and debugging procedure
- Editing a module
Lesson 9: Database Management and Security
- Backup a database
- Compacting and repairing a database
- Data Analysis
- Setup Passwords
- The Trust Center
- Saving as an .accde file (Execute-only Database)
Content:2 CD-ROMs for Windows
1. Access 2010 CD-ROM
2. Access 2007 CD-ROM
Packaging: Sealed DVD case
System Requirements:
Windows:
- Windows 10, 8, 7, Vista
- Pentium 133 Mhz or higher
- 32MB RAM
- 10MB free disk space
- 24x CD-ROM
View My response
Track Page Views With
Auctiva\'s FREE Counter
When you click on links to various merchants on this site and make a purchase, this can result in this site earning a commission. Affiliate programs and affiliations include, but are not limited to, the eBay Partner Network.