On successful completion of the course, delegates will be able to design tables, setup relationships, produce complex queries and create forms and reports using the Wizards.
DurationOverview
On successful completion of the course, delegates will be able to design tables, setup relationships, produce complex queries and create forms and reports using the Wizards.
Prerequisites
Prior experience of Windows
Course Content
Introduction to Databases
Examine Database Concepts?
Understanding the main concepts of a Database e.g. Records, Fields
The advantages of a Relational Database
The Access Environment
Explore the User Interface
Explore the Ribbon
Navigation Pane
Customize the Access Environment
Obtain Help
Access Terminology
Table, Form, Report, Query, Dynaset, Objects
Creating a database
Creating a database
Creating objects
Opening and closing the database window
Tables
Designing the structure of a table
Creating a table
Adding and deleting fields
Designate primary fields
Saving and modifying the table
Field properties
Setting display formats
Setting default values
Validation checks
Indexing
Relationships
Creating 1:many and 1:1 relationships
Datasheets
Adding records
Navigating within the datasheet
Modifying and deleting records
Customising
Sorting
Freezing Columns
Finding Records
Finding records
Using Filters
Different Filter Types
Query Basics
Introduction to queries
Creating a query
Adding fields to a query
Moving between the query window and its dynaset
Saving, closing and opening a query
Selecting all fields for a query
Moving, inserting and deleting fields
Changing data in a query’s dynaset
Forms for queries
Advanced Queries
Overview of basic Queries
Specifying criteria
Joining fields
Queries with multiple tables
Calculations within Queries
Creating a Parameter field
Designing and Enhancing Forms
Why create a form?
Creating forms using the Form Wizard
New WYSIWYG forms design interface
Customising forms further
Overview of creating forms manually and using the Wizard
Adding labels and fields
Adding Combo boxes and List boxes
Adding Option boxes
Modifying the layout using lines, rectangles and colour
Inserting calculated fields
Looking up a value from another table – Dlookup
Adding macro buttons
Printed Reports
Why design a report
Using the Report Wizard
The Report Designer
Overview of creating a report
Calculated controls and statistical fields
Sorting and grouping data
Improved Grouping Pane
Including graphs in reports
Organising reports
Creating a mail shot from a report
Printing tables and forms
Modifying the print setup
Interactive Report Browse
We’ve been providing successful training and development programmes since 1996 and we love it! We get a buzz from the altruistic sense of genuinely helping people, of unlocking potential and helping individuals, teams and organisations to be the best that they can be!
At Elliott Training we believe that at the heart of any business there must be a focus around culture, passion and the desire to make a difference. As one of the UK’s leading training companies, we’re passionate about the power of training.
We know your people are your biggest asset, so we use all our knowledge and experience to create award-winning training programmes that inspire your people and enable your business ambitions.
It is our fundamental belief that an organisation is only as good as its people. Creating a balance that combines the correct depth and blend of skills is fundamental to the achievement of goals within your business. We align our programmes to your organisational values, culture, vision and strategy; making sure you have the right people, with the right skills at the right time.
We have a wealth of experience gained from our extensive work within Leadership, Management and Customer Service. We will work closely with you to identify the successes, strengths, best practices and gaps that are delivering current results before putting together a programme to address area’s where improvement in skills, behaviours and knowledge can be encouraged.
Our approach to training and development is to make a difference. We develop programmes that inspire people to think differently, behave differently and continue to make a difference when they return to the workplace
Whilst all our work is underpinned by the best that psychology and business brains have to offer – it is translated into memorable and usable tools and techniques for everyday use in business and in life. We’re unashamedly eclectic in our use of theories and concepts – we take the best from all schools of thought and create what feels right.
A working knowledge of Windows is required, or our Introduction to MS Windows course. No experience of MS Excel is required. BENEFITS At the end of this course you will have a good working knowledge of Excel basics.
We can provide Microsoft Visio training to users of all experience levels. Our courses help delegates to build the skills needed to create professional-looking diagrams which can help get their point across and communicate more effectively through visual media.
This course is designed for people who wish learn the basic operations of Microsoft Word to perform their day-to-day responsibilities and who want to use the application to be more productive in their work.
Our Advanced Excel training course will provide you with the knowledge and skills to use Microsoft spreadsheet programme to an advanced level.
n site Microsoft Word courses tailored to your needs, designed for businesses and professionals. All Microsoft Office Word versions including 2003, 2007, 2010, 2013, 2016 and Office 365 covered.
About Coursetakers.com
Coursetakers.com is more than a decade old course aggregator and Online course platform that helps students find courses and compare course prices from Training providers in the UK, by just submitting their inquiry through the website. Coursetakers also helps Institutes, Universities and Online Instructors market their courses, gain leads and get more students to enroll into their courses.
© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy
Online
USA
UK
India
UAE
South Africa
Canada
New Zealand
Australia
Malaysia
Singapore