Access Project 1 - Brooklyn College

Access Project 1 - Brooklyn College

Microsoft Office 2003 Introductory Concepts and Techniques 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 Access Project 1: Creating and Using a Database 2 Objectives

Close a table Close a database and quit Access Open a database Print the contents of a table Access Project 1: Creating and Using a Database 3

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

Access Project 1: Creating and Using a Database 4 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 Access Project 1: Creating and Using a Database 5 Starting Access Access Project 1: Creating and Using a Database 6

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 Access Project 1: Creating and Using a Database 7

Creating a New Database Insert a formatted USB flash drive 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 USB flash drive Access Project 1: Creating and Using a Database

8 Creating a New Database Click the File name text box Use the BACKSPACE key or the DELETE key to delete db1 and then type Ashton James College as the file name Click the Create button to create the database Access Project 1: Creating and Using a Database

9 Creating a New Database Access Project 1: Creating and Using a Database 10 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 Access Project 1: Creating and Using a Database 11 Creating a Table Access Project 1: Creating and Using a Database

12 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 Access Project 1: Creating and Using a Database 13 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 Access Project 1: Creating and Using a Database 14 Defining the Fields in a Table Access Project 1: Creating and Using a Database

15 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

Access Project 1: Creating and Using a Database 16 Closing and Saving a Table Access Project 1: Creating and Using a Database 17 Adding Records to a Table

Right-click the Client table in the Ashton James College : Database window Click Open on the shortcut menu Type BS27 as the first customer number. Be sure you type the letters in uppercase so they are entered in the database correctly Press the TAB key to complete the entry for the Client Number field Type the following entries, pressing the TAB key after each one: Blant and Sons as the name, 4806 Park as the address, Hammond as the city, TX as the state, and 76653 as the zip code

Access Project 1: Creating and Using a Database 18 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 Access Project 1: Creating and Using a Database 19 Adding Records to a Table Access Project 1: Creating and Using a Database 20

Closing a Table and Database and Quitting Access Click the Close Window button for the Client : Table window Click the Close Window button for the Ashton James College : Database window Click the Close button

for the Microsoft Access window Access Project 1: Creating and Using a Database 21 Opening a Database Start Access following the steps on slide 4 If the task pane appears, click its Close button Click the Open button on the Database toolbar

Access Project 1: Creating and Using a Database 22 Opening a Database Be sure USB flash drive appears in the Look in box. If not, click the Look in box arrow and click USB flash drive

Click Ashton James College Click the Open button in the Open dialog box Access Project 1: Creating and Using a Database 23 Adding Additional Records to a Table Right-click the Client table in the Ashton James

College : Database window, and then click Open on the shortcut menu When the Client table appears, maximize the window by double-clicking its title bar Click the New Record button Add the remaining records shown on the following slide using the same techniques you used to add the first two records Click the Close Window button for the datasheet Access Project 1: Creating and Using a Database 24

Adding Additional Records to a Table Access Project 1: Creating and Using a Database 25 Adding Additional Records to a Table Access Project 1: Creating and Using a Database

26 Previewing and Printing the Contents of a Table Right-click the Client table Click Print Preview on the shortcut menu Point to the approximate position shown here

Access Project 1: Creating and Using a Database 27 Previewing and Printing the Contents of a Table Click the magnifying glass mouse pointer in the approximate position shown on the previous slide Click the Setup button on the Print Preview toolbar

Click the Page tab Click Landscape, and then click the OK button Click the Print button to print the report, and then click the Close button on the Print Preview toolbar Access Project 1: Creating and Using a Database 28 Creating an Additional Table Make sure the Ashton James College database is open Click the New button on the Database window toolbar,

click Design View, and then click the OK button Enter the data for the fields for the Trainer table from the figure on the next slide. Be sure to click the Primary Key button when you enter the Trainer Number field Click the Close Window button, click the Yes button in the Microsoft Office Access dialog box when asked if you want to save the changes, and then type Trainer as the name of the table Click the OK button Access Project 1: Creating and Using a Database 29

