"Student teacher ratio is very good. Explanation and doubt clearing was very good and understandable".
A successful database is efficient quick accurate and easy to use. This course covers how to create such a database with MS Access.
|Course Name||Duration||Entry Requirement||Fee (SGD)|
|MS Access||15 hrs||Basic Computer Knowledge||S$290|
- What is access
- Introduction to Database
- Relational Database management system
- Introduction to Database objects
- Components of Access User interface
- Ribbon, Navigation pane, Back stage view
- Creating new blank Database
- Closing Database
- Creating Database from Template
- Opening an existing Database
- Backing up Database
- Viewing object, Copying object
- Renaming Object, Deleting object
- Planning Tables
- Planning fields
- Creating tables in Design view
- Modifying Tables in Design view
- Selecting a primary key
- Importing data from excel into new table
- Importing data as a linked table
- Relationship types
- Creating relationship in database
- Creating look up field
- Viewing related data
- Creating Query in design view
- Creating Query with Query Wizard
- Modifying Queries
- Adjusting Query field
- Sorting Query field
- Hiding Query field
- Adding Query criteria
- Adding calculated field to Query
- Creating crosstab Query
- Form views
- Creating form with form Wizard
- Working with forms in design view
- Working with forms in Layout view
- Working with padding, Margins and Anchoring
- Report sections
- Designing a report
- Report views, print view, and layout view
- Using the report tool
- Working with reports in layout view
- Working with reports in design view
- Creating blank report
- The field list pane
- Grouping and sorting report
- Previewing and printing reports
No data found
Request For Brochure
Frequently asked questions
"The instructor is friendly and approachable. The course is taught in a detailed and structured way".
"The institution is well organized and show good response. C advance course covered all the relevant topics well".
"The trainer was patient and willing to pass his knowledge on other area as well".
"Next time I want to do another computer course I will definitely consider G-tec".
"The trainer is very patient. He doesn’t mind to keep repeating the same step. I am total new to the Autocad and ...
"The course is great and the trainer is having good knowledge in the topic. It will help me a lot in my upcoming ...
"My experience here was good. I hope that when I will have training I will come here."
"It is interesting for everyone to join the class .Good environment for learning."
"Patient teacher and staff great learning environment with sufficient facilities. Managed to have a thorough knowledge of Java".
"Other institutes don’t co-operate so much if somehow a student is unable to complete the course. But G-TEC has a very co –...
"Easy to understand concise . Friendly staff would recommend joining the course at G-TEC".
"Comprehensive course and cost effective".
"Contents in the Web designing course is detailed and benefited to me in my learning journey. The teachers are nice and helpful. G-TEC ...
" It is easy to follow and help you familiar with the fundamentals of C#.NET".
"G-TEC provides a good trainer qualified. It was a good learning experience in G-TEC for C#.net".
"The Java/J2ee course material was well presented and very helpful for my work. I really got a great amount out of ...
“I will encourage everyone to come for the Ms Office Basic course as the lessons are relevant to work. Teachers are willing to ...
"This is the best institution I found in Singapore. Because here the trainer as well as training was good. The trainers are very ...
"The VB.Net advanced training form G-TEC is very detailed and interesting training. The trainer is patient and willing to share her knowledge. ...
"Singapore is a great place to study and to work.And I'm glad, I came here through G-TEC COMPUTER EDUCATION CENTRE.Apart from ...
"G-TEC Computer Education Centre has provided me a golden opportunity to learn programming in depth and at my own pace. My trainers have ...