Microsoft Access Training Northern Ireland

Advanced Level

Our standard course outline for this course is shown below, however, we are able to adapt the contents to suit your specific needs as required. Please contact us for more details

This course will help students to obtain the skills required to create a relational database. Students will learn relational database concepts and practice and understand the importance of documenting and maintaining database files.

Students will learn to customise forms, reports, and Data Access Pages in design view. Finally, students will be able to calculate and summarise data and import and export data in different formats for different purposes, like mail merge, analysis, or reporting.

• Using The Northwind Database
  • Installing The Northwind Database

• Structured Query Language
  • Writing SQL Commands
  • Writing SQL Queries
  • Writing SQL Subqueries
  • Writing SQL Joins
  • Inserting Data
  • Updating Data
  • Deleting Data
  • Writing SQL Queries In Access 2003/2007

• Working with Macros
  • Automating Tasks
  • Introducing The Macro Design Toolbar
  • Creating Macros
  • Testing And Debugging Macros
  • Modifying Macros
  • Conditional Programming In Macros
  • Adding Macros To Forms
  • Adding Macros To Reports
  • Filtering Data
  • Documenting Macros

• Using Visual Basic
  • Using Macros Versus Visual Basic
  • Understanding Visual Basic Concepts
  • Using The Visual Basic Editor Window
  • Getting Help With Visual Basic

• Using Data Access Pages
  • Creating Data Access Pages
  • Modifying Data Access Pages
  • Sorting Data In Data Access Pages
  • Summarising Data In Data Access Pages
  • Editing Data In Data Access Pages
  • Protecting Data In Data Access Pages

• Converting Access Databases
  • Converting Databases To Access 2003/2007
  • Converting From Access 2003/2007 To Access 97
  • Converting From Access 2003/2007 To Access 2000

• Customising Access 2003/2007
  • Configuring Access 2003/2007 Options
  • Configuring Autocorrect Options
  • Customising Menus And Toolbars

• Managing & Maintaining Databases
  • Optimising Databases With Table Analyzer
  • Optimising Databases With Performance Analyzer
  • Documenting Databases With Documenter Analyzer
  • Avoiding Errors With The Object Dependencies Task Pane

• Editing Spreadsheets
  • Cutting, Copying, And Pasting
  • Inserting And Deleting
  • Using Find And Replace
  • Using Undo And Redo

• Formulas and Functions
  • Entering Formulas
  • Entering Functions
  • Using Named Cells And Ranges In Formulas

• Printing
  • Using Page Setup
  • Margins
  • Headers And Footers
  • Printing A Spreadsheet
  

<- Back to Courses