Introducing
Your new presentation assistant.
Refine, enhance, and tailor your content, source relevant images, and edit visuals quicker than ever before.
Trending searches
Group 4
Tanashay Cheddesingh
Akeen Williams
Andre Laing
Brandon Chin
Solid Rock Lifeco is an Assurance company that offers insurance to the Jamaican populace. Solid Rock wishes to recognize and reward employees who are outstanding performers. The company has decided to offer a few units in an upcoming housing development to a top insurance advisors. Top insurance advisors are those employees who have accumulated the highest number of points in terms of sales for the previous year. To be eligible employee has to be a top advisor and has to earn at least 50,000 points.
The Manual system tends to be time consuming
Is Prone to Frequent error in Calculation
Any business that uses more than 2GB will discover limitations with MS Access. If you’re a large corporation or department, Access may not be big enough for you.
Corruption
For as long as its inception, MS Access has been vulnerable to corruption. Though it’s not likely to occur, the fact that it can (and does) happen makes people untrusting.
Limited Users
Size
You can improve performance and application maintainability by splitting your Access database into two databases. The "application" part of your database holds all objects except tables, and is linked to the "data" part that contains the actual tables.
Corruption
The best thing to do is work with an Access support company. When you understand how to use the database correctly, the chance for corruption is low.
Limited User
A few tips to improve the effectiveness of your database
Related tables with one-to-one or one-to-many relationships should implement referential integrity with cascading deletes and/or updates to ensure orphan records are not created. With cascading deletes, the removal of the parent record, automatically deletes the child records in the corresponding table.
Where possible, limit the number of fields returned by a query. This results in faster performance and reduced resource usage.
Ensure that every table in your database have a primary key. This allows your database application to quickly locate specific records. Additionally, you cannot create secondary indexes on a table's fields unless that table has a Primary Key.
Choose the best data types for your fields. By choosing the optimal data type, you can decrease both the disk space used to store data, and the time it takes Access to retrieve, manipulate, and write data. The general guideline is to choose the smallest data type possible to store a particular type of data.
You can significantly increase the performance of opening tables, forms, and reports that are based on linked tables by having Microsoft Access keep the linked table's database open. To do this, open a Database variable in Visual Basic code using the Open Database method. Keep this variable open as long as your application is running. This forces Access to keep that database open, making access to linked tables much faster.