Penjelasan:

inggris :

key to navigate to the next match, or the key to the previous match "style =" - webkit-font-smoothing: antialiased; box-sizing: border-box; -webkit-tap-highlight-color: transparent; text-size-adjust: none; font-family: inherit; font-size: 14px; margin: 0px; line-height: 22px; -webkit-appearance: textfield; width: 287px; background: transparent; border: 1px solid rgb (204, 204, 204); box-shadow: none; outline: none; padding: 7px 4px; color: inherit; "> MS Access Guide Introduction1 Designing Database Tables 1.1 Component Table 1.2 Creating Tables 1.3 Read Also 2 Forming Relationship Schemes Between Tables 2.1 Key Columns 2.2 Advantages of Using Relationships 2.3 Relationship Schemes 2.4 Also Read 3 Designing Forms for Data Recording 3.1 Creating Forms3. 2 Adding Interaction Keys 3.3 Read Also 4 Performing Data Queries Using SQL 4.1 Accessing SQL from Microsoft Access 4.2 Selecting Columns from a Table 4.3 Performing a Filter on a Table 4.4 Performing Operations to Form a New Column 4.5 Calculating the Aggregate Value of a Variable and Sorting Value 4.6 Combining Two Data Tables 4.7 Other Queries 4.8 Read Also Published with bookdown Chapter 4 Querying Data Using SQL This guide gives readers a brief overview of common queries or operations used to extract data in relational databases. Things that will be learned include: Access SQL from Microsoft Access Select a column from a table Perform a filter on data Perform operations to form a new column Calculate the aggregate value of a variable and sort the value Combine two other data tables Query In Chapter 4, we will use the relational database schema shown in Figure 1.2. 4.1 Accessing SQL from Microsoft Access To perform a query using SQL, run the following steps: On the Ribbon, click the Create tab, click Query Design, close the Show Table window that appears afterwards On the Design Ribbon click SQL View In the query window that appears, the reader can type the desired query. After the query is inputted, click Run The process will generate a data table according to the input query. To re-edit the inputted query, click View and select SQL View. To save the query press ctrl + s (for windows) or command + s (for macOSX). Figure 4.1: stages of performing a query using SQL. 4.2 Selecting Columns from a Table To select a column in a table, we can use the SELECT command to specify the column name to be retrieved and FROM to specify the table to retrieve the column. In simple terms the process is shown in Figure 4.2. Figure 4.2: Format selecting columns in a table.