Minerva Pro

       All about real growth

 

Access

Get the training you need - select the modules covering the functionality that you want to learn about! Mix and match with other applications and contact us about a delivery programme.

On site training lead by Microsoft Certified Trainers includes the provision of training manuals, exercises, case studies and training PC's. Each module is priced at $120 + GST. Bulk purchase advantages apply for 5 or more modules or 5 or more attendees.

The modules below apply for Office 2016Chat to us about modules for 2010 or 2013!

Foundation Modules

1. Getting Started                                                         2. The New Interface  

· Recognize some new features in Access 2016
· Open and close Access
· Identify and understand basic database terminology
· Identify different interface features
· Use the Backstage View (File menu)
· Interact with the tabs and their commands
· Recognize different database warning messages
· Enable content when appropriate
· Assign a password to a database
· Open and use the Trust Centre
· Open and configure the Help file
· Use the Help file to search for topics
· Browse the Help file’s table of contents
· Switch between Online and Offline Help

· Use commands on the Quick Access Toolbar
· Customize commands on the Quick Access Toolbar
· Recognize tabs, groups, option buttons, commands, and the ribbon
· Open additional dialog boxes
· Use the File (Backstage) menu
· Minimize the ribbon commands
· Commands in the Home tab
· Commands in the Create tab
· Commands in the External Data tab
· Commands in the Database Tools tab


 

3. Creating a Database                                                  4. Doing More with your Database   

· Plan the basics of a database
· Create a new blank database
· Create a database from a template
· Open and view different database objects
· Set up the Navigation Pane
· Move around in a database
· Add, edit, and delete records
· Print records
· Create a new, blank table
· Add and edit the components of a table
· Add data to a table
· Format table fields
· Zoom in and out of different database objects
· Select different database components
· Cut, copy, and paste information
· Use the Format Painter
· Use Undo and Redo
· Check your spelling
  


 


 

· Recognize the difference between bound and unbound form controls
· Create a basic form
· Create a form using the wizard
· Modify a form in Design view
· Use the Form Design Tools contextual tabs
· Use forms to view and/or enter data
· Create a query with the wizard
· Modify a query using Design view
· Use the Query Design Tools contextual tab
· Use queries to extract information from your data
· Create a report with the wizard
· Modify the layout of a report using Design view
· Use the Report Design Tools contextual tabs
· Use reports to display information
· Use Find and Replace to track down information
· Sort the data in a table or query results
· Use filters to quickly narrow large numbers of query results
· Use the different object views
· Switch between multiple database objects
· Close individual database objects
· Print database objects
· Use the Print dialog box
· Use Print Preview
· Recognize the difference between printing and exporting

Intermediate Modules

1. Advanced File Tasks                                                 2. Working with Tables  

· Navigate around your computer using Windows     Explorer
· Perform basic tasks in Windows Explorer
· Change icon views in Windows Explorer
· Use the Navigation Pane within Windows Explorer
· Compact and repair a database file
· Back up a database
· View and edit database properties
· Add or remove database passwords
· Use the Save As dialog
· Recognize different database file formats
· Package a database
· Recognize AutoRecover actions
· Export database objects in PDF, XPS, or Excel file  formats
· Export database objects to other file formats
· Use saved export steps
· Package and digitally sign a file
· Export information to older Access databases
· Link to an Excel worksheet
· Link to another database
· Link to a SharePoint site
· Recognize other forms of linking in Excel
· Create hyperlinks in a table

· View field properties
· Add a primary key to a table
· Index a field for faster searching
· Insert, delete, and move fields in a table
· Add Quick Start elements to your database
· Import a table from an external data source
· Format number and text fields
· Add field descriptors
· Change a field’s data type
· Add captions to fields
· Set default field values
· Require user input in a field
· Create and use formatting input masks
· Create and remove table relationships
· Recognize tools on the Table Tools – Design tab
· Validate data to ensure consistency
· Create and modify field lookup tables and value lists

  



3. Working with forms                                                    4. Working with reports  

· Recognize different types of forms
· Add controls to a form
· Use the Control Wizard to add controls to a form
· Cut, copy, paste, and move controls in a form
· Apply basic control formatting
· Change a control’s properties, data source, and default value
· Create a calculated control
· View and modify form properties
· Format gridlines in form Design view
· Modify fonts in a form
· Add logos to a form
· Change the form layout
· Change the colour of a control
· Modify control properties
· Align and size controls
· Apply special effects to stylize controls
· Use themes in a form
· Modify theme colour and font schemes
· Save customized themes

