Microsoft® Access 2010 Specifications
Microsoft Office Access includes objects that can be used in the development and operation of a database management system. These are divided into two main groups i.e. database specifications that entails tables, queries, forms, reports, macros and modules and project specifications that revolves around SQL server, forms and reports, access projects and macro. Discussed in this article are:
- Database specifications
- Project specifications
The table is the object that is used in the storage of records within the database. It consists of field names, field data types, field descriptions and field properties. Field names are used to describe an entity’s attributes and can consist of upto 255 fields in a table and up to 64 characters in a field name. The overall table size is 2 GB exclusive of the storage space needed for the system’s objects. Queries are objects that are used to return values based on the user’s criteria. The attributes in a query includes the number of relationships defined that can go up to 32 per table. Within the record set, a maximum of 255 fields can be defined. Forms are the interfaces between the database management system and the user. They are the means by which data is entered for storage in the tables i.e. they provide a means of interaction in the database. The main form attributes are design layout, nested forms, labels and text boxes. Last but not least, forms are created to display information output either in soft copy or hard copy. The report attributes are more or less the same as the forms.
The project specification tools are used when the user wants to use access as the primary software to design an information system. Macros are used to automate actions or set of tasks i.e. opening forms, running queries and calculations. They can make use of conditions i.e. criteria for searching or filtering data. The numbers of actions that can be performed are 999 where as the number of characters that can be used in condition or action arguments are 255. A much improved macro designer enables the user to easily create and amend macros, and automates the process of designing database logic. It aids users to alleviate the chances of making coding errors, thus fewer errors. The result is a more resilient and robust application. Forms and reports can be automatically generated with defined attributes and arguments by allowing the user to define the components of the database i.e. entities and attributes.
With the application, the user can do more tasks within a short period of time thus increasing a user's productivity. The improved backstage view makes it possible for all features and database tools to be easily available to the developer.
iYogi is the fastest growing online and remote tech support provider in the direct-to-consumers and small businesses sector. Our highly skilled and experienced tech experts available, 24x7x365 can provide the best issue resolution and customer satisfaction.
- Comprehensive support for Microsoft Access 2010 Specifications
- Diagnostic & repair for your technologies
- Troubleshoot software errors
- Update drivers and security to protect against online threats
- Connect to Internet, devices and peripherals
- Optimize your computer&supl;s speed and performance.