Member Avatar for WhitePunk

i just wanna ask if it if possible to make columns n ms access and how...
because i am making a personal data sheet

thanks in advance
more powers and God Bless You all

  • 2 Contributors
  • 1 Reply
  • 78 Views
  • 13 Hours Discussion Span
  • Latest Post Latest Post by MidiMagic

Dani AI

Generated

asked about making "columns" in Access and correctly asked what kind of columns were meant. "Columns" can mean three different things: table fields (the columns that store data), layout columns on a form (controls placed side-by-side for a single record or for editing), or newspaper-style columns on a printed report (multiple columns per page). For a personal data sheet, the usual pattern is: store fields in a table, use a bound form for data entry/editing, and use a report for printing.

Typical, version-independent steps:

  • Table fields: Open the table in Design View, add field names and data types, save. In Datasheet View those fields show as column headers; headers can be dragged to reorder and right-clicking a header exposes "Unhide Columns".
  • Form layout: Build a bound form (Form Wizard or Design/Layout View). Arrange controls into side-by-side groups using the layout tools (Tabular vs Stacked) or by dragging controls into columns. Use a single-record form for a personal data sheet.
  • Multi-column report (printing): Create a report and set the page/format properties for multiple columns (column count, width and spacing). Control whether records fill down then across or across then down using the report column layout setting.

Practical cautions: do not store repeated data in multiple numbered columns (Phone1, Phone2). Normalize into a related table instead. For exact, step-by-step UI clicks it helps to know the Access version being used, since menu names differ slightly across releases.

Member Avatar for MidiMagic

Columns of what, in what kind of file?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.