· Add and remove fields in a report
· Use the different sections of a report
· Change report section properties
· Group and sort the data in a report
· Use calculated controls in a report
· Modify the formatting gridlines in report Design view
· Modify fonts in a report
· Add logos to a report
· Change the report layout
· Use themes to stylize report content
· Add a photo or image to a report
· Adjust page properties for printing
· Add page numbers to a report
· Use the Label Wizard to produce mailing labels  based on report data
· Apply conditional formatting to highlight report data  based on criteria



5. Working with Queries  

· Recognize basic queries and their functionality
· Create a new query
· Sort and filter query results
· Hide and show query results
· Use the AND/OR operations in a query
· Recognize an IFF function
· Recognize multiple table queries
· Create a calculated field in a query
· Recognize features of the Expression Builder
· Use queries to summarize data in your database
· Create and use parameter, crosstab, make-table, append, delete, and update queries
· Export queries to another database  


 


 


 


Advanced Modules

1. Advanced Data Management                    2. Advanced Form Tasks  

· Use Relationship view and the Relationship Tools tab 
· Understand types of relationships
· Establish, enforce, and test referential integrity
· Use join lines
· Normalize tables
· Use the Table Analyser Wizard
· Use cascade delete and cascade update
· Set up indexing on a field
· Understand how indexing works
· Understand basic SQL, parts of an SQL statement, and SQL keywords
· Add WHERE clauses to an SQL statement
· Create a modal dialog box
· Add controls to forms and modal dialogs
· Set modal dialog properties
· Format modal dialog boxes
 


· Create, modify, and use a subform
· Synchronize subform data with a parent form
· Display a subform within a main form
· Create a navigation form
· Add tabs to a navigation form
· Create a tab hierarchy
· Modify a navigation form
· Display a navigation form when the database opens
· Limit user access to a form
· Create check boxes and command buttons
· Build command button events
· Create event procedures
· Export your form to XML, HTML, and other formats
· Send a form as an e-mail
· Use various kinds of hyperlinks in a form
· Add a browser control to a form
· Perform calculations in a form

3. Pivoting Data                                                             4. Advanced Topics  

· Recognize a PivotTable
· Create a PivotTable and add fields to it
· Perform basic tasks on a PivotTable
· Work with PivotTable data
· Hide and show data in a PivotTable
· Group PivotTable data
· Refresh PivotTable data
· Use the PivotTable Properties dialog
· Edit and format a PivotTable
· Import data from, and export data to, Microsoft  Excel
· Create a PivotTable based on Excel data
· Recognize a PivotChart
· Create a PivotChart and add fields to it
· Perform basic tasks on a PivotChart
· Modify a PivotChart
· Create a PivotChart and PivotTable from the same object
· Add axis titles and a legend to a PivotChart
· Change the PivotChart type

 

· Recover Access if there is a problem with the program
· Restore a database from a backup copy
· Start Access on Windows boot
· Repair Access 2016
· Split your database and set the appropriate options
· Set up Access 2016 for a multi-user database
· Set record locking options
· Import contacts from Outlook
· Link to an Outlook folder
· Collect data with an e-mail form and manage replies
· Recognize key features of a SharePoint server and important SharePoint terminology
· Link tables to SharePoint lists
· Move or save a database to SharePoint
· Create a Web database
· Use Web database templates
· Check a database for Web compatibility
· Publish a Web database

5. Macros and Visual Basic for Applications (VBA)  

· Create macros
· Use macros as event procedures
· Define program control with If-Then-Else statements
· Use macros in tables
· Understand embedded macros
· Add comments to a macro
· Create a submacro
· Group submacros
· Handle macro errors
· Convert a macro to VBA
· Use the VBA Editor and its tools
· Build VBA procedures
· Declare variables
· Gather information with Dlookup
· Add comments to VBA code
· Use message and input boxes
· Use the DoCmd object
· Handle VBA errors
· Use VBA with combo boxes
· Handle run-time errors
· Enable and disable form controls
· Prepare a form for a new record