Queries: This object class is meant to create the SQL compatible query statement with or without the help of GUI to define tables, store data and retrieve both data and information. For example, every entry in a field called “First Name” would be a name, and every entry in field called “Phone_Number” would be a Phone number, ask questions about information stored in your tablesĢ. Every piece of information store within a field is of the same type. Every cell in a given row is part of that row’s record. In Access, rows are referred to as Records and the columns are referred to as Fields (attributes).Ī record represents a unit of information. It is used to store the data in the database. Tables: This object class allows a database designer to create the data tables with their respective field names, data types and the data properties to store the data. There are four main objects in Access 2010:ġ. However, you are suggested to refer Chapter number 4 of the book entitled “Fundamentals of Computers and Information System” before proceeding to this chapter for better understanding. This chapter emphasizes upon the different objects Tables, queries, forms and reports of MS Access. Supporting multiple views of data and information.Providing for data sharing and multi-user transaction processing.Flexibility to create multiple user interfaces.Allowing fast retrieval of data with or without processing by using SQL.Restricting unauthorized access to database. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |