Use a screen reader to create tables in Access desktop databases

You can use a screen reader and keyboard shortcuts to add tables to an Access desktop database.

Note This topic assumes that JAWS users have the Virtual Ribbon Menu feature turned off.

In this topic

Overview

Tables are essential objects in a database because they hold all the information or data. For example, a database for a business can have a Contacts table that stores the names of suppliers, email addresses, and phone numbers. Before you create tables, consider your requirements and determine all the tables that you might need. For help planning and designing a database, refer to Database design basics.

A relational database, like Access, usually has several logically connected tables. In a well-designed database, each table stores data about a particular subject, such as employees or products. A table has records (rows), fields (columns), and field values (cells) for each record.

  • A record (row) contains specific data, like information about a particular employee or a product.

  • A field (column) contains data about one aspect of the table subject, such as a first name, email address, or price.

  • A field value (cell) for a record contains different types of data, such as text, numbers, dates, and hyperlinks.

Although each table stores data about a specific subject, the tables in a relational database such as Access store data about related subjects. For example, a database might contain:

  • A Customers table that lists your company’s customers and their addresses.

  • A Products table that lists the products that you sell, including prices and pictures for each item.

  • An Orders table that tracks customer orders.

To connect the data stored in different tables, you create relationships. A relationship is a logical connection between two tables that have a common field. For information on creating relationships between tables in an Access desktop database, refer to Create, edit or delete a relationship.

Add a table

  1. Open a new or existing database.

    Tip Your screen reader may not start reading until a table is open. If you open an existing database with no open tables, press Enter. The top table in the Navigation pane opens.

  2. Press Alt+C, T+N. A new table is added, and you hear “Leaving menus bar, Table X.” (In Narrator, you hear "Table X.") The focus in the first cell of the second field. (The default name of the first field is ID.)

  3. Enter data in the table or paste data in the table from another source, like an Excel workbook. When you enter a field value in the new field and move to the next field value, Access automatically names the field Field X.

  4. To rename a field (column) header in the table:

    1. To select the field, place the focus in the field and press Ctrl+Spacebar.

    2. To open a shortcut menu, press the Application key (usually found in the lower-right section of the keyboard) or Shift+F10.

    3. Press N. The focus moves to the field header, and you hear “Leaving menus, Datasheet, Row X,” the name of the field, and “Type and text.” Enter a new name for the field.

    Tip Meaningful names help you know what each field contains without seeing its contents, for example, Product name or Price.

  5. To add a field (column) to the table:

    1. To move to the first record of the table, press Ctrl+Home.

    2. To move to the last record of the last field in the table, press Ctrl+End.

    3. To move to a new field, press the Right Arrow key.

    4. To move to the first record of the new field, press Ctrl+Up Arrow.

    5. Enter your data. When you move to another cell, the new field is added with the default name Field X.

Save a table

After you create a new table or modify an existing table, you should save it.

  1. To save a table, press Ctrl+S or Alt+F, S or Alt+H, K+S.

    When you save a table the first time, the Save as dialog box opens and you hear “Save as, Table Name colon, Edit, Type, and Text” and the name of the table.

    Tips

    • If you try to close a table before saving it, a dialog box automatically appears and you hear “Do you want to save changes to the design of table Table X?” The focus is on the Yes button. To save the table, press Enter.

    • When you save changes to an existing table, the table is assigned the name your previously gave it. To rename the table when you save it, press F12. The Save as dialog box opens, and you can enter a new name.

  2. In the text box, type a name for the table. When you save a table for the first time, give it a name that describes the data that it contains. For example, you might name a table Customers, Parts Inventory, or Products. Access gives you lots of flexibility when it comes to naming your tables in web apps, but there are some restrictions:

    • A table name can be up to 64 characters long.

    • It can include any combination of letters, numbers, spaces, and special characters except a period (.), exclamation point (!), square brackets ([]), leading space, leading equal sign (=), or nonprintable character such as a carriage return. The name cannot contain any of the following characters:` / \ : ; * ? " ' < > | # <TAB> { } % ~ &.

    • The name cannot contain any of the following characters:` / \ : ; * ? " ' < > | # <TAB> { } % ~ &.

    Tip Decide on a naming convention for the objects in your database, and use it consistently.

  3. Press Enter.

Rename a table

Note You cannot rename a table when it is open. To close an active table, press F6 or Ctrl+W. The focus moves to the Navigation pane, on the table you closed.

  1. In the Navigation pane, to select the table you want to rename, use the Down Arrow key.

    Tip To access the tables in the Navigation pane, you may have to press the Tab key.

  2. To open a shortcut menu, press the Application key (usually found in the lower-right section of the keyboard) or Shift+F10.

  3. On the shortcut menu, press M twice and then press Enter. You hear “Leaving menus, Rename text box, Edit.” (In Narrator, you hear "Rename text box" and the current name.)

  4. In the text box, type the new name and press Enter.

Delete a table

  1. In Datasheet view, close all tables. The focus shifts to the Navigation pane. To select the table you want to delete, use the Down Arrow key.

  2. Press Delete. A window opens asking you to confirm the deletion, and you hear “Do you want to delete the Table X?”(In Narrator, you hear "Microsoft Access dialog, Yes button.") The focus is on the Yes button.)

  3. To delete the table, press Enter.

Note When you are in Design view, to switch to Datasheet view, press Alt, J+D, W, and then H. To switch to Design view when you are in Datasheet view, press Alt+H, W, and then D.

Technical Support for customers with disabilities

Microsoft wants to provide the best possible experience for all our customers. If you have a disability or have questions related to accessibility, please contact the Microsoft Disability Answer Desk for technical assistance. The Disability Answer Desk support team is trained in using many popular assistive technologies and can offer assistance in English, Spanish, French, and American Sign Language. Please go to the Microsoft Disability Answer Desk site to find out the contact details for your region.

If you are a government, commercial, or enterprise user, please contact the enterprise Disability Answer Desk.

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×