Capitalize the first letter of each word in a field name that combines multiple words, for example Visit.A field name cannot begin with a space.), exclamation mark (!), grave accent (`), and square brackets () A field name can consist of up to 64 characters, including letters, numbers, spaces, and special characters, except for the period (.Keep the following guidelines in mind when you assign field names: ) Decision Making: Naming Fields in Access Tables One of the most important tasks in creating a table is deciding what names to specify for the table’s fields. These features help make Microsoft Access one of the easiest database systems to learn.Creating a Table in Datasheet View XP (Cont. It also provides an easy way to create forms for data entry, and reports for emailing and printing.Īccess even provides “wizards” that guide you through some of the most common tasks. It allows you to create and maintain relational databases.Īccess provides an easy way for non-technical users to start building databases. Microsoft Access (commonly referred to as “MS Access” or just “Access”) is a relational database management system (RDBMS).

Create a macro (so that a multi-step task can be done automatically – at the click of a button).Create a query (so you can “search the database”).Microsoft Access Tutorial (Part 3): Queries, Forms, & Macros Set up a relationship between three tables.Add two more tables (for the relationship).Microsoft Access Tutorial (Part 2): Design View, Field Properties, & Relationships Add four fields to the table, name/rename them, and set up their data type.Microsoft Access Tutorial (Part 1): Databases, Tables, & Fields This Microsoft Access tutorial will show you how to use Microsoft Access to create a simple database with all the common features such as tables, forms, queries, and macros.

Microsoft access 2013 tutorial forms