![]() ![]() From here you can rename the field, delete the field, insert a new field and more. Right clicking on a field name brings up a contextual menu. You can rename fields by right clicking on the field header and selecting Rename Field. You can (and probably should) rename these to something more meaningful. It doesn’t know what data will need to be entered in the future.Īlso, when you create fields in this manner, Access will name each field Field1, Field2, etc. If you use this method, be sure to check the data type. Access can only guess, based on what you entered now. So if you enter say, “Bob”, Access will probably make it a Short Text field. Access will assign a data type to the field based on what you enter. Quick Tip: You can also add new fields by adding data directly into the cell underneath the Click to Add text. Use the following names and data types: Field Name Rename the ID field to CustomerId (see below for how to rename fields). Once you’ve added three more fields, you will have four fields. You can type over the top of this to change the field name to something more meaningful. Once you select a data type, Access will highlight the field header with Field1. Access requires that you assign each field a data type. To add each field, click on the Click to Add header and select the data type (see below for the data types to use). It assigns this field as the primary key for that table. Normally, when you create a table, Access creates the first field called ID with a data type of AutoNumber. For example, no one will be able to enter a phone number into the “FirstName” field. By assigning a data type, Access can make sure that nobody enters the wrong type of data into that field. This data type tells Access the type of data that will be stored in that field. Now the thing is, when you add a field, you must select a data type for the field. You give each field its own name (eg, “CustomerId”, “FirstName”, “LastName” etc). Add Fields to the Tableįields are basically another name for column. ![]() The first thing you need to do is add fields and name them. One of the differences between Access and Excel, is that the tables in Access require some extra setting up before you start adding lots of data. Now, if this was an Excel spreadsheet, you might start adding data right about now. For example, you could have a “Customers” table that stores customer info, a “Products” table that stores info on products that you sell, and an “Orders” table that stores info on which customers ordered which products. Each table stores a different set of data. Most Access databases have lots of tables. So you can click that button any time you need to create a new table. You’ll now have another blank table in your database. Here’s what that button looks like on the Ribbon: Clicking the “Table” icon from the “CREATE” tab creates a new table. Access creates this automatically when you create a new database. Your new database will already have one table called Table1. Clicking the “File” tab will provide options for creating a new database.įor more screenshots and detail, see How to Create a Database in Access. You can also do it from the File menu (from the top menu). ![]() You can now customise this database to your own needs.īut you need not go to the welcome screen every time you want to create a database. And it will look something like this: This is a newly created blank desktop database. That’s all there is to it! You will now be proud owner of a blank database. Name the database at the prompt and click Create.You can create your first database straight from there. ![]() When you first open Access, a welcome screen is displayed. Let’s start by creating a blank database. Add four fields to the table, name/rename them, and set up their data type.This article is Part 1 of the Microsoft Access tutorial. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |