Microsoft Office Access

Microsoft Office Access

____________________

Data Base: A collection of data items and the links between them that is organised and stored so that it can be interrogated.

Field: A place used to hold a single data item within a database.

Record: A collection of field containing information about one data subject or one object within a database.

Primary Key: The key which uniquely identifies each record. It can be of a normal attribute or it can be generated by the DBMS.

Table: A two-dimensional grid organised by rows and columns within a database. Each row of the table contains a record. Each column represents a field.

Query: The primary mechanism for retrieving information from a database and consist of questions presented to the database in a predefined format.

Report: A database report presents information retrieved from a table or query in a pre-formatted, attractive manner.

Validation Rule: A rule that controls property works to require a specific value or character.

Data Types: A characteristic of a field that determines what kind of data it can store.

How to reduce entry errors?

1. Add lots of edits to programs.

2. Allow prompting on important fields for help texts.

3. Store options in tables.

4. Do not allow incorrect entries.

5. Compare entries to the table, if not there, do not update but display error message.

Read More

e-Passports & e-Kiosks

e-Passports & e-Kiosks

e-Passports:-

 

Different Models of e-kiosks:-

CHS 110

CSH 110: CSH 110 has been developed for entities who offer collection services such as card top up and bill payments. It allows customers to make all their payments by means of banknotes, coins or credit/bank cards.

INF 130: Standing out in projects where mobility is a priority, INF 130 eliminates sharp corners to harmonise with the the atmosphere. 

INF 130

IDS 210: IDS 210 has been designed to showcase the product in the store with the most up-to-date information and to present it to the customers in an eye-catching way. It allows the customers to have up-to-date information of products and to compare the features of selected products at the same time.

IDS 210

 

END 220: Designed for use not only in production facilities, but also in technical services, infrastructure units located in worksites, production and control centers in outdoors; END 220 covers the least possible area in the production. It can be easily transported and it has a design suitable for transportation by a forklift when needed.

END 220

 

Monolith:  Monolith delivers your messages wherever they may be. It draws attention of visitors by displaying company promotion videos, presentations, information announces, and similar visuals on quality displays and contributes to brand reputation.

Monolith

Touch Desk: Standing out with its ergonomic design, 42” Touch Desk is a unique product to present special effects apart from its interactive advertising, entertainment and play functions. 42” Touch Desk can be used in many areas such as retail sales offices, stadiums, corporate event areas, meeting rooms, stores, presentation centers, restaurants, hotels, fairs, and interactive marketing areas.

Touch Desk

 

 

 

 

 

 

 

INF 110: Designed for places with restricted application areas, INF 100 can easily be positioned in any place, even in the narrowest areas thanks to its slender and tall structure. Modular structure of INF 110 supports the multipurpose use feature. Used for general information with its 19" touchscreen display, the Kiosk becomes suitable for advertising or CCTV by adding a second 19" display.

 

CHS 210: Developed for companies that offer collection services like prepayment and invoice payments, this solution allows customers to make all their payments by means of banknotes, coins or credit/bank cards. Thanks to its user-friendly interface the CSH210 can perform any function normally carried out at cashier desks.

CHS 210

Read More