BSBITU301 Create and use databases ICTDBS403 Create basic databases
Upon completion of this course you will be able to work confidently with an existing Access database including building custom queries forms and reports and design and build a simple database consisting of a small number of tables following sound principles of relational design
1 Understand fundamental database concepts and determine if Access is an appropriate tool for specific information processing tasks
2 Work with Access files
3 Create basic tables
4 Create basic data entry forms
5 Design and use select queries
6 Design and build simple reports
7 Build macros
8 Import and export data
9 Understand table relationships
10 Understand the general principles of normalisation
11 Build link and use lookup tables
12 Work with multiple data sources
13 Design forms and reports
14 Create a navigation form
15 Backup and maintain a database
Optional Assessment This is a nationally recognised training program
Participants who successfully complete the optional assessment component of this course will receive a Statement of Attainment for the units of competency outlined above additional fee applies please enquire when you book Exercises completed during the course will be used as evidence towards unit competency
Participants who choose not to be assessed will receive a Certificate of Attendance
Those attending this course should be familiar with personal computers and be competent in the use of the keyboard and mouse
(03) 6334 4910
Level 3/110 Collins Street, Hobart TAS 7000
Business owner Manager Project Manager Director Trades People Tradesman Administration Accounts Payroll Receptionist Builder Plumber Electrician
From Aug 9th at 12:00 AM
to Aug 10th at 12:00 AM
This course is also available subject to customer demand.
Contact the training provider for more information.
14 hours per attendee
NDA Computing Pty Ltd
NDA services include computer training, management training, traineeships and qualifications, group training and training room hire. The company has training centres in Hobart, Launceston, and Devonport. NDA is 100% Tasmanian-owned and was established in 1985.
The services provided by NDA include:
Computer training - desktop, web, systems, programming and accounting software. Management training.
Traineeships and qualifications in business, business administration, human resources, training and assessment, frontline management, IT and project management.
Group training - the supply of NDA trainees who work in your organisation.
Training needs analysis.
Project management of training roll-outs.
Courseware development and technical writing.
Training room hire.
NDA is accredited by the ASQA as a Registered Training Organisation.
NDA is accredited by Skills Tasmania as a Group Training Organisation.
NDA operates from training centres in Hobart, Launceston, and Devonport.
(03) 6334 4910
Training providers are solely responsible for the quality and accuracy of content and delivery of training courses listed on the Industry Training Calendar. Keystone Tasmania provides the Training Calendar in good faith as a service to industry practitioners. Please note that by taking the option of applying for funding you are not securing a booking for the selected course. All bookings must be made directly with the training provider.