Creating an Additional Table Access Project 1: Creating and Using a Database 30 Creating an Additional Table Access Project 1: Creating and Using a Database 31

Adding Records to an Additional Table Right-click the Driver table, and then click Open on the shortcut menu. Enter the Trainer data from the figure on the following slide into the Trainer table Click the Close Window button for the Trainer : Table window Access Project 1: Creating and Using a Database

32 Adding Records to an Additional Table Access Project 1: Creating and Using a Database 33 Using the Simple Query Wizard to Create a Query With the Tables object selected and the Client

table selected, click the New Object button arrow on the Database toolbar Click Query on the New Object list Click Simple Query Wizard, and then click the OK button Click the Add Field button to add the Client Number field Click the Add Field button a second time to add the Name field Access Project 1: Creating and Using a Database 34

Using the Simple Query Wizard to Create a Query Click the Trainer Number field, and then click the Add Field button to add the Trainer Number field Click the Next button, and then type ClientTrainer Query as the name for the query Click the Finish button to complete the creation of the query Click the Close Window button for the ClientTrainer Query : Select Query window Access Project 1: Creating and Using a Database

35 Using the Simple Query Wizard to Create a Query Access Project 1: Creating and Using a Database 36 Using a Query If necessary, click the Queries object. Right-click the Client-Trainer Query

Click Design View on the shortcut menu Click the Criteria row in the Trainer Number column of the grid, and then type 42 as the criterion Access Project 1: Creating and Using a Database 37 Using a Query Click the Run button on the Query Design

toolbar Close the window containing the query results by clicking its Close Window button When asked if you want to save your changes, click the No button Access Project 1: Creating and Using a Database 38

Using the New Object Button to Create a Form Make sure the Ashton James College database is open, the Database window appears, and the Client table is selected If necessary, click the Tables object on the Objects bar Click the New Object button arrow on the Database toolbar Click AutoForm on the New Object list Access Project 1: Creating and Using a Database

39 Using the New Object Button to Create a Form Access Project 1: Creating and Using a Database 40 Closing and Saving a Form Click the Close

Window button for the Client window Click the Yes button Click the OK button Access Project 1: Creating and Using a Database 41 Opening a Form With the Ashton James College database open and the Database window on the

screen, click Forms on the Objects bar, and then right-click the Client form Click Open on the shortcut menu Access Project 1: Creating and Using a Database 42 Opening a Form Access Project 1: Creating and Using a Database

43 Using a Form Click the Next Record button four times Access Project 1: Creating and Using a Database 44 Switching from Form View to Datasheet View Click the View button

arrow on the Form View toolbar Click Datasheet View Click the Close Window button Access Project 1: Creating and Using a Database 45 Creating a Report Click Tables on the Objects bar, and then

make sure the Client table is selected Click the New Object button arrow on the Database toolbar Click Report Click Report Wizard and then click the OK button Click the Add Field button to add the Client Number field Access Project 1: Creating and Using a Database 46

Creating a Report Click the Add Field button to add the Name field Add the Amount Paid and Current Due fields just as you added the Client Number and Name fields Click the Next button Because you will not specify any grouping, click the Next button in the Report Wizard dialog box Click the Next button a second time because you will not need to change the sort order for the records Access Project 1: Creating and Using a Database

47 Creating a Report Make sure that Tabular is selected as the Layout and Portrait is selected as the Orientation, and then click the Next button Be sure the Corporate style is selected, click the Next button, and then type Client Amount Report as the new title Click the Finish button Click the magnifying glass mouse pointer anywhere

within the report to see the entire project Click the Close Window button in the Client Amount Report window Access Project 1: Creating and Using a Database 48 Creating a Report Access Project 1: Creating and Using a Database 49

Printing a Report If necessary, click Reports on the Objects bar in the Database window Right-click the Client Amount Report Click Print on the shortcut menu Access Project 1: Creating and Using a Database

