|
What's included in your Training
|
|
|
|
|
- 6 months free course repeats
- 6 months online access to eLearning course content
- 60 day post course help-desk support
|
|
|
|
|
- New Horizons is a Registered Training Organisation (RTO)
- New Horizons employs vendor certified and industry experienced trainers which ensures clients receive training from qualified instructors
- Centrally located facilities in the heart of the CBD
Click here for more reasons to choose New Horizons.
|
|
|
|
|
|
|
Flexible Delivery Options
|
|
|
|
|
New Horizons offers the following training delivery options for Microsoft
Access courses: |
|
|
|
|
|
SKILLS COVERED:
- Orientation to Microsoft Access
- Create a simple database
- Modify table data
- Sort and filter records
- Query a database
- Create parameter, action, unmatched and duplicate queries
- Create a report
- Add controls and enhance the appearance of a report
- Use the Access options dialog box
SKILLS COVERED:
- Design a relational database
- Create a table and table relationships
- Join tables and relate data within a table
- Improve table structure
- Import data into Access
- Export data to access and text formats
- Create a mail merge
- Organise and format reports
SKILLS COVERED:
- Explore the Access interface
- Create a new database
- Add and manage tables
- Sort and filter records
- Work with subdatasheets
- Create a query and add criteria to a query
- Create and format a form
- Generate a report
- Add controls and format a report
- Constrain data entry and establish data entry formats
- Create query joins and action queries
- Add a command button to a form
- Create a subform
- Organise and format reports
- Create a mailing label report and mail merge
- Import data into Access
- Export data to Excel and text files
SKILLS COVERED:
- Restructure data in a table
- Improve table structure
- Create subqueries, unmatched and duplicate queries
- Create a PivotTable and a PivotChart
- Create and attach a macro
- Validate and automate data using a macro
- Include a chart in a report
- Link tables to external data sources
- Manage and document a database
SKILLS COVERED:
- Import XML data into an Access database
- Export data to XML format and Outlook address book
- Call and run a procedure from a form
- Create and modify a database switchboard
- Implement security and set passwords
- Package a database with a digital signature
- Share databases using a SharePoint site
SKILLS COVERED:
- Explore the interface elements
- Use contextual tabs and commands on the ribbon tabs
- Create a table
- Work with macros
- Query a database
- Generate and format a report
- Import data
- Export data to other applications
- Create tables, forms, queries and reports in a web database
SKILLS COVERED:
- Explore the Access interface and ribbon
- Customise the Access environment
- Define database purpose
- Create a new database and table
- Manage tables and modify table data
- Sort and filter records
- Work with subdatasheets
- Create a query and add criteria to a query
- Create and format a form
- Generate a report
- Add controls and format a report
- Restrict data entry and establish a pattern for entering field values
- Create query joins, parameter and action queries
- Add a command button to a form
- Create a subform
- Organise and format reports
- Create a mailing label report
- Import data into Access
- Export data to Excel and text files
SKILLS COVERED:
- Analyse tables and improve table structure
- Create subqueries, unmatched and duplicate queries
- Create a PivotTable and a PivotChart
- Create and attach a macro
- Validate and automate data using a macro
- Display a calendar and a summary of data in a form
- Include a chart in a report
- Link tables to external data sources
- Manage and document a database
SKILLS COVERED:
- Import XML data into an Access database
- Export data to XML format and Outlook address book
- Call and run a procedure from a form
- Create and modify a database switchboard
- Implement security and set passwords
- Package a database with a digital signature
- Share databases using a SharePoint site
SKILLS COVERED:
- Explore and customise the user interface
- Work with the ribbon and contextual tabs
- Create tables and forms
- Query a database
- Generate and format reports
- Import and export data
SKILLS COVERED:
- Explore the Access development environment
- Work with macros and VBA
- Understand the VBA essentials
- Work with variable, interactive and decisive VBA
- Loop VBA
- Understand the DoCmd object
- Work with ActiveX data objects
- Navigate, find and add records in a form
- Debug VBA
- Handle errors in VBA
SKILLS COVERED:
- Explore the Access and database environment
- Add, delete, sort and update records
- Establish table relationships
- Create a query and add criteria to a query
- Create AutoForms and format a form
- Generate an AutoReport and by using the wizard
- Design a relational database
Create a new database
- Restrict data entry with field properties
- Create query joins, parameter and action queries
- Add a command button to a form
- Create a subform
- Organise reports and set control properties
- Create a mailing label
- Export data to a text file
- Merge Access data with a Word document
SKILLS COVERED:
- Analyse tables and improve table structure
- Create sunmatched and duplicate queries
- Create a PivotTable and a PivotChart
- Create and attach a macro
- Display a calendar in a form
- Include a chart in a report
- Link tables to external data sources
- Document a database
SKILLS COVERED:
- Make data available on the web
- Create Data Access page in design view
- Develop a PivotTable and a PivotChart
- Import XML data into an Access database
- Export Access data to XML format
- Call and run a procedure from a form
- Create and modify a database switchboard
- Implement security and set passwords
- Encode and decode a database
|
|
What our customers have to say
|
|
"Nicky Bull was an outstanding instructor. She is very professional, thorough and has a great attitude towards teaching students." |
Tania Elmasri |
|
"The instructor explained the material very clearly and answered all questions to satisfactory levels." |
Yogeeta Naidoo |
|
"I particularly like the way the instructor answered student queries. This is unlike other training that I have been to. |
Frank Porbo |
|
|