Introduction

Microsoft Access is an application for database which a lot of companies, schools, colleges, and universities are using it in order to manage the information of their employees or students. Our project tending to make Microsoft Access easier to be used by its users by improving the security of the databases and the ease of entering the information into these databases. Nowadays the barcode scanners are popular in almost everywhere, and the QR scanners. Our project is to link a barcode/QR scanner to Microsoft Access in order to make it easier to enter the information to the databases and it will be faster. A part of our project is the security for these databases because the information in these databases must be used only by the authorized people not for everyone.

Microsoft Access has a basic security option which is encrypting the database by a password which is king of easy to hack it or break it. In order to make the hacking or braking through the password harder, we thought about linking a security device to Microsoft Access in order to keep the databases safer. In the current version of Microsoft Access, we need an intermediate software in order to link the software of the security device in order to work properly. The problem in this intermediate software is they are very expensive because they considered to be luxuries which people use it to make their work easier. We thought about providing Microsoft access with the direct ability to accept any security device which it needs to be linked to it without any intermediate software in order to make the luxuries things public to let the people use it as if it is basic things with a little higher cost for Microsoft Access. 


Microsoft Office has only one way to enter the data into the tables which is by typing the data into the form which is related the targeted table. Sometimes this way is hard for some people who are using Microsoft Access. Many people on Microsoft website were asking in their comments about a faster way to enter the information into the table because they are having hard time entering the information to the tables by typing because there are a lot of information they have to enter them to their databases, so the people were asking if the barcode/QR scanner could be able to be linked to Microsoft Access or not, and what are the requirements to link a scanner to Microsoft Access. The solution is very easy, but it is very expensive. The solution is an intermediate software has toby installed to link the software of the scanner to Microsoft Access in order to work properly then the user can choose which form will use to enter the data into it. Our project is tending to let the users to link the barcode/QR scanners without any intermediate software with a little bit higher cost for Microsoft Access.   

Microsoft Access has no dark mode option although the new updates for the other database applications provide dark mode nowadays. People like the dark mode in the applications because it relaxes their eyes when they stay a long time in front their computers. In our project we tending to provide Microsoft Access with the dark mode option in order to let the users feel comfortable while using the application, and to be able to read the information clearer than the light mode.

The good database application is the application which suits all the computer devices. Although Microsoft Access is a very good database application, apple users cannot use Microsoft Access on apple computers. It has been a big problem for many people specially students that they cannot use Microsoft Access on their apple computers because it is not supported in apple computers. Our project is to let apple computers to support Microsoft Access in order to be reachable for all the users.

Requirements

Microsoft Access is a good database application, so it deserves to be improved in order to be easier and more secure. In order to make Microsoft Access easier to be used by the users, we need to add the ability to link the barcode/QR scanner into it directly without an intermediate software. The requirements are as follows; we are going to post an update for Microsoft Access which will contain a built-in software to link the scanner device directly to Microsoft Access. The built in software will let the user to choose between the forms which related to the deferent tables in the database in order to let the user scan the barcode or the QR code in order to enter the data into the targeted form. The software will also let the user to choose the way by which he/she can enter the data with; the choices will be between entering the data by typing or entering the data by the scanner. The software will ask the user if he/she wants to keep a default form when starting the data entry proses, or the user must choose every time between the forms in order to get every data in its suitable table.


Microsoft Access has a basic security system which is encrypting the database to be unlocked by a password. Our project is to add the ability to Microsoft Access to link security devices without an intermediate software. We need to post an update to Microsoft Access which has a built-in software to let Microsoft Access to link with the security devices directly. There are many security devises such as the fingerprint reader, the face identification device, the tooth identification device, the eye print reader, and a proxy card reader. The built-in software will ask the user if he/she wants to encrypt the database by a password as the basic way or to use the security device to encrypt the database by ether ways according to the security device by putting your fingerprint to encrypt the database and also use your fingerprint to unlock the database to open, or by any way which the security device provides you to encrypt and to unlock the database. The built-in software will ask to add one or two as maximum persons to be the administrators to save their identities because it cannot be open for everyone in order to keep the databases safe abs accessible by the authorized people only.

Most of the updates for database applications provide the dark mode to their users. In order to provide Microsoft Access with the dark mode option, we need to post an update for Microsoft Access which provide the users with the dark mood option. Microsoft Access will ask the user if he/she wants the appearance to be on the dark mode or on the light mode when the user start setting up his/her account on Microsoft Access then the user can later change the appearance from the settings of the application when the user wants.

Many people epically the college students facing problems when they try to use Microsoft Access on their apple computers because Apple computers do not support Microsoft Access. We will design a software on Appstore studio which will let Apple computers to install Microsoft Access without facing any problems like the Android Emulators and IOS Emulators on the computers which they allow the users to install the Android applications and IOS applications on the computer, so the software which we will design will be on the same way of these applications, but it will be designed to install Microsoft Access on Apple computers easley.

Please fix the combo box RowSource datatype binding bug.

The bug is as follows:
1. Create a table [Table1] with two columns:
- [NumberField], datatype: Number, Double
- [TextField], datatype: Short Text

Add 1 Row to the table:
[NumberField] = 10
[TextField] = "Some Text 10"

1. Create a combo box:



2. Set the RowSource of the combo box to this:
   SELECT NumberField, TextField FROM Table1;




3. Add a Button to the form: [cmbErrorExample]
   Add On Click Event:
   If Me.cmbErrorExample.RowSource = "SELECT NumberField, TextField FROM Table1;" Then
   Me.cmbErrorExample.RowSource = "SELECT TextField, NumberField FROM Table1;"
   Me.cmbErrorExample.DefaultValue = "Some Text 10"
   Me.cmbErrorExample.Value = "Some Text 10"
   Else
   Me.cmbErrorExample.RowSource = "SELECT NumberField, TextField FROM Table1;"
   Me.cmbErrorExample.DefaultValue = 10
   Me.cmbErrorExample.Value = 10
   End If

Now open the form:
Drop the combo box, you should see the one row with values:
10 | Some Text 10
Select the row - the value of the field becomes 10.

Now, click the button. The Rowsource should change to:
"SELECT TextField, NumberField FROM Table1;"

However, if the user has already made a selection as instructed above, error appers:

Error Occurred in Sub cmdToggleRowSourceClick of Module FormForm1

Error The value you entered isn't valid for this field.

OK

Expected: the code should be able to programmatically change the Rowsource of the combo box.

Actual: Because the unbound field has had a numeric value assigned as a value, the programmatic change of the RowSource of the combo box to a text value results in a type mismatch that should not be happening.

This used to be possible in Access 2003, but in Access 2019 the combo box appears to change itself to be bound to a numeric data type, even though it is an UNBOUND field.

This is a problem when creating forms that change combo box data sources programmatically.

This URL contains a .accdb with a sample form that demonstrates the issue:
https://1drv.ms/u/s!AhezOlimTLoah-V27m77K4MRlU5loQ