50 Closing a Database Click the Close Window button for the Ashton James College : Database window Access Project 1: Creating and Using a Database 51 Obtaining Help Using the

Type a Question for Help Box Click the Type a question for help box on the right side of the menu bar Type how do I remove a primary key in the box Press the ENTER key Access Project 1: Creating and Using a Database 52 Obtaining Help Using the

Type a Question for Help Box Point to the Remove the primary key (MDB) topic Click Remove the primary key (MDB) Click the Close button on the Microsoft Office Access Help window title bar Access Project 1: Creating and Using a Database

53 Quitting Access Click the Close button in the Microsoft Access window Access Project 1: Creating and Using a Database 54 Summary Describe databases and database

management systems Start Access Describe the features of the Access desktop Create a database Create a table and add records Access Project 1: Creating and Using a Database 55 Summary

Close a table Close a database and quit Access Open a database Print the contents of a table Access Project 1: Creating and Using a Database 56

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

Access Project 1: Creating and Using a Database 57 Microsoft Office 2003 Introductory Concepts and Techniques Access Project 1

Complete

Recently Viewed Presentations

  • Diapositiva 1 - PREHOME

    Diapositiva 1 - PREHOME

    I dati sono in linea con quanto emerso a marzo 2016 da Omeoimprese il 36% degli 8 milioni gli italiani che ricorrono all'omeopatia lo fa anche per i propri bambini
  • Comércio Varejista De Artigos De Otica Aspectos Mais ...

    Comércio Varejista De Artigos De Otica Aspectos Mais ...

    É OBRIGATÓRIO Possuir mobiliário adequado, aparelhos, equipamentos, instrumentos, vasilhames, pia com água corrente e todos os meios necessários às suas finalidades, a critério da autoridade sanitária competente; Perfeitas condições de ordem e higiene; Possuir livro próprio para comercialização de lentes...
  • CRS Powerpoint Template

    CRS Powerpoint Template

    Good and gracious God, Teacher of all peoples, Bless and guide those of us who seek to educate others about your good news of justice and peace. Guide us in our work as we reach out to shape hearts and...
  • La rivière aux crocodiles Baama-Ba

    La rivière aux crocodiles Baama-Ba

    Fatou se met à pleurer. Elle sait que personne ne s'approche jamais de la rivière aux crocodiles Baama-Ba : ni les solides guerriers, ni les femmes du village, ni les mentons poilus, ni les talons rugueux. La rivière aux crocodiles...
  • Gatekeeper Training 2001 - Ottawa County, Ohio

    Gatekeeper Training 2001 - Ottawa County, Ohio

    Ottawa County's Gatekeeper Training 2009 Last update 10-12-09 Your Gatekeeper Trainers Dianne Mortensen Executive Coordinator OC Senior Resources No Wrong Door Sponsors United Way Mental Health and Recovery Board Ottawa Residential Services OCTA WSOS The Ability Center of Ottawa County...
  • Homologous Structures - barren.k12.ky.us

    Homologous Structures - barren.k12.ky.us

    Homologous structures Homologous structures Homologous coloring sheet Humerus - Green Radius- red Ulna - blue Carpals - yellow Metacarpals - purple Phalanges - orange When you are finished glue or tape it into your notebook under your homologous structures sheet.
  • Quantitative Trait Genetics in Health and Disease Caroline

    Quantitative Trait Genetics in Health and Disease Caroline

    Allow family-based linkage-type analyses . Allow parent-of-origin analyses * Enrichment for carriers of rare or novel variants . Allow . de novo . mutation discovery. Helps prediction and verification of sequence-identified variants (by imputation) Value of Family data in ....
  • Title Page - www.bristol.ac.uk | University of Bristol

    Title Page - www.bristol.ac.uk | University of Bristol

    Assessment carried out by CALS team following acute care episode. Identified as requiring changes to care during weekly GP visit to care home/home. Detailed Assessment Required. Care Management by members of Cluster MDT. Shared Care plan available to MDT members.