Buzz
Microsoft Access is a relational database management tool developed by Microsoft. Access is commonly used to design simple databases with all management features through tables, queries, etc. Each data field will be selected from available data templates and a primary key will be chosen for each table. With a simple and intuitive interface, you can immediately create tables containing data in no time.
With support for many editing and customization functions, users can directly modify databases as desired without too many operations or having to use complex database management tools like SQL Server. In addition, Microsoft Access also has good compatibility with many programming languages such as Visual C++, PHP, helping you save more time when working with simple databases. Here are some customizations to make Access more convenient.
Modifying Table Design
Adding, Editing, Deleting Data Fields
Users can directly edit data fields in the table by switching the database to table format by clicking the View button and selecting Design View
In Design View, you can quickly add data fields by right-clicking on any existing data field and selecting Insert Row
Adding an Empty Field to the Table
Editing a data field is simple; just select the field to edit, and make changes directly
To delete a data field, select the field to delete, and press Delete Row
Changing Data Types
Each data field will be associated with a different data type. Each data type will have its own attributes, and you need to select the correct data type for each data field. This is quite crucial because placing the data type correctly not only reduces the load on the management system but also affects user data input.
Short Text : Concise Terminology
Long Text : Extended Writings
Number : Numeric Data
Date/Time : Date and Time
Currency : Monetary Value
AutoNumber : Automated Number, Access will automatically fill in this data field, commonly used for ID
Yes/No : Logical Data, check Yes or No
OLE Object : Multimedia Object, Audio or Image, Graphics
Hyperlink : Super Link, can navigate to other documents or different URLs
Attachment : Attached File
Calculated : Spreadsheet Data, used when the data field is the calculated result of other data fields
Custom Data Type : Proactively add custom data types
Add Data Annotations
For each data field, there always exists a Description column, database creators can utilize this annotation column to note important aspects of each data field. The data in this annotation column does not affect the data in the table.
Data in the annotation column is of type Long text
Data Formatting
Each data type will be formatted according to the database creator's custom rules. You can customize the display of data types in the Format table below
Here are some tweaks for you to use Microsoft Access more easily. You can also install two Office versions on the same machine to avoid conflicts in case you want to use multiple versions on the same computer for work purposes.
