Microsoft Access Database Services

We are Offering Database Solutions for Your Small Business: Powered by Microsoft Access! Contact on WhatsApp 01878-678670 (+88)

How to make a custom datasheet in Microsoft Access?

Often, datasheets are used as sub-forms at the bottom of main forms that display related data, from the same record source. So, the main form shows one record, and the datasheet shows all the records in rows having a one-to-many relationship.

𝐇𝐨𝐰 𝐭𝐨 𝐜𝐫𝐞𝐚𝐭𝐞 𝐚 𝐝𝐞𝐟𝐚𝐮𝐥𝐭 𝐃𝐚𝐭𝐚𝐬𝐡𝐞𝐞𝐭:
1. Open the Create tab in the Access ribbon.
2. Select a data table or query.
3. In the Forms group, click on the More Forms, click Datasheet. Your datasheet is created.
4. Go to Design View, then in the Property Sheet of the Form on the right side, select No beside ‘Allow Form View’.

𝗛𝗼𝘄 𝘁𝗼 𝗰𝗿𝗲𝗮𝘁𝗲 𝗮 𝗰𝘂𝘀𝘁𝗼𝗺 𝗗𝗮𝘁𝗮𝘀𝗵𝗲𝗲𝘁:
1. Open the Create tab in the Access ribbon.
2. In the Forms group, click on the Form Wizard.
3. Select the table or query that contains the data you want in your datasheet.
4. Add the fields you want to display in your form and click Next.
5. Choose the Datasheet layout option Tabular Format and click Next.
6. Give your form a name and click Finish.

Access will create a new form that displays your data in a datasheet-like view. You can then customize this form further by adding or removing fields, changing their order, and applying formatting. You see in the image; I have customized the layout and color of the datasheet.

𝐒𝐨𝐫𝐭𝐢𝐧𝐠 𝐫𝐞𝐜𝐨𝐫𝐝𝐬 𝐢𝐧 𝐭𝐡𝐞 𝐜𝐮𝐬𝐭𝐨𝐦 𝐝𝐚𝐭𝐚𝐬𝐡𝐞𝐞𝐭:
You can write VBA Event for sorting records in this custom datasheet. Add this VBA code under Click Event Procedure of the Labels of the datasheet,
𝐏𝐫𝐢𝐯𝐚𝐭𝐞 𝐒𝐮𝐛 𝐋𝐁𝐋𝐈𝐧𝐬𝐩𝐃𝐚𝐭𝐞_𝐂𝐥𝐢𝐜𝐤()
𝐎𝐧 𝐄𝐫𝐫𝐨𝐫 𝐑𝐞𝐬𝐮𝐦𝐞 𝐍𝐞𝐱𝐭
𝐃𝐨𝐂𝐦𝐝.𝐒𝐞𝐭𝐎𝐫𝐝𝐞𝐫𝐁𝐲 "[𝐈𝐧𝐬𝐩𝐞𝐜𝐭𝐢𝐨𝐧_𝐃𝐚𝐭𝐞]"
𝐄𝐧𝐝 𝐒𝐮𝐛

Need Help with Data? Custom Microsoft Access, Excel & SQL Server Solutions Available.
Contact on WhatsApp: 01878-678670 (+88)

15 High-demand Skills for Freelancing in 2025 - Surveyed by Momtaz U

I have compiled this list of the most in-demand freelance skills by searching AI, Google Gemini, a few freelance marketplaces, and a few other websites on the subject.

Here are 15 of the top skills for freelancing, based on current demand and market trends.
𝐓𝐞𝐜𝐡𝐧𝐨𝐥𝐨𝐠𝐲 & 𝐃𝐚𝐭𝐚
1. Artificial Intelligence (AI) and Machine Learning (ML)
2. Web Development/ Web tools/ Web Software
3. Mobile Apps development
4. UI/UX Design
5. Data Science and Analytics
6. Cyber Security

𝐌𝐚𝐫𝐤𝐞𝐭𝐢𝐧𝐠 & 𝐂𝐫𝐞𝐚𝐭𝐢𝐯𝐞
7. Digital Marketing (SEO, Content Marketing, Email Marketing)
8. Copywriting and Content Writing
9. Video Editing and Production
10. Graphic Design
11. Motion Graphics/Animation/3D Rendering

𝐁𝐮𝐬𝐢𝐧𝐞𝐬𝐬 & 𝐀𝐝𝐦𝐢𝐧𝐢𝐬𝐭𝐫𝐚𝐭𝐢𝐨𝐧
12. Accounting and Bookkeeping
13. Social Media Management
14. Virtual Assistance/HR Management
15. Project Management