#OPEN DVD PRODUCER TUTORIAL HOW TO#

Notice that the ID field is an AutoNumber field so Access automatically increments the numbers for you as each record is entered. When you are done, return to Datasheet view by clicking the View button and continue to enter your data. Select the field and, in the General tab, increase the value in the Field Size area to allow more room. To do this, click the View button in the top left of the window to return to Design view. If there is too much data to fit into one column, for example, you may have too much information to go into the MajorStars column, you can make the column wider. Type the details for five or six of your DVDs into the list by typing the details into one column, and press Tab to move to the next column to enter the data there. You're now ready to enter some sample data into the file. The first step is to create a structure for recording your data. Click the View button at the far left of the toolbar and, when prompted, save your table and call it DVDs. Right click and choose Primary Key to set this field as the data table's primary key for sorting data. When you're done, click the box to the left of the field name ID to select this row. Continue until all the fields are entered. To enter a field, type the field name, press Tab, type or select the field data type and then continue to the next field. All are character field types except ID which is an AutoNumber field, Year and Length are Number fields and DateLent is a Date/time field. Use the fieldnames ID, Title, Category, MajorStars, Producer, Director, Year, Rating, Length, Borrower, and DateLent.

Here you enter the column headings for your table and each Data type.

When the Database dialog appears, click Tables in the Objects list and click Create table in Design view. To create a database for this, launch Access, choose File, New, Blank Database, type a name for your database (DVDs) and click Create. This is a sample list of fields you may use to record your DVD collection: ID, Title, Category, MajorStars, Producer, Director, Year, Rating, Length, Borrower, DateLent Create a data structure For example, to know who has borrowed a DVD you will need a field to record the title of the DVD and one to record the name of the person you have lent it to. To do this work out what information you expect the database to provide you with. To create a database to store the details of your collection, start by determining what data you need to record. If you lend your DVDs to friends you can track this data to so you know where they are. Getting startedĬonsider this scenario you have a lot of DVDs and you'd like to keep track of them.

#OPEN DVD PRODUCER TUTORIAL HOW TO#

Along the way you will learn how to create the database, record information and query the data file – all the basic skills needed to manage any data file. I'll show you how to create a simple database table to store information about your DVD collection – although the process is similar for any type of collection. In fact, Access in spite of its size, is relatively easy to use and offers features such as Wizards which step you through typical processes such as querying the database and creating data entry forms. While it is true that Access is a powerful database program, it is also useful for recording and managing simple lists of data. You have probably heard of Microsoft Access, but you may never have used it fearing that it is complicated and more than you need for simple lists. I'll show you how to get started tracking a DVD collection (or any other collection) using your own custom designed Microsoft Access database. Helen Bradley Learn how to restore order to your DVD collection with a database.

Open dvd producer tutorial