This course assumes no previous experience of database design. However, delegates with some experience in database design will find this course beneficial if they do not know Access.
DurationOverview:
This course assumes no previous experience of database design. However, delegates with some experience in database design will find this course beneficial if they do not know Access.
Introduction to Databases
Database concepts
Database Layout
Launching Access.
The Access Menu System
Dialog Boxes
Getting Help
Creating A New Database
Creating an Access Web App
Closing A Database (Vs Exit Access)
Opening A Database
Tables
Database Design.
Creating Tables Using The Table Wizard
Creating Tables In The Datasheet View
Creating Tables In The Design View
Data Types
Field Properties
Data Display Format Vs Input Mask
The Input Mask
Data Entry Problems
Moving And Copying Records
Working with Tables
Pasting Records
Sorting The Table
Deleting A Table
Table Layout Changes
Find
Replace
Wildcards
Queries
The Simple Query Wizard
The Design View
Modifying The Query
Using Basic Criteria
Additional Criteria
Parameters
Multiple Object Queries
Custom Calculations In A Query
Calculating Fields Continued
Grouping Fields
Introduction to Reports
Reports
The Report Wizard
We are a Scottish SME on a mission to be the only training provider your company will ever need. To date we’ve run over 9,000 courses in more than 1,100 organisations, across public and private sectors. 96% of course attendees rate their training experience with us as excellent or very good.
This course is for those who are able to use a computer to create and save files and want to develop their spreadsheet skills.
This course introduces delegates to the basic functions of Microsoft Excel and will enable them to create worksheets and perform formatting and functions within the worksheet.
It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications.
Microsoft Visio is a dynamic application of Microsoft Office mainly, which is used mainly for drawing flowcharts, diagrams, and vector graphics.
This one-day course is suited to delegates who have a working knowledge of Excel and have sat an Intermediate Course, or need to learn the specific areas covered below.
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