Here I will refer to some of the most important and useful PDF eBooks and Notes that you can download for free!
Welcome to ‘Computer Operator Exam Preparation Session’. Today on this first post of this series, I‘d like to point you to some essential eBooks and notes on Access. Because the contents on these materials matches to our requirement I will be following them for practice Quizzes and Mock Up Exams.
Oh! Did you register in http://quiz.icttrends.com ? If not do it soon. Each quiz will be online only for a week and withdrawn after that time. There will be active quizzes that you can attempt once.
Before jumping to the study materials, lets look at the topics that we need to study. Following is an excerpt form syllabus:
- Introduction to Data, Database and DBMS
- Basic concept of Tables, Fields, Records, relationship and Indexing
- Introduction to database application
- Data Types
- Creating, Modifying & Deleting Tables and Formatting & Validating Field Data
- Creating, Modifying, Deleting & Using Simple Queries
- Creating Modifying & Deleting Forms / Reports / Macros
Looking at the syllabus, it is focused on Tables, Queries, Forms, Reports and Macros, apart from the basic knowledge of databases and management system.
Well, Now, the study material for Access:-
1. Microsoft Access: Short Questions and Answers with Illustrations – Part 1
I had composed a PDF file on MS Access a couple of years back to present the basic and essential terminology and concepts. This note should be your first venture. It is in questions and answers format and tried to present as many illustrations possible to clarify the concepts.
2. Introduction to Microsoft Access
Montclair State University hosts two very nice PDF files on MS Access and this ‘Introduction to Microsoft Access’ is one of them. The ebook talks about the basic ideas and skills of using Access – creating tables, data types, Setting Primary Keys, input masks, view and navigate tables, sorting records, queries, defining criteria in queries, creating forms using wizards, design views, creating and printing reports.
So, this eBook covers a good scope of the topic we need to study. I recommend you to download this eBook and go through it carefully. We will be having quiz on this eBook.
3. Microsoft Access Intermediate
This is another pdf file published by Montclair State University that continues the topics from previous eBook. It talks about using multiple tables, creating relationship between tables, referential integrity, working with related files, editing relationship, Working with queries, using ‘AND’ and ‘OR’ in queries, parameter query, calculated query, the make table query, the append query, importing tables, create forms using wizards, moving, aligning and sizing controls, creating summary report.
I strongly recommend to download both of these pdf files and read thoroughly. Each of the concepts and skills talked there are a must for any candidate of Computer Operator Examination.