Creating and Managing Tables in Microsoft Access: A Step-by-Step Guide, Slides of MS Microsoft Office skills

Download Creating and Managing Tables in Microsoft Access: A Step-by-Step Guide and more Slides MS Microsoft Office skills in PDF only on Docsity!

Access Project 1

Creating and Using a Database

Objectives

• Describe databases and database management systems
• Start Access
• Describe the features of the Access desktop
• Create a database
• Create a table and add records

Objectives

• Create and use a simple query
• Create and use a simple form
• Create and print a custom report
• Design a database to eliminate redundancy

Starting Access

• Click the Start button on the Windows taskbar, point to All Programs on the Start menu, and then point to Microsoft Office on the All Programs submenu
• Click Microsoft Office Access 2003
• If the Access window is not maximized, double-click its title bar to maximize it

Closing the Language Bar

• Right-click the Language bar to display a list of commands
• Click Close on the Language bar
• Click the OK button

Creating a New Database

• Insert a formatted floppy disk in drive A
• Click the New button on the Database toolbar to display the task pane
• Click the Blank Database option in the task pane, and then click the Save in box arrow
• Click 3½ Floppy (A:)

Creating a New Database

Creating a Table

• Click the New button on the Database window toolbar
• Click Design View and then click the OK button
• Double-click the title bar of the Table1 : Table window to maximize the window

Defining the Fields in a Table

• Type Client Number (the name of the first field) in the Field Name column and then press the TAB key
• Because Text is the correct data type, press the TAB key to move the insertion point to the Description column, type Client Number (Primary Key) as the description, and then click the Primary Key button on the Table Design toolbar
• Press the F6 key
• Type 4 as the size of the Client Number field
• Press the F6 key to return to the Description column for the Client Number field, and then press the TAB key to move to the Field Name column in the second row

Defining the Fields in a Table

• Use the techniques illustrated in the previous four steps to make the entries from the Client table structure shown on the following slide, up through and including the name of the Amount Paid field
• Click the Data Type box arrow
• Click Currency and then press the TAB key
• Make the remaining entries from the Customer table structure shown on the following slide

Closing and Saving a Table

• Click the Close Window button for the Table1 : Table window (Be sure not to click the Close button on the Microsoft Access title bar, because this would close Microsoft Access)
• Click the Yes button in the Microsoft Office Access dialog box, and then type Client as the name of the table
• Click the OK button in the Save As dialog box

Closing and Saving a Table

Adding Records to a Table

• Type 21876 as the Amount Paid amount and then press the TAB key
• Type 892.50 as the current due amount and then press the TAB key
• Type 42 as the trainer number to complete data entry for the record
• Press the TAB key
• Use the techniques shown in the previous four steps to add the data for the second record shown on the following slide

Adding Records to a Table