it. internet. windows. ICDL. presentation. word. database. spread sheet. Microsoft Access. First step. Form. Table. Report. Relationship. Main operations. Print. Query. First step. Create a new blank database
An Image/Link below is provided (as is) to download presentation
Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.Content is provided to you AS IS for your information and personal use only.Download presentation by click this link.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.During download, if you can't get a presentation, the file might be deleted by the publisher.
E N D
More Related Content
Presentation Transcript
it internet windows ICDL presentation word database spread sheet
Microsoft Access First step Form Table Report Relationship Main operations Print Query
First step • Create a new blank database • Create a database using the option that will enable you to build your database using pre-set options. • Save this database as Company into desktop. • Log on to the database named library with the username osman and password ali*56 • Which two of these statements about relational database are true? • Close the Company database without closing Microsoft access. • Use Microsoft Access Help to find information about format painter. • Use click and drag to sort these labels into the correct boxes.Click SUBMIT when you have finished. • Which one of the following is not a database? • Which two of the following is not a database?
Which two of these statements about relational database are true? • A non-relational database can be searched mores efficiently than a relational database. • A relational database is easier to maintain than a non-relational one. • In relational database the need for data duplication is increased • Smaller linked tables are harder to manage than one big one. • A relational database is one that contains linked tables. SUBMIT First step
Data base Not a Data base Use click and drag to sort these labels into the correct boxes.Click SUBMIT when you have finished. Sales catalogue Student register Novel Shopping list Customer Records SUBMIT First step
Table • Enter the field name Customer Name into the empty row.When you have finished, move the insertion point to the Data Type column. • Change the enter in the Firstname field of this record to Islam.Move to the next field in this record when you have finished. • Please delete the selected field value, Ahmed, from its record. • Enter the name mai into the first name field. • Using click and drag, move the selected column to between the salary and address column. • Navigate quickly to the last record in this table • Enter a record for a full-time employee name Ahmed Ali into this table. • Save and close this table. • The address field will be used in a lot of searches, so we should index it. Create a suitable index for this field.
Specify that date of birthday field in this table display in the format 10 September 1989. • Which one of the following statements about setting the field size property in a table is True? • Enter the validation rule to ensure that entries into this field must be numbers greater than 30 . Press Enter when you have finished. • Enter the validation rule to ensure that entries into this field must be either the words Full-time or Part-time. • Select the data type that will automatically assign a unique employee ID number to each new employee.Move to the next cell when you have finished. • The customerID field contains a unique reference for each customer . This field will be used in a lot of searches, so we should index it. Create a suitable index for this field. • How many fields would be necessary to store this record and enable maximum flexibility for data retrieval?
Which one of the following statements about setting the field size property in a table is True? • If you change the First Name size proerty to 20, existing data will not change. • If you decrease the First Name field size, data will not be lost. • you can’t change the First Name field size because the table contains data. • If you increase the field size for the First Name field, the data will be processed faster. SUBMIT Table